E-droid-cell Help Pages

E-droid-cell

Last Update: 2011-03-19

Online Help

  1. How-To's Online YouTube videos...

Offline Help

  1. Default [View] Mode
  2. Creating New Workbook
  3. Entering [Edit] Mode
  4. Using (or Disabling) AutoComplete Feature
  5. Exit [Edit] Mode
  6. [Edit] mode data types (dates, money, formula...)
  7. Smart style copy
  8. Smart formula copy
  9. [Edit] mode toolbar features
  10. Copy and paste data
  11. Creating and editing charts
  12. e-Droid-Cell Macros...
  13. E-droid-cell FAQ
  14. File selector
  15. Light or Pro Features Comparison
  16. Excel Functions Reference

Default [View] Mode

The default mode is the "View" mode, which means you can move the current worksheet with your finger in order to see all parts of that sheet. You can also zoom IN and OUT.

Creating New Workbook

The only way to create a new workbook is to start the application icon. At start up a default basic file selector will appear: open your Android menu (refer to your device physical 'Menu' button) like shown in the following picture. Select the 'New workbook' menu item.

Creating a new worksheet...

New worksheet creation

Entering [Edit] Mode

Editing a workbook is easy: click on any cell content and hold down for 1 second like shown in the following picture. Tip: you may require to Zoom-IN first in order to make cell selection easier.

Entering [Edit] mode...

Click on a cell value and
hold down for 1 second

WARNING:

Using (or Disabling) AutoComplete Feature

Note: To disable the AutoComplete feature you can do so from the preferences screen: press your device [menu] button from the worksheet view and select [More] and then [Preferences].

The AutoComplete (E-droid-cell Pro only) feature in E-droid-cell anticipates what you might want to enter next based upon text you previously entered. AutoComplete reduces errors and speeds up your work. The AutoComplete feature comes into play only when you're entering a column of text entries. AutoComplete looks at the kinds of entries that you make in a column and automatically duplicates them in subsequent rows whenever you start a new entry that begins with the same letter or letters as an existing entry. For example, if you enter Jack Sprat Diet Centers in cell A2 of a worksheet and then move the cell cursor down to cell A3 in the row below and type J (lowercase or uppercase, it doesn't matter), AutoComplete immediately suggests "Jack Sprat Diet Centers" below the entry box. Then you can press this proposal so you don't have to type the rest of it.

AutoComplete duplicates a previous entry if you start a new entry in the same column that begins with the same letter. However, if you want to type a different entry that begins with the same letter as another entry in the same column, rather than chosing AutoComplete's suggestion, you would just continue typing the entry (ignoring AutoComplete) and then press OK when the entry is complete. If you find that the AutoComplete feature is making it difficult for you to enter a series of cell entries that all start with the same letter but are otherwise not alike, you can turn off the AutoComplete feature. To disable the AutoComplete feature you can do so from the preferences screen: press your device [menu] button from the worksheet view and select [More] and then [Preferences].

Exit [Edit] Mode

To leave the [Edit] mode you just have to press the back button of your device.

WARNING:

[Edit] mode data types

When entering a value, cell's type gives the application the nature of the data itself


Data types

Smart style copy

E-droid-cell offer an easy way to replicate cell styles. If you want to apply a specific cell's style to a range of cells then use the Smart style copy. Here are the steps:

  1. Apply all formats transformations to a single cell. For instance apply italic, bold, font color, cell borders...
  2. Press the copy tool then select Smart style copy
  3. Select the range of cells you want to apply the style on
  4. Press the paste tool then select Smart style paste

WARNING:

Smart formula copy

E-droid-cell offer an easy way to replicate formulas. If you want to replicate a specific formula to a range of cells then use the Smart formula copy. Here are the steps:

  1. Select the cell containing the source formula
  2. Press the copy tool then select Smart formula copy
  3. Select the range of cells you want to apply the formula across
  4. Press the paste tool then select Smart formula paste

Hint:

[Edit] mode toolbar features

The next table shows available features when you are in [Edit] mode

Allow to select a range of cells. Once clicked you have to select the other corner of the rectangular region of cells. Selected cells will appear in yellow to show your cells range selection.
Save the current workbook
This button reload the worksheet from it's last saved state. Before doing a lot of changes we recommand to save your document regularly. That way a bad change may be "undo" by quickly reverting to last saved state.
This is the copy tool. There are 4 types of copy:
  1. Simple values copy
  2. Smart formula copy
  3. Smart row(s) copy
  4. Smart column(s) copy
  5. Smart style copy

1) You can simply copy selected cells values into clipboard. For data to be available for other Android applications this is the choice to pick. If some of selected cells contain formula only the formated result will be copied and not the furmula itself.

2) You can copy a formula into clipboard. The source formula will then be applyed (and adapted) to all the target cells when pasting.

3) You can copy the entire row(s) into clipboard. The involved formulas will be adjusted and cell style will also be replicated when pasting.

4) You can copy the entire column(s) into clipboard. The involved formulas will be adjusted and cell style will also be replicated when pasting.

5) You can copy a cell's style into clipboard. The source style (font, color, bold, italic, decimals, date format, etc.) will then be applyed to all the target cells when pasting.

This is the "Paste data" tool. There are 4 ways to paste data:
  1. Paste simple values
  2. Smart formula paste
  3. Smart row(s) paste
  4. Smart column(s) paste
  5. Smart style paste

1) You can simply paste clipboard content into current worksheet. Data will be placed into corresponding cells depending on the clipboard content. Clipboard data provided by other applications must follow some basic rules: row ends with a carriage return and cells on a row are separated by tabs.

2) Choose this option if you previously copied a cell's formula using "Smart formula copy" option. The original formula will be applyed to all the target cells when pasting and row/col formula references will be adjusted.

3) Choose this option if you previously copied rows using "Smart row(s) copy" option. The involved formulas will be adjusted and cell style will also be replicated when pasting.

4) Choose this option if you previously copied columns using "Smart column(s) copy" option. The involved formulas will be adjusted and cell style will also be replicated when pasting.

5) Choose this option if you previously copied a cell's style using "Smart style copy" option. The original style will be applyed to all the target cells when pasting.

The caller tool sends phone number from the selected cell directly to the device Dialer application. There is no validation regarding the cell content but you will have to confirm the dial process from the Dialer app itself.
The web tool sends internet address (hyperlink) from the selected cell directly to the web browser application. There is no sophisticated validation regarding the cell content: if data represents a valid internet hyperlink or a valid web site address then this tool will open link as is into web browser. If the cell content is not a valid web address then the tool will launch an internet search with data as keywords.
The Macro tool allow you to launch Javascript Macros. This mechanism allows to script the application. Although the Macro language is not compatible with VBA (Visual Basic Applications) it does allows for doing almost anything required by a Macro language. More help available from the Macro screen (once you hit the button).
The Barcode Scanner Tool allows scan for classic or modern barcodes. If you select this tool while the Barcode scanner isnt't installed yet on your device then you will be prompted for doing so. Barcode Scanner by ZXing Team can scan a variety of barcodes on books, products, and shipping labels. We recommand to put your device in landscape mode before launching the barcode scanner tool. The result of the barcode scan will be inserted into current selected cell (or in clipboard if you switched from portrait to landscape after pressing the Barcode scanner tool).
This tool allows you to extract charts from your data. You can create Pie charts, Line charts and Bar charts. All charts requires you to know exactly where are located values and labels. One a chart is created you can share it through e-mail, Dropbox, Picasa, Twitter, Facebook, etc. More help available from the Charts screen (once you hit the button and choose a type of chart).
The data eraser allows to cleanup any cell values entered into current selected cell(s). The application will ask confirmation before proceeding.
This is the Excel Functions selector. Note: this button is only visible if you are entering a formula (please refer to [Edit] mode data types section above in order to edit a formula). Workbook functions are grouped into well known categories and there are a lot of examples.
You can set the "word wrap" attribute for selected cell(s). This button is a "toggle" action: if the selected cell is already in "word wrap" style and you hit button again, then the cell will come back to normal (no word wrap).
You can merged or unmerge selected cell(s). This button is a "toggle" action: if the selected cell is already part of a merged region and you hit button again, then the cells will come back to normal (unmerged).
Display format for date and time values. You may format a date into a specific format. However be sure the given cell data type is "Date/time" and not "Numeric" or "Text" data (see Data types section above)
Display format for numeric and amount values. Before proceeding insure the given cell data type is "Numeric" data (see Data types section above)
Use this special inserter tool if you need quick insert of common values like current date, time, filename, sheet name, etc. The choosen value will override current selected cell value.


You can set the bold and italic attributes for selected cell(s). These buttons are "toggle" actions: if the selected cell is already in bold and you set bold again, then the cell will come back to normal (unbolded).
You can set the foreground color for selected cell(s). The color choices come from standard Excel colors palette.
You have full control over the font, color, bold/italic attributes into one button. This button can also be used if you select a range of cells and want to overide all these attributes in one operation.




You have full control over the cell bacground color, left/right/top/bottom borders... These buttons can also be used if you select a range of cells and want to overide selected cells style in one single operation. Each border can have it's own color/style.


You can change the column(s) width or the row(s) height. The width unit of mesure is in number of characters, based on regular size character set (like 12 points). The height unit of mesure is the "twips" (1/20th of a point).



Cell content can be aligned left / center / right. These buttons are the same as classic text editor applications.



These buttons enable rows adding. You can either add rows at the very end of the worksheet or insert rows between existing rows. When adding rows an input dialog will ask for number of items to add and the application will proceed after confirmation.



These buttons enable columns adding. You can either add columns at the very end of the worksheet or insert columns between existing columns. When adding columns an input dialog will ask for number of items to add and the application will proceed after confirmation.
See also: