Description: When I try to change cell format from text to Date it only adds ' symbol in value field but doesn't change the cell format. When I remove that ' symbol from the value field(or formula field - i'm not sure how you called the field where formulas are written) the cell becomes the correct Date format. Steps to Reproduce: 1.Enter this to a cell: 12/01/1017 2.Format cell to Date YYYY-MM-DD 3. Actual Results: ' was added to the text in the value/formula field above Expected Results: cell format should have changed Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36
Created attachment 135041 [details] this is where the ' symbol is added
@Mantas : 1) you are using an obsolete version of LibreOffice - 5.2.x is end of life. Please try with a current release version and report back. 2) I can not reproduce the behaviour with Version: 5.2.5.1 Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22 Threads CPU : 4; Version de l'OS :Mac OS X 10.12.6; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group if I type in the string as you indicate in step 1, it is automatically formatted as a date. This leads me to the question of your locale - which language, and which language packs, if any, are you using ? Please provide both your OSX system language, and any lang packs that you have installed on top of LibreOffice. Setting to NEEDINFO pending further information from original reporter, please set back to UNCONFIRMED once you have provided this information.
Hi Alex, thanks for your reply. My file is a .csv export from Paypal which I opened with LibreOffice and saved as .ods These dates are Paypal default in csv. I've updated LibreOffice as instructed and I still experience this problem, please see screencast of the problem: https://screencast.com/t/TDigA1qPO When I format it it adds this ' symbol and when I delete the symbol everything's fine. I'm not using any additional locales on top of Libreoffice, my primary language on OSX 10.12.5 is English and secondary is Lithuanian
@Mantas : thanks for reporting back. The CSV file contains dates as text strings. These are marked as such when you import the CSV file into LibreOffice by an apostrophe - this is a "feature" of Excel that LibreOffice has also integrated. Have you tried playing with the import options when you load the file into LibreOffice ? Please also indicate how the date is represented in the CSV format, e.g. by opening it in TextEdit. How are the date strings represented ?
Check in particular to see whether when you drag and drop the CSV file onto a running instance of LibreOffice, that your import options dialog "Field between quotes as text" unticked. I tried this with a sample Paypal account activity export and I'm afraid I don't encounter the problem you are seeing - the date strings are imported correctly without an additional apostrophe, and show up as dates in the Format dialog. As for your link, thanks, but clicking on it informs me that it requires Flash, which I avoid installing for various security reasons. At least as far as I'm concerned, this is WORKSFORME, but it may be dependent on your locale settings and the export format offered to you by Paypal (hence playing around with the import options when opening the CSV in LibreOffice is a good thing to try).
Dear Bug Submitter, 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-20180302
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20180404