Description: LO 5.4.7.2 I open a XLS file and try to save it to CSV. In Italian the error is: Errore nel salvare il documento ... : Parametro errato. L'operazione è stata avviata con un parametro non valido. ("..." is the title of the windows, equal to the name of the file) In English I think the error message is: Error saving the document ... : invalid parameter. The operation was started with an invalid parameter. Steps to Reproduce: 1. open the XLS file 2. menù File : Save as : CSV Actual Results: error Expected Results: save the file in the new format Reproducible: Always User Profile Reset: Yes Additional Info: How can I attch the XLS file to reproduce this problem ? User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:45.0) Gecko/20100101 Firefox/45.0
Created attachment 142677 [details] the problematic file
Hi Massimo, Can you try to save your file as csv as following: File > Save as... Choose Type as Text CSV and tick Edit filter settings. Once Save selected, you will can choose the parameters. I chose (Tab)as Field delimiter and Quote all text cells and it seems to work. Is it the same for you?
Also with "edit settings" checked, same error as soon as I click on [Save]. I could have different settings for CSV export, it depends on the last file I converted to CSV. Calc must show the settings before any other operation / check, otherwise the user cannot change them and solve this error.
Created attachment 142681 [details] Saveas options : edit settings
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
Hi Massimo, Thank you for your answer. I have two steps after "Save": Ccnfirm File Format, then Export Text File allowing to change the parameters there where you find imediately the error message. Can you try to use "Restart in Safe Mode..." in Help menu to exclude a setting issue. To try a newer version could be also a good thing.
Unfortunately starting LO in "Safe Mode" doesn't help, same error. I tried both the first and last choice (see attached image "Restore options") * restore from "security" (?) copy ... * restore from factory defaults [*] restore user settings [*] restore the full user profile
Created attachment 142906 [details] Restore options
No problem here. Please try with 6.0.5. Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: fi-FI (fi_FI); Calc: group Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
We have 500 Windows XP clients. We have to use LO 5.4.
(In reply to massimo.sala@ats-bg.it from comment #10) > We have 500 Windows XP clients. We have to use LO 5.4. I hope you understand that 5.4 is end of life: https://wiki.documentfoundation.org/ReleasePlan/5.4#End_of_Life If you want support for it, you have to pay for it: https://www.documentfoundation.org/gethelp/developers/
(In reply to Buovjaga from comment #11) > (In reply to massimo.sala@ats-bg.it from comment #10) > > We have 500 Windows XP clients. We have to use LO 5.4. > > I hope you understand that 5.4 is end of life: > https://wiki.documentfoundation.org/ReleasePlan/5.4#End_of_Life To be fair, this is probably an issue with settings, and there's no actual bug with CSV export. Too bad the settings used for CSV export weren't attached.