iPad Help

iPhone users please refer to iPhoneHelp page.TabChart has two main pages and several views. The first page you see once you start the App is the main page for file management. Once you open a file, TabChart switch to a view page. You can click the exit icon to go back to the main page. 
Please email encgoo@gmail.com for any question. Please check the Getting Started page as well.

Main Page

When you start TabChart, you are shown the main page, which is used for file management.

Icons bar

Icons are categorized into two groups: Folder tool icons and file tool icons. They are for operations on folders or files respectively.

Folder tool icons

Folder icons are shown in the following image. 
From left to right we have:
  • Network icon: Click to show the storage selection view. Please refer to the Storage Selection View below for details.
  • BackUp icon: Back up to the parent folder.
  • Insert icon: Insert a new (empty) subfolder in the current folder. A popup will be shown for entering the name of the new subfolder.
  • Delete icon: Delete the selected subfolder.
  • Rename icon: Rename the selected subfolder. A popup will be shown for entering the new name.
  • Actions (version 2.3): Login to Dropbox or Box.net. You can also logout from those two cloud storage. Please note that before you login, the button title shows as "Login" instead of "Logout".

File tool icons

File tool icons are shown in the following image.
From left to right we have:
  • Email icon: Email the selected file.
  • Table icon: Open a new (empty) CSV file. 
  • Duplicate icon: Duplicate the selected file. It will be named as CopyOf_xxx, where xxx is the original name.
  • Cut icon: Use for moving a file. First select a file, and then click this icon. This icon then changes into a "Copy into" icon. Browse to the destination folder, and click this icon again. The file selected will be moved.
  • Rename icon: select a file and click this icon to rename.
  • Upload/Download icon: If you are view files on you iPad, this is shown as upload icon. Once clicked, the selected file will be uploaded to Dropbox. If you are viewing files stored in your Dropbox account, click this icon will download it into your iPad.
  • Camera icon: export the selected image file to Photo Album of your iPad. So you can print or move it further to other application.
  • Trash icon: Delete the selected file.
  • Information icon: Click for help.

Folder browser

The folder browser shows all the subfolder in the current folder. On start up, the current folder is the Documents folder of TabChart. The first time you start TabChart this is empty. You can use the "Insert icon" to create new subfolders. Once you have subfolders, you can double click a subfolder to enter it. Use the BackUp icon to go back to the parent folder.

File browser

The file browser shows all the files stored under the current folder. When you first start TabChart, the file browser is empty. You can download files from Dropbox, or use Open-In to import CSV files.
TabChart supports CSV files and JPG files. 

Storage Selection 

If you click the "Network" icon, the Storage Selection will show up. You can select either Dropbox or My iPad. If you select My iPad, files stored locally in your iPad will be show in the folder/file browser. If you select Dropbox, files stored in your Dropbox account will be shown. 
Note that the first time you select Dropbox, TabChart will be switched to Safari, and you need to login to your dropbox account. Then you select Allow TabChart to connect to your Dropbox account. Safari will switch back to TabChart. Now you click Dropbox again, files will be shown. Once you are linked to Dropbox, you don't need to go through Safari anymore. (Please note that Box.net integration is added to Version 2.3).

Viewer Page

Once you import CSV files into TabChart, you can double click it to open. This will start the Viewer Page. The following is a CSV file exported from Excel 2010 on Mac, imported via Dropbox. When a file is open, the Viewer Page is shown in full table view. 
The Viewer Page contains a tool bar.

Tool bar

The tool bar is shown in the following image.
From left to right:
  • Slide icon: This slide the tableview up and down. There are three positions, namely full table view, full chart view and half-and-half view. Clicking this icon will cycle through these three modes.
  • Chart icon: Select what kind of chart to render. You can choose from 2D/3D bar chart, stack bar chart, line chart, or area chart.
  • Setting icon: Change the color of a column/row in the chart. You need to select the column/row first by clicking the letter for a column, or the number for a row. For example, you can click "B" and then click this icon to change the color for the second column in the chart. You can also change the alignment for a column here. Again select the column first. Finally you can change the table style. There are 8 built-in styles here. Select one, and click OK.
  • Save icon: After you modify your CSV file, click this to save. Please refer to the Save Popover for details.
  • Export icon: You can export the table or the chart into a JPG file. Note that when you are viewing Full Table mode, the table view will be exported to JPG. Otherwise the Chart will be exported to a JPG.
  • Note icon: Click this to show a yellow sticker. If no cell is selected, the yellow sticker belongs to the file. If a cell is selected, the note belongs to the selected cell. A cell is selected by click and hold on a cell
  • Edit icon: select here to delete/insert column/row. You need to select a column/row first.
  • Information icon: Click for a brief help.
  • Filename: Shows the current file name.
  • Exit icon: back to the main page.

Extended keyboard

When you click and hold on a cell, the keyboard shows up for editing. The extended keyboard is shown on top of the keyboard, and it can help to simplify the editing job. There are four arrow buttons shown in the extended keyboard. They can be used to move to the left/up/down/right cell. The other 6 are function buttons, used for entering formulas. For example, clicking the SUM button will enter "=SUM(" into the selected cell.

Popovers

There are two important popovers, namely the setting popover and the save/export popover.

Setting popover

When you click the setting icon, this popover shows up.

You can select color by clicking inside the color wheel. Then adjust the brightness by moving the slide. The color you generate will be shown in the Color Preview.
You can also change the alignment for the select column.
The last section is for table style. You can pick one from the 8 built-in styles.
Click OK to apply the change.
Version 2.2:

Color Styles (Version 2.3)

Version 2.3: New features in Version 2.3 include:

  • Start index for chart: You can specify where to start the chart. For example if the table is hugh, the row you select might contain dozens of columns, and the screen might not be big enough to show all. You can then select for example the start index to be 20. Then the chart will show columns from the 20th, instead of from 1st.
  • Color Style: Be default, the chart is shown in different colors. You can change the color for each row or column. Or you might want to choose the built-in Color Style. Click the Color Style button, and you will see the following.

  • Click one of them and then click OK. For example, if you pick the first one in the 3rd row, you will get a chart like this.

Save/Export popover

When you click the Save icon or the Export icon, this Popover shows up for you to select the place. It shows the subfolders and files under the Documents folder of TabChart. You can click a folder to enter it, click the back button on top to move up to the parent folder. If you click on an existing file, that file will be REPLACED by the current file. Or you can click the Save As button, then a popup will show up to take the filename. 

FAQ

How to enter data into a cell?

Click on the cell you want to modify, the keyboard will appear. This is the same for data entry, data modification, and data deletion.

When exporting a CSV file from Excel and import to TabChart, the formats are all gone?

The CSV file format doesn't support format/style information. As a matter of fact, Excel remove all the formula, and replace them with fixed data when it exported an Excel file into a CSV file. 
Only the raw data is exported and stored in the CSV file, and all the formatting and styling are not carried by the CSV file.

When a CSV file generated by TabChart is exported to Excel for modification, and imported back to TabChart, the original formatting/styling is messed up?

Again, the CSV file doesn't carry the formatting and styling information. TabChart uses the cell position to record the styling information. If a CSV file is exported and modified, the positions of cells are altered, and the mapping is messed up. When a CSV file is modified and imported back, it is better to name it as a new copy and re-assign format and style.

I login to Dropbox from AnnotDoc, and don't see any document?

In your Dropbox account, there is a folder call Apps. Once you accept AnnotDoc to access your Dropbox account, a folder called AnnotDoc will be created under the Apps folder of you Dropbox account. For security reason, AnnotDoc can only access this folder. You need to move the files you want to this folder first.
Comments