Created attachment 121169 [details] proba.xlsx 1. Open the attached proba.xlsx 2. It has 19 000 Ft in cell C4. 3. Save as XLSX (proba2.xlsx), reopen. 4. C4 has 19Ft in it, the underlying number is the same (19000).
Created attachment 121170 [details] proba2.xlsx
Hi @Andras, with the first sample, I'm not able to reproduce the issue. The same format after save and reopen. The second one has a different format. proba: #.##0" Ft" proba2: #.##0."Ft" The second format has a different meaning because the dot after the number places, it is used to divide the value per thousand, by million with two dots. Seems strange this change of format. " Ft" -> ,"Ft"
I forgot. Win10x64 Version: 5.0.4.1 (x64) Build ID: 2def61bcbb29a7a8611b833682fe1291910b11ad
I used Linux, the original reporter (http://bug.openscope.org/browse/OOO-1056) used Windows 7. Maybe I have to try 5.0.4.1, and check if this bug was fixed there.
I can confirm with Version: 5.2.0.0.alpha0+ Build ID: de9d0e797903e7ecc19be2b05c7e89d5936ae02d Threads 4; Ver: Linux 4.2; Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-12-03_04:13:00 proba format cell C4: # ##0 "Ft" is the same after after resave, but representation on screen is different - 19 000 Ft and 19Ft Works correct in Version: 4.4.0.0.alpha0+ Build ID: c0a709e9912de8adb6777b40197accf865c4f046 -> regression
Thanks I tested several versions OS Windows 7 64bit Works correct in Version: 4.0.0.3 x86 Works correct in Version: 4.0.6.2 x86 19 000Ft (before) -> 19 000Ft (after saving) !!! The problem starts --- From Version: 4.1.0.1 x86 After saving - Different 19 000Ft -> 19Ft Version: 4.1.0.1 x86 Version: 4.2.0.1 x86 Version: 4.3.0.1 x86 Version: 4.3.7.2 x86 Version: 4.4.0.1 x86 Version: 4.4.0.3 x86 Version: 5.0.4.1 x64 Version: 5.0.3 x86
I forgot exactly. Works correct in Version: 4.0.6.2 Build az.: 2e2573268451a50806fcd60ae2d9fe01dd0ce24) Repair expected?
Adding keyword 'bibisectRequest'.
*** Bug 101738 has been marked as a duplicate of this bug. ***
This issue was resolved with LibreOffice 5.1. Tested on Ubuntu 16.04
Created attachment 130564 [details] test file - start
Created attachment 130565 [details] Result
Open TEST.xlsx file -> Microsoft Excel. B3 cell 34 000 Ft (Format - currency) 1. Open TEST.xlsx file -> LibreOffice Calc 5.2.4.2 2. Modify B3 cell 17000 (not modify format !!!!!) 3. SAVE 4. Open TEST.xlsx file -> Microsoft Excel. RESULT 17 Ft Attachment -> progress(BUG.jpg)
Created attachment 130566 [details] Progress