Use the File > Save As command and choose the Excel (*.xlsx, *.xml) format from the File of type list.
Note (1): As of version 20.0 some xlsx file information is not yet converted. Specifically, using tables references defined in worksheets is not yet supported. Formulas like:
=Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]
are loaded and saved with their values, but not updated.
Note (2): Although the old xls files are still supported, GS-Calc uses them mainly as data tables with records. It loads/saves only column formatting and formula values.
In the Save GS-Base File dialog box specify the following options:
-
Save field names in the first row
If this option is selected, the first row of each saved sheet will contain the corresponding record field names that will be reused if you open the workbook back in GS-Base. -
Split tables exceeding the 1M/65K Excel *.xlsx/*.xls limit in files [...]
If this option is selected and if the number of records in one or more of the saved tables exceeds the 1M/65K Excel *.xlsx/*.xls limit, GS-Calc will split such tables and save multiple *.xls workbooks:
file_name.xlsx
file_name(1).xlsx
file_name(2).xlsx
...
file_name(n).xlsx
If there are any previously saved files with larger indices (e.g. file_name(n+1).xls and on), they will be deleted.
If you open the file_name.xls file again in GS-Calc or GS-Base, the remaning partial workbooks will be automatically (internally) loaded to form the original GS-Calc/GS-Base tables. - Enable restoring the GS-Calc folder structure [...] If this option is selected and if you created folders in the GS-Calc worksheet tree pane for some tables, the Excel sheet names will be formed as whole such table tree paths which will enable GS-Calc to re-created the original tree folder structure when you open the saved Excel *.xlsx/*.xls workbook back in GS-Calc (or GS-Base).
As the "\" path separator can not be used in Excel names, it's replaced with ">".
