Description: When an open .ods file is saved as .csv, the Save As does not finish, but instead disappears and you return to the original .ods window. LibreOffice does not crash, the Save As just does not occur. In other words, you can't save an .ods file as an .csv file. Steps to Reproduce: 1. Create a new simple spreadsheet in Calc in .ods format, no formulas, just text, put something in each cell A1-C3. 2. Save and close the spreadsheet. 3. Open the saved spreadsheet, select File, Save As, select File type: Text CSV (.csv), select "Edit filter settings", select Save. 4. Save As window disappears. Window for setting filter does not appear. No file is saved. Original .ods window remains open. Actual Results: Save As window disappears. Window for setting filter does not appear. No file is saved. Original .ods window remains open. Expected Results: Window for setting filter should open, so you can select encoding, etc. Then the file should be saved. The original window should change from filename.ods to filename.csv. Reproducible: Always User Profile Reset: Yes Additional Info: LibreOffice Calc versions 6.2.8.2 and earlier do not have this problem. I know the problem is present in 6.3.4.2 through 6.3.6.2; I don't know if it was in earlier 6.3.x versions. OpenGL and OpenCL are both disabled (must be default settings--I did not change them after installing LibreOffice). Help - About LibreOffice Version: 6.3.6.2 Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497 CPU threads: 4; OS: Mac OS X 10.15.4; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
You encourage me with your excellent work on LibreOffice--thank you! I've used LO since it was OO.org.
I can not confirm on the new 7.0 Alpha Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 4; OS: Mac OS X 10.15.4; UI render: default; VCL: osx; Locale: en-US (en_NO.UTF-8); UI: en-US Calc: threaded
I've refined my problem description. The error does not occur when I Save As .csv and give it a new file name. The error always occurs when I Save As .csv and I am overwriting an existing file. I've confirmed that the same problem occurs when I Save As File type Office Open XML Spreadsheet (.xlsx) and overwrite an existing file. I've confirmed the problem on these LO versions: 6.3.6.2, 6.4.3.2, pre-release 6.4.4.2 and pre-release 7.0.0.0 Alpha 1: Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 4; OS: Mac OS X 10.15.4; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Thank you. Peter
I can not reproduce the bug in version 6.4.4.2 or the new version 7.1.0.0.alpha0 versions: LibreOffice 6.4.4.2 and LibreOfficeDev 7.1.0.0.alpha0
Thank you to eisa01 and Abhi for trying to confirm my results. I tried again with 6.4.4.2 and 7.0.0.0.beta1, and confirmed my previous results; an .ods file, File, Save As .csv will not overwrite an existing file. Be sure to use my revised problem description and steps listed in Comment 3. I am now using macOS 10.15.5. I deleted the LibreOffice profile and reset LO to factory settings before each test. I did not make any customizations, nor did I change any of the default responses except as noted. Version: 6.4.4.2 Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Version: 7.0.0.0.beta1 Build ID: 94f789cbb33335b4a511c319542c7bdc31ff3b3c CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Thank you, Peter
No problem here Arch Linux 64-bit Version: 7.1.0.0.alpha0+ Build ID: 52d70047c694d4e0c8bbf843c895d86492735f3f CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: kf5 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 25 June 2020
Does the error still happen in Safe mode? Help - Restart in safe mode and then Continue in safe mode.
Argh, ignore me, you said you reset your profile
Created attachment 162625 [details] screenshot of edit filter I use this libreoffice version: Version: 7.0.0.1.0+ Build ID: 30ea3ba86b110db68c19815c5c67d4d315c091bf CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx Locale: en-ID (en_ID.UTF-8); UI: en-US Calc: threaded at my Catalina, and this issue not affected at all The feature of edit filter and save as .csv is work normally
Wrong status and no justification to change as the "fix" did not appear in the system of the original reporter.
Thank you Buovjaga and Imanuel Ronaldo for trying to reproduce my problem. I tried with the newest versions available on the website, 6.4.5.2 and 7.0.0.0.beta2, and confirmed my previous results; an .ods file, File, Save As .csv will not overwrite an existing file. Likewise, it will not overwrite an existing .xlsx file. An Export will overwrite an existing .pdf file. Before each test, I reset my profile. I did notice a potential contributing factor to the problem. LibreOffice doesn't consistently show up in the System Preferences, Security & Privacy, Privacy, Files and Folders access list. I was unable to add LibreOffice to the list (the plus and minus signs were greyed out, and I tried reseting the list using tccutil in Terminal, but that didn't solve the problem). Sometimes LO appeared in the list, and sometimes it didn't. Version: 6.4.5.2 Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6 CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Version: 7.0.0.0.beta2 Build ID: 1c213561a365b5666167321de68c9977500c9612 CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
:Peter This sounds like a permissions problem on your Mac with the location where your files are stored, and LibreOffice not being able to write to that location. In many respects, it sounds a lot like the behaviour reported in bug 128233. Quit LO if running, and try executing the following command from a terminal: codesign -vvv --deep --strict LibreOffice.app (or whatever you have called the LibreOffice.app bundle) Then try the load/change/save operation again and report back here.
Possible DUP of bug 128233
(In reply to Alex Thurgood from comment #12) > > codesign -vvv --deep --strict LibreOffice.app In a zsh shell, this needs the full path to the app bundle: e.g. codesign -vvv --deep --strict /Applications/LibreOffice.app
Created attachment 165574 [details] Output from "codesign" command requested in Comment 14
Greetings, Alex! You encourage me with your diligence--thank you! I'm running LO: Version: 6.4.6.2 Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 4; OS: Mac OS X 10.15.6; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded I verified the problem still exists. I ran the command you asked for in Comment 14, and attached the Terminal output. For completeness, I tested for the problem again, and it still exists. Thank you, Peter
Greetings! I've upgraded to macOS 11.1 Big Sur and LO 6.4.7.2, and the problem has disappeared. Version: 6.4.7.2 Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Mac OS X 10.16; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Thank you. Peter