Description: then opening file as csv , calc doesnt preserve document delimiter. so then saving the document it overrides delimiter set default in calc. unless one saves with "Save As" and tickes filter checkbox, he will get delimiter selection option. Steps to Reproduce: 1.open calc and fill some data in the cells 2.press "Save As" to save the document as "Text CSV", make sure you ticked "edit filter settings" 3. in opened dialog select "Field delimiter" from "," to ";" and press ok. 4. open saved document with notepad or any text editor. now the file has been saved as text and fields separeted with ";" delimiter. close the document. 5. click "Save" in Calc. open the saved document again with text editor, now you notice that delimiter changed to "," Actual Results: ,,,,,,,,, Expected Results: ;;;;;;;; Reproducible: Always User Profile Reset: No Additional Info:
I cannot confirm this, the choosen field delimiter is saved in user configuration for me: <item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVExport"> <prop oor:name="FieldSeparator" oor:op="fuse"> <value>;</value> </prop> </item> Which LO Version did you use? Please copy information from Menu Help/About LibreOffice but what i noticed: If one opens a saved *.csv file and enables several delimiters in Text Import dialog, e.g.: (*) Separated by: [x]Tab [ ]Comma [x]Semicolon LO seems to use the first delimiter on save. In my case the delimiter changed from a semicolon to tab. maybe also related to: Bug 121880 - Set semicolon ; as default Field Delimiter for CSV instead of comma , (avoid confusion for French and other)
Dear arshamatonyan, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Oliver explained all. But we may consider a duplicate. *** This bug has been marked as a duplicate of bug 121880 ***
*** This bug has been marked as a duplicate of bug 152336 ***