Category: 未分類

• English
• 日本語

SUM

Find the sum of the specified cells

example

=SUM(A1:A3)

version 3.0.0 ~

=SUM(A1,A2,A3)

AVERAGE

Finds the average value of the specified cell

example

=AVERAGE(A1:A3)

MIN

Displays the minimum value of the specified cell

example

=MIN(A1:A3)

MAX

Displays the maximum value of the specified cell

example

=MAX(A1:A3)

ROUND

Round the specified cell to the nearest whole number

example　A1=3.1415926535897

=ROUND(A1,-1) // 3

=ROUND(A1,-2) // 3.14

example　A1=15980

=ROUND(A1,0) // 15980

=ROUND(A1,-1) // 15980

=ROUND(A1,-2) // 16000

=ROUND(A1,-3) // 16000

=ROUND(A1,-4) // 20000

• English
• 日本語

version 2.22.2 ~

ON

Display a link when a URL is entered in the cell

Tap the arrow to open the URL in a browser

OFF

Even if a URL is entered, it is displayed as text and not treated as a link

• English
• 日本語

Outputs the created table.

Select “Output” from the menu in the upper right corner of the table

Select the format you want to output.

*XLSX requires the purchase of “Pro” in-app purchase

• English
• 日本語

Long tap the file to display the menu

Select “Backup Management” from the menu

Backups are displayed in chronological order, so tap any backup

Backup restore

Tap the menu at the top right of the screen

Select restore

*When restored, the backup data will be overwritten on the original file.

Delete backup

Delete the created backup

• English
• 日本語

*This feature requires an in-app purchase.

Enabling Automatic Backups

Turn on “Automatic Backup” in the settings screen.

Specify the number of generations for automatic backup

You can specify the number of backup generations.

The default is 5, the minimum is 1, and the maximum is 19.

Please note that the more generations you have, the more backups you will need and therefore the more storage will be used.

Timing of automatic backups

• When the file is closed
• When the application is moved to the background

Creation will take place at the above two times

If there is insufficient storage on the device, backup creation may fail.

Please take sufficient care.

• English
• 日本語

*This feature requires an in-app purchase.

Tap the menu button in the upper right corner of the screen

Tap “Backup” on the menu

When the backup creation is completed, you will receive an alert as follows

• English
• 日本語

Select “Sheet Settings” from the menu button on the upper right

Tap either the row or column for which you want to change the settings

Please select any number

*Cannot be set if the settings conflict with the combined rows / columns.

• English
• 日本語

You can set the font size.

This will be reflected when you create a new file.

※Please note that this will not be reflected in existing files.

• English
• 日本語

Undo/redo is now available.

Undo

Redo

• English
• 日本語

Tap the upper left cell.

Select either height or width, and set the desired value