QESS

QESS is a spread sheet application for Android smart phone focusing on effective entry. It has editable keypads.

Q and A

What is the functional difference between Std version and Pro version.

No functional difference exists between two versions. Showing the advertise or not is different.

Can you help me for making some original keypad.

Yes. Refer Support.

I want to use the Excel style such as ruled lines and background color, have you plans to add these functions.

The fill color and font color of the cell can be set. And you can change data type, forma, text alignment, font properties and ruled line. For other styles, we have no plans at now.

The CSV file introduced from the PC has garbled characters. How to treat it.

Select 'Auto Detection' for the setting of 'character set at reading text'. If failed, try other character set in the list.

How to change the data folder position.

Data folder cannot be changed to the arbitrary folder except the sub folder of default. But QESS can imports files from any folder and exports files to any folder. The sub folder can be created from the icon situated at the top-right corner of the file manager screen.

How to move data from Std version to the Pro version.

Backup data in Std version, and restore them in Pro version. The functions of "backup" and "restore" are found in the file manager menu.

I cannot find files of QESS on a file browsing application.

Move files to the storage position accessible from outside.

In default, The dedicated area is used.

How to exchange data from/to a PC.

Various methods exist, such as USB cable, Bluetooth, or Wifi.

There are methods such as USB connection, Bluetooth connection and via network. Select the shared area in the setting of the data storage, and select the folder/file in the exchange method.

Why QESS files are not shown at connecting my device with a PC.

Many factors are related. In USB connection, the connection type should be switched to "File Transfer".

Does QESS support Excel Macro.

No. Macro does not be supported. But a command sequence (simple macro) can be assigned to each key in the keypad. It is a sequence of commands such as data input, cell movement, caluculation and others. Simple loop and branch can be described in command sequence. And JavaScript can be called.

Does QESS support all of Excel functions

No. No. The supported functions are listed in the formula input screen of the cell menu.

After editing a layout file, the layout does not work.

Initialize sample layout files by using 'menu→File Management→Initialize Sample Files'. Then modify files little by little. Do not edit first columns, because first columns are the keys for setting items (except the list name used in <LIST> command).

After editing a layout file by using Excel, the layout is broken. Why?

In some application, the file having extension '.csv' is not saved as CSV format but as TSV format. Change the file extension to '.tsv' and open the file.

I have denied the permission for storage/camera/location. Does it cause problems? Teach a method to clear denying.

The corresponding function dose not work. When denying (external) storage, the dedicated area is used. When denying camera, QRcode/barcode reading is disabled. When denying location, location detection is disabled. To switch from denying to permitting, use 'menu→Apps→QESS→Permissions'. This permission control is available from Android 6.

Does 'Undo' function exist?

No, QESS does not have 'Undo' function. But it has the function to return to the previously saved state. The function can be selected from 'Return To Previous Save' in the menu. The count and interval of the save can be set in the menu. The save is not executed periodically but executed at hiding the main screen (such as rotate the screen or switch to other screen).

When changing language setting of OS, the string is displayed by the previous language. How to recover.

Use 'Menu → File Management→Initialize Sample Files' for reloading sample files. And try 'Menu → Settings→ Reset Settings'.

Is the text acquired with OCR (Optical Character Recognition/Reader) ?

QESS does not have the OCR function. Please acquire the text with favorite OCR application and transfer it to QESS via the 'Share' function or the 'Clipboard'.

If you use the 'Share' function, open 'Share' menu in the OCR application, and select QESS in the displayed list. Then QESS is lauched and the text is inserted.

If you use the 'Clipboard', copy the OCR result from OCR application to the clipboard. Next, launch QESS, and choose 'Menu → Modify Cell→ Paste'.

The text is divided and entered to the cells according to the format in 'Menu →Settings →Clipboard Text Form'. If you want to enter all text into one cell, execute 'Paste' in the 'Full Screen Edit', when using the clipboard. When using 'Share' function, check the flag 'Menu→Settings→Treat Shared Text Data Without Processing'.

The conversion between data types does not work. Or the data type is automatically converted without user action.

Some direct conversions are not supported. Please convert via other data types such as numeric.

When using text files(=CSV, TSV, TXT), the data types are converted into the string type. Please use the Excel files( =XLS, XLSX).

Loading of data file is very slow. Or loading is failed.

Use version 3 or later. If it is slow yet, divide data file, or use the other applications. QESS has the function to split/trim the data file.

How can I find total sum of numbers in cells.

Use the Excel formula. Enter text in the result cell by using the keyboard. For example,
=SUM(A1:B2)
=SUM(B:B)
=SUM(3:3)
To set it as a key command, enter the following to [ButtonCommand] row in the layout file. Two Apostrophes (Single Quotation marks) are needed in the head of the command to enter as a string.
''=SUM(A1:B2)
''=SUM(B:B)
''=SUM(3:3)
Or, enter the following in the row of [ButtonCommand].
SUM(A1:B2)<TYPE FRML>
SUM(B:B)<TYPE FRML>
SUM(3:3)<TYPE FRML>

To get sum of the current range, refer sample and help. The function 'sum' can also be selected from the list in the formula input screen.

How can I set an Excel formula as a key command.

See the above answer.

The application size is very big. Why?

The big size is caused by many support liblaries such as Apache POI for treating Excel files.

The speak is not fluently.

The speak is implemented with TTS (Text To Speech). Check the Android Android system settings. The use of other speech engines might improve the quality.

I cannot decode the QR code generated with this application.

Please reduce the cell range to encode. If it is still failed, try other QR code scanners. Some scanner accepts only URL format.

I copy the text to the clipboard in other applications, and paste cells in this application. Sometimes, the paste text is different from the copy text.

Please cancel the Range with the Back key. When a Range is active, the paste text is taken not from the clipboard but from the Range.

At copying formula cell, I want to get the calculated value instead of the formula itself.

Please execute the paste action after pressing the Back key to reset the range mark.

When I changed the value of a cell, the value of a formula cell referring to the cell is not updated. Is it a bug?

In order to avoid getting heavy, QESS makes lazy evaluation of cells. The value is updated, when the position of the current cell is changed.

When I changed the cell size, it is returned to the previous size at updating the screen. Is it a bug?

The cell size cannot be not saved to the CSV/TSV/TXT file. Use the XLS or XLSX file.

I desire functions for "Merge cells" and "Table border".

The function of "Table border" was added at Ver.3.1.0. I have no plans about "Merge cells".

I desire function for "Print" or "Convert to PDF".

The function is added. It is found in the menu of cell/column/row/sheet. Or, please try web-services for printing and PDF conversion.

Duplicated functions exist such as <MENU ClearSheet> and <CLR SHEET>. What is the selection criteria?

These are same function. As the function via MENU has more delay, use the direct function, if possible.

When I use the [=today()] function, I only get a five digit number and not the present date. Why?

[=today()] returns the raw value. Use "Type and Format" in the menu for changing the format to Date. Or use [=text(today(),"yyyy/mm/dd")], where the second argument is a format string.

I desire documentations and templates about customizing layout.

Documentations can be found in the "Help Document" and "QESS Support Page". The latter is linked to "Menu>Help Document>Help>Support". The templates are prepared as sample layout files.

I want to make a button disappeared when touching it.

You can implement it by switching the layout including the button and not including the button. Refer "Menu>Simple How-To>How to make a keypad switching button".