New features in this version:
- GS-Calc can now both load and save multiple text files in one zip file. The corresponding “Files of Type” filter name in the “(File) Open” dialog box is:
- “Text | Text Archive (.txt;.csv;.tsv;.tab;*.zip)”
To save such a zip for the first time using “Save As”, you just need to select this filter and enter both the file name and the “.zip” extension.
The advantages of this functionality include:
- All worksheets can be saved at once as text files in one zip; there is no need for all the merging and copying of text files.
- You don’t have to repeatedly enter or switch between various text file options (separators, encoding, parsing data etc.);
when opening such a zipped set of text files, the “Text File Options” dialog box is displayed only once for all files (although you can choose to display it for any of the files individually). - Once the zip file is saved, with one or any number of text files, GS-Calc saves in it a short *.xml file with parameters so you can keep on editing/processing/saving/loading such text files without the “Text File Options” dialog boxes and without bothering with re-selecting proper text options.
- All nested subfolders of the worksheet tree are retained and recreated when you save a *.gsc file to such a zip archive.
- You can make using such archives even more automatic generating such zip with multiple *.xml options (for some or all text files).
- You don’t have to repeatedly enter or switch between various text file options (separators, encoding, parsing data etc.);
Help page showing a sample *.xml file:
- https://citadel5.com/help/gscalc/text_archives.htm
- If a given text file is to be opened entirely as text (with no numbers and formulas parsing), all worksheet columns created from that file are automatically formatted using the “Text” style.
Thus, you no longer have to carefully enter the leading ’ when editing cells to keep them all as text.
To delete the “Text” file from a given column, click its header and either press Del then “Formatting” or choose the “Default style” on the formatting toolbar.
- The “Auto-fit column widths” option (to automatically resized column widths in the opened text file) is now available directly in the “Open Text File” dialog box (in addition to its previous location in the “Settings” dialog box.
- In the “Open Text File” dialog the “Use escaping” option is now turned off by default as it requires careful use and leaving an incorrect escaping symbol can lead to missing characters in the loaded data.
Text Files Help page:
- https://citadel5.com/help/gscalc/text_files.htm
- The formula parsing option in loaded text files is by default set to “don’t parse” and should be changed only for text files which are expected to contain formulas.