25
Sep
11

QuickOffice Pro 7: QuickSheet

QO_PRO_512x512-96x96 This Review forms part of a multi-part review:

QuickSheet is a sub-app of QuickOffice Pro 7 enabling creation, editing and viewing of Microsoft Excel spreadsheets. One thing to note is that although Microsoft Excel supports many different document file formats QuickSheet is limited to .xls (Word document), .xlsx (Word 2007 document) and .txt (Test file) file formats according to the user guide, although the save as menu also offers .xlsm (Word 2007 Macro).

Once you have selected “Create Document” on the main QuickOffice screen and “Spreadsheet” from the Create menu you are presented with a blank white spreadsheet window with a cell entry field and soft button bar below containing the “Options” and “Close” buttons. Unlike QuickWord a double tap on a cell in the main window will open the cell entry interface with the default keyboard.

A nice touch across the latest QuickOffice offering is pinch to zoom support, which is why you will not see a zoom option in the options menus, although sometimes numeric zoom option can sometimes be useful.

Scr000216    Scr000001    Scr000007    Scr000011

Pressing the “Options” button within the bottom bar provides access to:

  • Save: “Save as” for new documents with “Save” available for document updates.
  • Edit cell: Redundant as duplicate of tapping on the cell entry field.
  • Edit: Provides the ability to “Cut”, “Copy”, “Paste”, “Clear contents”, “Clear formatting” and “Clear all”.
  • Format
    • Font Style: Select from “Bold”, “Italics”, “Underline” and “Strikethrough”.
    • Font: Select from font type, size.
    • Color: Select from Cell color and Text Color. This seems in some ways disconnected as in QuickWord “Color” sits within “Font”.
    • Alignment: Select from “Horizontal” and “Vertical” alignment as well as an on/off “Wrap text” toggle. 
    • Number format
      • General: No sub-menu
      • Number: Select from no. of decimal places, 1000 separator symbol and how negative numbers are displayed.
      • Currency: Select from no. of decimal places, currency symbol and how negative numbers are displayed.
      • Accounting: Select from no. of decimal places and currency symbol.
      • Date: Select date format (default is dd/mm/yyyy).
      • Time: Select time format (default is h:mm:ss AM/PM).
      • Percentage: Select no. of decimal places.
      • Scientific: Select no. of decimal places.
      • Text: No number formatting.
    • Column autofit: Fit the column to the data in the cell. This should be removed from this sub-menu as it is a duplicate of it’s more logical location under the column option.
  • View: Opens a small sub-meu with view “Cell” or “Go to” which opens a new screen for row and column address entry.
  • Find & Replace: Opens a new screen enabling the user to enter the text to be found, the replacement text and where to look (row, column, sheet, workbook) and if cell values or formulae should be searched.
  • Row
    • Edit: selects all cells in row and provides a new options menu limited to Edit, Format (contains everything from the standard Format menu, excluding “Column autofit”), Insert and Delete. This should activate from the “Row” option, with Resize added to it’s menu, rather than being one level below.
    • Insert: Redundant as duplicate of option in the row “Edit” menu.
    • Delete: Redundant as duplicate of option in the row “Edit” menu.
    • Resize: Generates a nice user dragable bottom border for the row for height resizing.
  • Column
    • Edit: selects all cells in row and provides a new options menu limited to Edit, Format (contains everything from the standard Format menu, including “Column autofit”), Insert and Delete. This should activate from the “Coumn” option, with Resize added to it’s menu, rather than being one level below.
    • Insert: Redundant as duplicate of option in the column “Edit” menu.
    • Delete: Redundant as duplicate of option in the column “Edit” menu.
    • Resize: Generates a nice user dragable right hand border for the row for height resizing.
    • Column autofit: Fit the column to the data in the cell.
  • Worksheet: Select from “Select”, “Rename”, “insert”, “Delete” and “Recalculate” worksheet.
  • Preferences: Select from “Auto-move” on completion of cell entry (default is down) and Auto/Manul Calculation toggle (default is Auto).
  • Updates & Upgrades: This option is somewhat redundant as it appears to be a duplicate of the Store button from the Main QuickOffice screen, working as a link to the Free Downloads page of the QuickOffice App Store.
  • Help
    • Help: Opens the internal help app, which unluckily is pretty much non-existent when it comes to QuickOffice help.
    • Register: Opens the registration screen no matter if the app has already been registered. In my opinion this should be hidden once QuickOffice has been registered.
    • About QuickOffice: Displays information on the version QuickOffice which is installed.
  • Exit: Exits QuickSheet and QuickOffice.

Cell Entry

Tapping on the cell entry field or “Options” and “Edit cell” brings up the keyboard and begins text entry. When the keyboard entry is completed and the keyboard is closed a new cell entry menu is available via the “Options” button.

Scr000003    Scr000004    Scr000008    Scr000006

  • Accept changes: Saves the changes to the cell and exits cell entry. This can also be achieved by tapping the Close button.
  • Operators: Redundant as it enable selection of operators which are all available via the standard keyboard.
  • Editing options: Only appears when the cell is not empty and provides cut, copy and paste options.
  • Writing language: A list of languages that the app can be converted to. The interesting thing is that changing the language here does not change the menu language and I have been unable to find spell checking within QuickSheet.
  • Insert Function: Discussed within QuickOffice Pro 7: QuickSheet – Supported Excel Functions. The main issue in this area is that all funtions must be entered in Upper Case, but this is not explained anywhere. This is not a limitation of Microsoft Excel, so why is it being enforced in QuickSheet.
  • Help: Redundant as it is no different to the option in the standard QuickSheet Options menu, which does not provide any help.

Conclusion

This is a very capable spreadsheet app with nice integration with Microsoft Excel, although parts of this app seem incomplete with duplicates within the menu structures. All of the QuickOffice sub-apps are share the same GUI making them feel professionally developed, but the minor niggles I reference in this review and the Supported Excel Functions post would make this a true winner.

Advertisements

7 Responses to “QuickOffice Pro 7: QuickSheet”


  1. 1 Felicia Anderson
    December 30, 2011 at 11:14 pm

    Using Quickoffice Pro HD on Toshiba Thrive tablet. Need formula to calculate the years,months, and days between two dates. “if dated” formula used not converting into Quickoffice. Need help. Can you assist?

  2. 2 akash
    August 4, 2012 at 4:47 am

    Is FILTER option is supported by Qucikoffice PRO, plz tell me as soon as possible, i have to gift it to someone special


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


mbrett

Twitter Updates


%d bloggers like this: