|iPhone | Android | Blackberry|
NEW WITH VERSION 5.0 and above
You have the option of reverting back to the previous 'Sheet To Go' version, so that you can edit your file. You can do so by following these steps: Open Docs To Go and go to More/Settings/Help and under Advanced Options, turn the Legacy Spreadsheets option from 'Off' to 'On'.
Background: We have introduced greater protection against corrupting files in specific cases where functions and/or tables are not technically supported, and have thus set these files to 'read-only' in the latest version.
To insert a row:
1. Tap and hold on the column or row header below where you would like the new column/row inserted.
2. You will then see options to Cut, Copy, Insert/Delete, Hide/Unhide.
3. Select Insert/Delete and you will get the option to Insert Rows (or columns) or Delete Rows (or columns).
NOTE: An inserted row will be added above the selected row. An inserted column will be inserted to the left of the selected column.
The following is a list of file formats supported in Documents To Go for iPad/iPhone/iPod touch, as well as how each format is supported (view/edit/create, view-only, etc):
Editing & Viewing
iWork '08 & '09:
Cloud Accounts (iPad, iPhone 4 or higher or other iOS 5 or higher device)
All of the above formats are supported via synchroniztion with supported online/cloud storage accounts in Documents To Go Premium on the device.
In addition to the formats supported via cloud storage, synchronization with Google Drive also supports converted versions of OpenDocument Text (odt), OpenDocument Spreadsheet (ods), Rich text (rtf), and Comma-separated values (csv) files.
Click here to view the user manual.
If you previously purchased Documents To Go for iPad/iPhone/iPod touch but have uninstalled it on your device, you can reinstall it to your iOS device by following the steps below:
If you have difficulty redownloading Documents To Go, or if the App Store tries to charge you to purchase it again, click here for troubleshooting information on Apple's support site.
Premium Upgrade (In-app purchase / Store):
If you used the in-app purchase option to upgrade to the Premium version of Documents To Go and you need to reinstall it, do not download "Documents To Go Premium" from the App Store or you will be charged for it. Instead, locate and reinstall the standard "Documents To Go" app that you originally purchased. Once you have reinstalled it, follow these steps:
After a moment, the Premium features will be re-enabled.
Please be sure you can make an internet connection on both your device and your computer.
Please note that if your device is not named, this is a reason that the device may not be listed. If your device is not listed, try clicking where it says “no devices found” in the window that should list devices found on the network.
Documents To Go relies on Bonjour to discover the device on the network. If Bonjour cannot find your device, there is no way to pair it with the Desktop application. There are a couple of reasons why Bonjour cannot discover the device on the network:
1. Bonjour is not enabled. To ensure that Bonjour is enabled, open iTunes on your computer and follow these steps:
2. Bonjour needs to be repaired. To repair Bonjour:
Please be sure that Documents To Go is open on your device.
Firewall software such as Norton Antivirus, AVG Anti-Virus, ZoneAlarm and others can prevent Documents To Go Desktop or Bonjour from communicating with your device (Bonjour is technology from Apple for discovering wireless devices).Sometimes, a firewall may be blocking Documents To Go or Bonjour. To check if your Firewall is causing the problem, please follow these steps:
If you use VPN on your computer, it may be causing a conflict with Bonjour or Documents To Go. If you use VPN and it is on, you will need to see if it causing a conflict by following these steps:
Please verify/try the following:
To "re-pair" the Desktop and the iOS device, follow these steps:
If the above suggestions do not work, try the following:
1. Temporarily disable your firewall, antivirus software, or internet security software installed
2. Ensure that Bonjour is enabled. Enable the Bonjour service (Windows only) by doing the following: Go to your Control Panel, choose "Administrative Tools", choose "Services." Right click on "Bonjour" and choose "Start"
3. Repair Bonjour.
Follow these steps:
Next, reopen Documents To Go on both your computer and your device. In Documents To Go Desktop on the computer, go to the Options menu (Windows) or the Device menu (Mac) and select "Add Device" (or it may automatically run the Add Device Wizard). Follow the steps in the Add Device Wizard to complete the pairing, then try to synchronize.
The Documents To Go Desktop application is intended for your desktop or laptop computer running a Windows or Macintosh operating system. Please download the desktop application to your desktop or laptop computer.
You may receive various error messages for the following reasons:
Documents To Go supports the majority of Excel spreadsheet functions. If a spreadsheet contains a function not supported by Documents To Go, the file will be locked on the device. Below is a list of Excel spreadsheet functions supported by Documents To Go. For more detailed information about each function, please refer to the Help file in Excel.
|Unary -||Subtraction negation||Arithmetic Operator|
|=||Equal to||Comparison Operator|
|<>||Not equal to||Comparison Operator|
|<=||Less than or equal to||Comparison Operator|
|>=||Greater than or equal to||Comparison Operator|
|<||Less than||Comparison Operator|
|>||Greater than||Comparison Operator|
|&||Connects, or concatenates, two values to produce one continuous text value||Text Operator|
|DATE (yr, mon, day)||The date number of yr, mon, day||Date & Time|
|DAY(date number)||The day number of date number||Date & Time|
|HOUR(time number)||The hour number of time number||Date & Time|
|MINUTE(time number)||The minute number of time number||Date & Time|
|MONTH(date number)||The month number of date number||Date & Time|
|NOW()||The serial number for the current date and time||Date & Time|
|SECOND(time number)||The second number of time number||Date & Time|
|TIME(hr, min, sec)||The time number of hr, min, sec||Date & Time|
|TIMEVALUE(time_text)||The year number of a date||Date & Time|
|TODAY()||The serial number for the current date||Date & Time|
|WEEKDAY(date number, flags)||The weekday number of date number (flags specifies what number gets mapped to what day)||Date & Time|
|YEAR(date number)||The year number of date number||Date & Time|
|DDB(cost, salvage, life, period, factor)||Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify||Financial|
|FV(pmt, int, term)||The future value of a series of equal payments, each of amount pmt, earning periodic interest rate int, over the number of payment periods in term||Financial|
|IRR(range, guess)||The internal rate of return for the series of cash flows in range, based on the approximate percentage guess of the IRR||Financial|
|NPER(rate, pmt, pv, fv,type)||The number of periods for an investment with interest rate per period, payment pmt for each period, present value pv, [and future value fv], base a constant rate, given the type (indicating payment due at the end (0) or beginning (1), default (0)||Financial|
|NPV(int, range list)||The present value of the series of future cash flows in range list, discounted at periodic interest rate int||Financial|
|PMT(prin, int, term)||The amount of the periodic payment needed to pay off principle prin, at periodic interest rate int, over the number of payment periods in term||Financial|
|PV(pmt, int, term)||The present value of a series of equal payments, each of amount pmt, discounted at periodic interest rate int, over the number of payment periods in term||Financial|
|RATE(nper, pmt, pv, fv,type, guess)||The interest rate per period for an annuity with nper total number of payment periods, pmt payment for each period, present value pv, [and future value fv], given the type (indicating payment due at the end (0) or beginning (1), default (0)||Financial|
|SLN(cost, salvage, life)||Returns the straight-line depreciation of an asset for one period.||Financial|
|SYD(cost, salvage, life, per)||Returns the sum-of-years' digits depreciation of an asset for a specific period.||Financial|
|AND(list)||Returns TRUE if all its arguments are TRUE; returns FALSE if one or more arguments is FALSE.||Logical|
|OR(list)||Returns TRUE is any argument is TRUE; returns FALSE if all arguments are FALSE.||Logical|
|NOT(x)||Reverses the value of its argument.||Logical|
|TRUE()||Returns the logical value TRUE.||Logical|
|FALSE()||Returns the logical value FALSE.||Logical|
|IF(cond, x, y)||Returns x if condition is TRUE, and y if FALSE||Logical|
|CHOOSE(index, number, value1, value2)||Returns a value from a list of values.||Lookup & Reference|
|COLUMNS(array)||Returns the number of columns in a reference.||Lookup & Reference|
|HLOOKUP(x, range, row number, exact match)||The contents of the cell in row row number which lies directly below the cell in the top row of range that matches x. Row number is relative to the top of the table. The match to x may or may not have to be anexact match.||Lookup & Reference|
|INDEX(reference, row_num, column_num area_num)||Uses an index to choose a value from a reference.||Lookup & Reference|
|MATCH(lookup_value, lookup_reference, match_type)||Looks up values in a reference||Lookup & Reference|
|ROWS(array)||Returns the number of rows in a reference||Lookup & Reference|
|VLOOKUP(x, range, column number, exact match)||The contents of the cell in column column number which lies directly across from the cell in the first column of range that matches x.Column number is relative to the left of the table. The match to x may or may not have to be an exact match.||Lookup & Reference|
|ABS(x)||The absolute value of x||Math & Trig.|
|ACOS(x)||The arc cosine of angle x||Math & Trig.|
|ASIN(x)||The arc sine of angle x||Math & Trig.|
|ATAN(x)||The arc tangent of angle x||Math & Trig.|
|ATAN2(x, y)||The arc tangent of angle y/x||Math & Trig.|
|COS(x)||The cosine of angle x||Math & Trig.|
|COUNTIF(range, criteria)||Counts the number of non-blank cells within a range that meet the given criteria||Math & Trig.|
|DEGREES(x)||x*180/p||Math & Trig.|
|EVEN (number)||Rounds a number to nearest even integer. Negative numbers are adjusted away from zero.||Math & Trig.|
|EXP(x)||The number e raised to the xth power||Math & Trig.|
|FACT(number)||Returns the factorial of a number||Math & Trig.|
|INT(x)||Rounds a number down to the nearest integer||Math & Trig.|
|LN(x)||The natural log of x||Math & Trig.|
|LOG(number, base)||Returns the log of a number to a specified base.||Math & Trig.|
|LOG10(x)||The log (base 10) of x||Math & Trig.|
|MOD(x, y)||The remainder of x/y||Math & Trig.|
|ODD (number)||Rounds a number up to the nearest odd integer.||Math & Trig.|
|PI()||The number p||Math & Trig.|
|POWER(number, power)||Returns the result of a number raised to a power.||Math & Trig.|
|PRODUCT(number1, number2)||Multiplies its arguments||Math & Trig.|
|RADIANS(x)||x*p/180||Math & Trig.|
|ROUND(x, n)||x rounded to n places||Math & Trig.|
|SIN(x)||The sine of angle x||Math & Trig.|
|SQRT(x)||The positive square root of x||Math & Trig.|
|SUM(list)||The sum of the values in list||Math & Trig.|
|SUMIF(range, criteria, sum_range)||Adds the cells specified by a given criteria||Math & Trig.|
|TAN(x)||The tangent of angle x||Math & Trig.|
|TRUNC(number, num_digits)||Truncates a number to an integer||Math & Trig.|
|AVERAGE(list)||The average of the values in list||Statistical|
|COUNT(list)||The number of non-blank entries in list||Statistical|
|COUNTA(list)||How many values are in the list of arguments||Statistical|
|COUNTBLANK(range)||Counts the number of blank cells in a range||Statistical|
|MAX(list)||The maximum value in list||Statistical|
|MIN(list)||The minimum value in list||Statistical|
|STDEV(list)||The sample standard deviation of the values in list||Statistical|
|STDEVP(list)||The population standard deviation of the values in list||Statistical|
|VAR(list)||The sample variance of the values in list||Statistical|
|VARP(list)||The population variance of the values in list||Statistical|
|CONCATENATE(string)||Concatenates a list of strings or values together||Text|
|EXACT(text1, text2)||Checks to see if two text values are identical||Text|
|FIND(find_text, within_text, start_num)||Finds one text value within another (case-sensitive)||Text|
|LEFT(text, num_chars)||Returns the leftmost characters from a text value||Text|
|LEN(text)||Returns the number of characters in a string||Text|
|MID(text, start_num, num_chars)||Returns a specific number of characters from a text string||Text|
|PROPER(text)||Capitalizes the first letter in each word of a text value||Text|
|REPLACE(old_text, start_num, num_chars, new_text)||Replaces characters within text||Text|
|REPT(text, number_times)||Repeats text a given number of times||Text|
|RIGHT(text, num_chars)||Returns the rightmost characters from a text value||Text|
|SUBSITUTE(text, old_text, new_text, instance_num)||Substitutes new text for old text in a text string||Text|
|T(value)||Converts its arguments to text||Text|
|TRIM(text)||Removes spaces from text||Text|
|UPPER(text)||Converts text to uppercase||Text|
|VALUE(string)||String that looks like a number in its actual numeric value||Text|
|DAVERAGE(database, field, criteria)||Averages the values in a column in a list or database that match conditions you specify.||Database|
|DCOUNT(database, field, criteria)||Counts the cells that contain numbers in a column in a list or database that match conditions you specify.||Database|
|DCOUNTA(database, field, criteria)||Counts the nonblank cells in a column in a list or database that match conditions you specify.||Database|
|DGET(database, field, criteria)||Extracts a single value from a column in a list or database that matches conditions you specify.||Database|
|DMAX(database, field, criteria)||Returns the largest number in a column in a list or database that matches conditions you specify.||Database|
|DMIN(database, field, criteria)||Returns the smallest number in a column in a list or database that matches conditions you specify.||Database|
|DPRODUCT(database, field, criteria)||Multiplies the values in a column in a list or database that matches conditions you specify.||Database|
|DSTDEV(database, field, criteria)||Estimates the standard deviation based on a sample, using the numbers in a column in a list or database that matches conditions you specify.||Database|
|DSTDEVP(database, field, criteria)||Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that matches conditions you specify.||Database|
|DSUM(database, field, criteria)||Adds the numbers in a column in a list or database that matches conditions you specify.||Database|
|DVAR(database, field, criteria)||Estimates variance based on a sample, using the numbers in a column in a list or database that matches conditions you specify.||Database|
|DVARP(database, field, criteria)||Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that matches conditions you specify.||Database|
|ERROR.TYPE(error_val)||Returns a number corresponding to an error type||Informational|
|ISBLANK(value)||TRUE if the value is blank||Informational|
|ISERR(value)||TRUE if the value is any error except #N/A||Informational|
|ISERROR(value)||TRUE if the value is any error value||Informational|
|ISLOGICAL(value)||TRUE if the value is a logical value||Informational|
|ISNA(value)||TRUE if the value is the #N/A||Informational|
|ISNONTEXT(value)||TRUE if the value is not text||Informational|
|ISNUMBER(value)||TRUE if the value is a number||Informational|
|ISTEXT(value)||TRUE if the value is text||Informational|
|N(value)||Returns a value converted to a number||Informational|
|NA()||Returns the error value #N/A||Informational|
Yes, Documents To Go can synchronize with multiple desktop computers by using the Documents To Go Desktop program, or by using an online "cloud storage" service.
Documents To Go can be set up to synchronize with the "Documents To Go Desktop" program on multiple computers. Each computer will have its own separate sync folder in the "Desktop Files" section in Documents To Go on the device, and each sync folder on the device will only synchronize with its associated computer. If you want to copy files between different computers, you can open a file in Documents To Go and do a "Save As" to save a new copy of it to another desktop sync folder. However, it would be a separate copy of the file and would not synchronize changes with the original.
Cloud Storage Synchronization(Documents To Go Premium only)
Documents To Go Premium supports synchronization with several online "cloud storage" services. You can download and edit files from your online account directly in Documents To Go, and synchronize your changes back to that account. Most (if not all) of the supported cloud storage services have their own options to synchronize your online files with one or more desktop computers. Therefore, if you edit or create files in Documents To Go and sync them to your online account, the online account can synchronize them to your desktop computer(s).
You can download files from your online account directly to Documents To Go on the device, and any changes you make can be saved and synchronized back to that online account. You can also create new files in Documents To Go and upload them to your account.
There is no actual spell check feature in Documents To Go; we use the built-in Auto Correct Technology. If Auto-Correct is not working when you are using Documents To Go, that is because the iOS setting is turned off. To turn it back on, go to the General Settings on your device. Scroll down and select 'Keyboard'. In the top box, there should be an option for Auto Correction. Slide this option from 'Off' to 'On'.
To edit your document, tap anywhere on the screen and then select the pencil icon in the top right corner. Your file will then be switched to Edit mode!
To sort a row in Sheet To Go, tap on the formatting "pen" on the top green bar to bring up the formatting menu. Then tap on the A for the cell formatting options and tap the Sort button.
Our PowerPoint engine has been completely re-engineered from the ground up to greatly improve the viewing and editing capabilities. The viewing experience now includes enhancements not found in previous versions such as SmartArt. In addition, we've greatly improved the integrity of other slide objects such as charts and images. The editing has also been immensely improved, most evident in the ability to edit text on the individual slides themselves (instead of in Outline View only, which was what was previously supported). Finally, the speed that the slide renders has also been upgraded. With all these improvements, however, there were some items that had to be temporarily removed in order to get this update out to our customers sooner. Specifically, the ability to create new PowerPoint files did not make this release, nor did the ability to create or edit Notes. Rest assured that this is currently slated as a "must update" and will be available soon to Premium users.
To attach multiple documents to an email, do the following:
1. Open Documents To Go and find the files that you want to mail (they must all be in one section for this to work. For example, you can send more than one "local" file (those listed on your iPhone/iPad tab, but not one from the iPhone tab and one from Google Drive).
2. Tap More >> Select (if you are using an iPad, you can simply tap on the check mark in the top right corner).
3. Tap on the documents that you want to send in the email then tap on the envelope icon on the bottom toolbar.
4. This will open a new email, with the files attached!
To select multiple cells, tap and hold. You will see dotted lines appear around the cells you are selecting. Then simply "drag" to select multiple cells. The same method can be used to select multiple columns or rows.
Single and multiple rows or columns may be frozen in a spreadsheet. To freeze a row or column, select it, and tap the Freeze Panes icon at the bottom of the screen Once the chosen area is frozen, that area will remain on screen while you're able to pan the rest of the unfrozen document. To freeze both a row and a column, select a single cell and tap the Freeze Panes icon at the bottom of the screen. The panes will be frozen around that cell.
You can use whichever method you like. Both methods are described below:
Move files & folders into the My DocsToGo folder:
The first time you successfully pair your iPad/iPhone/iPod touch with the Documents To Go Desktop application, a folder named "My DocsToGo" will be created in the Documents folder on your computer, and a shortcut to this folder will be created on the Desktop:
This folder will automatically be added to Documents To Go Desktop. Simply move files (or folders containing files) into the My DocsToGo folder, and they will be copied to the device the next time you synchronize.
Add folders to the Documents To Go Desktop application:
Instead of moving files & folders into the My DocsToGo folder, you can add additional folders to Documents To Go Desktop by dragging & dropping them into the program (or by using the "Add Folder" button). These folders will sync with the device the same way the My DocsToGo folder does.
After adding a folder, you can double-click on it in the Documents To Go Desktop program (or use the "Edit Folder" button) to see list of all the supported items that exist within that folder. By default, all supported items inside the folder will be synchronized (you can uncheck any items that you do not want to sync to your device).
NOTE:If you remove a folder from Documents To Go Desktop, it will not be deleted from your computer, but it will no longer sync with your device.
Back to top
The in-app purchase process takes place through the App Store, and will add the purchased features to your existing version of Docs To Go.
NOTE: Although you will have the upgraded features, the icon for "DocsToGo" on your iPad/iPhone/iPod touch will remain the same vs. changing to the "Premium" version of the icon. This is normal, because technically the standard version of Documents To Go is installed (upgrades are like invisible "add-on" apps).
|If you purchased Premium edition directly from the App Store, the icon will look like this:||If you upgrade from the standard edition to the Premium edition, the icon will look like this:|