Would it be possible to add “Save as default” button on the first prompt page when open a (csv) file? If the “default” file exists, the LibreOffice will read the “default” file first before open any (csv) files. The “default” file should save those info user selected (such as character set, etc.) on the prompt page. This way, LibreOffice does not need to show the prompt screen every time user opens a (csv) file, just using the info from the “default” file.
You might not have noticed, but the last used values are remembered and presented as default on opening the next CSV file. You just have to hit Enter or click OK.
My suggestion is do not even show the prompt page if the last used values existing (from the default file). You may ask, then, how about user wants to change any value(s). (This should not happen frequently.) My guess is user needs to delete the (default) file. Next time, LibreOffice opens the csv file, it could not find the (default) file so that it will show the prompt page.
Save an ordinary Open Document Spreadsheet and menu:Sheet>Insert sheet from file … with option “Link”
As an idea for discussion: we can create a file in the folder where the csv file is located, similar to Schema.ini, which for each csv file in this folder will contain the value of the FilterOptions property that was applied when the file was last opened.
In addition, in org.openOffice.Office.Histories:HistoryInfo[Picklist]/ItemList we can save FilterOptions, among other properties.
Anyway, it is tdf#74580
2 Likes