Simple How-To

How to show the option menu.

Touch the menu icon at the top-right corner of the screen.

How to show the context menu.

Long-touch a cell/header.

How to execute a command (e.g.: Clear) for a single cell.

Long-touch the objective cell, and select the objective command (e.g.: Clear) in the menu.

How to execute a command (e.g.: Clear) for a single row/column.

Long-touch the header of the objective row/column, and select the objective command (e.g.: Clear) in the menu.

Or

Long-touch a cell in the objective row/column, and select the objective command (e.g.: Row>Clear or Column>Clear) in the menu.

How to execute a command (e.g.: Clear) for a range including multiple cells.

Execute the command after specifying the Cell range.

1. Long-touch a corner cell of the range, and select "Specify Range" in the menu.
2. Long-touch another corner cell of the range, and select the objective command (e.g.: Clear).

1. Touch a corner cell of the range to set the cell as the current cell (red frame).
2. Drag the current cell to the another corner cell of the range. The current cell is moved.
3. Long-touch the current cell, and select the objective command (e.g.: Clear).

How to execute a command (e.g.: Clear) for a range including multiple rows/columns.

1. Long-touch the first row header of the range, and select "Specify Range" in the menu.
2. Long-touch the last row header of the range, and select the objective command (e.g.: Clear).

1. Touch the first row of the range to set the row as the current row (red frame).
2. Drag the current row header to the last row of the range. The current row is moved.
3. Long-touch the current row header, and select the objective command (e.g.: Clear).

1. Specify the cell range, and select the objective command (e.g.: Row>Clear).

How to copy the content of a cell to other cell position.

1. Long-touch the source cell and select "Copy".
2. Long-touch the destination cell and select "Paste".

How to copy the content of a range to other cell position.

1. Long-touch a corner of the range and select "Range selection" (or drag the current cell).
2. Long-touch another corner of the range and select "Copy".
3. Long-touch the destination cell and select "Paste".

How to copy the content of a range to other range.

1. Long-touch a corner of the source range and select "Range selection" (or drag the current cell).
2. Long-touch another corner of the source range and select "Copy".
3. Long-touch a corner of the destination range and select "Range selection" (or drag the current cell).
4. Long-touch another corner of the destination range and select "Paste".

How to copy text only without the cell style.

Before executing 'paste', cancel the alt range (range with dotted line). When the alt range does not exist, plain text is aquired from the clipboard.

How to add/delete/hide/unhide column or row.

Refer above descriptions "How to execute a command (e.g.: Clear) for a single row/column." and "How to execute a command (e.g.: Clear) for a range including multiple rows/columns.". The command to execute is not "Clear" but "Insert/Delete/Hide/Unhide".

How to replace the keypad.

Touch the keypad icon on the top of the screen.

How to edit the keypad layout.

1. Long-touch a button on the keypad. Then the screen is switched to the layout edit mode.
2. Modify the keypad definition sheet. Each key action is described in "ButtonCommand" row. For example, when the command is "ABC<DOWN>", the key touch puts string "ABC" to the current cell and moves the current cell to the lower cell.
3. Click the icon X on the top-right corner of the screen. Then the layout edit mode is ended.

Refer to "Option menu » Help » Editing Keypad Layout" and QESS Support Page for details.

How to use system keyboard.

Touch the entry bar shown above the sheet view. Or, enable the setting 'Use System Keyboard Always'.

How to enter CR(carriage return) and TAB code.

Enter "\n" for CR and "\t" for TAB. Or use full-screen edit mode.

How to switch to the full-screen edit mode.

Double-tap the cell, or long-touch the entry bar shown above the sheet view.

How to change the cell size.

Long-touch the cell and select 'Change Cell Size'. Or double-tap the row/column/sheet header.

How to use Excel formula such as sum.

Enter the formula string leading with equal(=), such as "=sum(a1:a5)". Or select "Input Formula" in the cell menu.

How to treat data files more easily.

When the file manager in QESS is insufficient, use other file manager applications (E.g., 'Files by Google'. In some Android OS versions, files cannot be accessed). Or, connect with PC by using the USB cable and access files from PC (The USB connection should be set as File Transfer Mode). The path to the data area is shown above the file list.

How to exchange data with other applications.

For cell text, use "Share" or "Copy and Paste" in the context menu. For a data file, use "File Manager>File Export / File Inport" in the context menu.

How to exchange data with nearby devices.

For sending cell text, use "Share>Nearby Share" in the context menu. For sending a data file, use "File Manager>Basic Operations>Share>Nearby Share" in the option Menu. On the other hand, data received from nearby-share can take into this application via file-import or copy-paste.

How to exchange data with other devices.

There are many methods such as the USB cable, Bluetooth, e-mail attachment, etc. Some methods need to perform "File Manager>File Export" to enable access. In addition, the USB cable needs the file-transfer connection mode.

Another method is the use of the Google Drive.

1. When you want to send a file to a device, export the file to the Google Drive by using "File Manager>File Export" of this application.
2. When you want to receive a file from a device, import the file from the Google Drive by using "File Manager>File Import" of this application.

If text garbage is shown, please change the 'CharSet' in the setting menu.

How to change cell style such as cell color.

Basic colors for fill and font are supported. Select the objective command in the menu.

How to use special input method such as OCR.

Input by the other application and get text via Share or Copy/Paste.

How to search/replace a string in the current sheet.

Select "Option Menu » Settings » Search/Replace Text". Then the bar for search/replace is shown. To set the regular expression search and case insensitive search, touch the 3-dots icon at the right-bottom corner of the bar.

How to execute more complex data processing.

Use 'SQL Query'. It is found in the menu of the cell/row/column/sheet.

How to use 'Draw Graph' or 'SQL Query'.

Refer to the HELP, which exists in the top-right corner icon of each screen.

How to make my original layout.

Firstly, create a new layout file by copying similar layout file: "Option Menu » File Manager » Basic Operations".

Nextly, open the new layout file and check the mark of "Option Menu » Settings » Layout Edit Mode" to edit it.

Refer "Option Menu » Help" for details.

How to set media (image, video, audio) into a cell.

Following methods can be employed.

• Capturing media directly by using the camera or the mic.
  • From the cell menu, select 'Capture Photo', 'Capture Video', or 'Capture Audio'.
  • Execute the command '<CAPT PHOTO>', '<CAPT VIDEO>', or '<CAPT AUDIO>' from a keypad.
• Capturing an existing media file.
  • From the cell menu, select 'Capture Media File'.
  • Execute the command '<CAPT FILE>'from a keypad.
• Using 'Share' in other application.
  • Load some application having the media share fuction, and share out the media to this app.

How to open the media in a cell.

Double-tap the cell.

How to open the URL in a cell.

Use the command <WEB>. The layout file "sampleMultimodal" includes the command button. Or set the option 'Enable Auto Link' in the settings and double-tap the cell.

How to make a keypad switching button.

When you want to switch from the keypad1.xlsx to the keypad2.xlsx, set a button for the command <OPEN LAYOUT keypad2.xlsx> in the layout file keypad1.xlsx.

How to hide the keypad layout.

Select the layout 'nullKeypad.xlsx'.

How to open a data file in some folder.

Copy it to the data file area by using 'File Manager>File Import'.

How to create a sub folder in application data storage.

It can be created from the folder-icon on the action bar of 'File Manager>Basic Operations'

How to display the formatted value for a formula cell.

Select a format from "Change Data Type/Format" in the menu. Or use TEXT() function. E.g., [=TEXT(TODAY(), "yyyy/mm/dd")] or [=TEXT(A1,"#,##0.0")].