Create a new xlsx file from Excel (2010 in my case). Put an amount in a cell and format it with a standard monetary format (in my case # ##0,00 €, for exemple 123,45 €). Save it. Open it with Spreadsheet, the display is fine (exact format is # ##0,00 "€"). Save the file with a new name or modify it and save. Open it again with Spreadsheet, the display is divide by 1000 for example 0,12 €. The format saved was # ##0,00 \€. This is weird because both of this formats give 0,12 € in Excel and Spreadsheet, one working is # ##0,00\ €. This may depend of the regional settings, mines are French.
Mmh, strange. I think I can't reproduce it completely What I did using Mac OSX 10.9, LibreOffice Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f and Excel for Mac 2011: * Open Excel * In cell A1 I enter 123,45 * Right click > Format Cell * Choose 'currency' format with 2 decimals * OK; cell now shows 123,45€ * Save as .xlsx * Opened saved .xlsx using LibreOffice * Content in cell A1 shows 123,45€ as expected * Right click > Format Cell * Format is 'Number' with format code: #.##0,00 "€";[RED]-#.##0,00 "€" Not sure this is 'bad' behavior (should be imported as currency, not?) * Resaved as .xlsx * Open .xlsx in Excel * Shown content in cell A1 is 123,45€ which is correct. * (in Excel) Right click > Format Cells * Format is 'Custom' with format code: #.##0,00 "€";[RED]-#.##0,00 "€" So, looks like the number format isn't roundtripped correctly. Kind regards, Joren
Hello Joren, Sorry for the late anwser, i was pretty busy at work. My build id is d7dbbd7842e6a58b0f521599204e827654e1fb8b. > * Open Excel > * In cell A1 I enter 123,45 > * Right click > Format Cell > * Choose 'currency' format with 2 decimals > * OK; cell now shows 123,45€ > * Save as .xlsx ok. > * Opened saved .xlsx using LibreOffice > * Content in cell A1 shows 123,45€ as expected > * Right click > Format Cell > * Format is 'Number' with format code: #.##0,00 "€";[RED]-#.##0,00 "€" ok, but exactly i have # ##0,00 "€";[RED]-# ##0,00 "€". At this moment the display is fine for the original cell. If I apply this format in a new cell with a values of 123,45 as a custom format, it displays 1,23€. For information in Right click > Format Cell > Number, the last one with the description # ##0,00 "€";[RED]-# ##0,00 "€", the example displayed here is 1,23€. Maybe something wrong with the french version ? > * Resaved as .xlsx > * Open .xlsx in Excel Or LibreOffice, the result is the same for me. > * Shown content in cell A1 is 123,45€ which is correct. Not for me, it displays 1,23€. * Right click > Format Cell shows : # ##0,00 €;[RED]-# ##0,00 € The " are gone. I don't know if it's the same for every versions but in the french version the format # ##0,00 €;[RED]-# ##0,00 € doesn't display the result excpected. And this is the case for both LibreOffice and Excel 2010. This is because of the space I think, # ##0,00\ €;[RED]-# ##0,00\ € works as excepted. Kind regards.
Hi Pierre, Please could you attach the xlsx file created with MS-Excel, so that tester who do not have MS-Excel can try to reproduce the problem you describe? Best regards. JBF
Created attachment 98486 [details] Test created With MS Excel
Created attachment 98487 [details] Test "saved as" with Libre Office
It seems there is a problem with the thousands separator: if I open your xslx file with LO 4.2.5.0.0+ under Ubuntu 14.04 x86-64 and try to modify the cell format by unchecking the Thousands separator, LO crashes. Please, could you test that on your side? Best regards. JBF
Same crash with the master build from sources updated last night (Build ID: d6c42a503fb4237d5aa86eece3bf1fc1fba87a4b) Best regards. JBF
Hi Jean-Baptiste, No crash on my side under windows 7 Pro SP1 x64 when I uncheck the thousand separator. I think you find an other issue :). But I don't think the thousands separator is the problem. As I said before the format "# ##0,00 €;[RED]-# ##0,00 €" saved by LO doesn't display the result excpected. And this is the case for both LibreOffice and Excel 2010. This is because of the space before the "€" character. The format "# ##0,00\ €;[RED]-# ##0,00\ €" works as excepted on both. Best regards.
Created attachment 109931 [details] Backtrace of crash when unchecking thousands separator attachment 98486 [details] crashes LibO, when unchecking the thousands separator in cell formatting. Win 7 64-bit Version: 4.5.0.0.alpha0+ Build ID: 772befa08f02b08da1ab493896a0744bc73781c7 TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-23_22:39:02
I'm setting to NEW. If for nothing else, the crashing.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
Still crashing when I try to uncheck the thousands separator with Version: 5.1.0.1.0+ Build ID: f1d55069f1997e40fa20a5251d450eefe9171268 CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; Ubuntu_15.10_x86-64 Locale : fr-FR (fr_FR.UTF-8) Workaround: 1/ open the xlsx file with LO 2/ remove the direct formatting 3/ save as .ods 4/ add currency formatting 5/ save Now you can uncheck thousands separator without crash. Best regards. JBF
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.5 or 5.3.0 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170306
No crash anymore with : Version: 5.3.3.0.0+ Build ID: 8472f86d64fddd0afd7440cdb72eafbef7dcb301 Threads CPU : 4; Version de l'OS :Linux 4.4; UI Render : par défaut; VCL : gtk3; Moteur de mise en page : nouveau; Ubuntu_16.04_x86-64 Locale : fr-FR (fr_FR.UTF-8); Calc: single Version: 5.4.0.0.alpha0+ Build ID: 9aee1f80a50f950a8c2035df6ccdc2b420e1e4f8 Threads CPU : 4; Version de l'OS :Linux 4.4; UI Render : par défaut; VCL : gtk3; Ubuntu_16.04_x86-64 Locale : fr-FR (fr_FR.UTF-8); Calc: single Closing as WorksForMe. Please, feel free to reopen if you disagree. Best regards. JBF