I use cell format logic value 'Valeur logique' using VRAI/FAUX values in french version.
I save the file in .xlsx using format Microsoft Excel 2007-2013 XML.
If I save with "Save under" it works fine, if I store with "Save", when I reload the file the cell format is changed to category "Date" Format "BOOL99AN" wich is a user defined format, the description format is "BOOL"E"AN"
and the value dispayed of the cell is "BOOL99AN"
Steps to Reproduce:
1.In french version, clic right on a cell and select "Formater des cellules" choose "Valeur logique" and type "VRAI" in the cell. Then Save file with "Fichier > Enregistrer sous" choose type "Microsoft Excel 2007_2013 XML (.xlsx)(*.xlsx)" confirm "Utiliser le format Microsoft Excel 2007_2013 XML" then close the file.
2.Reload file and Save file with "Fichier > Enregistrer" then close the file.
3.Reload the file the format of the cell has been changed.
The Cell display "BOOL99AN" instead of "VRAI" or "FAUX"
"VRAI" or "FAUX"
User Profile Reset: No
No repro LO 5.0 and 6.0. Reproduced in LO 6.3+.
But, as they say, if it looks like a regression and behaves like regression, it still doesn't have to be regression. Unless proved differently with some quick bibisect.
English UI will also do and show bug. Steps:
1. make a cell with Boolean value TRUE
2. Save as XLSX and close
3. Reopen, see that value is right in LO (and MSO)
4. Save again as XLSX and close
5. Reopen in LO, see "BOOL99AN" (and reopen in MSO and see problem with content)
Created attachment 147675 [details]
Simpe test ODS
*** Bug 120664 has been marked as a duplicate of this bug. ***
Bibisected with win32-6.1 to
Resolves: tdf#115351 convert boolean equivalent format codes to proper Boolean
Adding Cc: to Eike Rathke
This also seems to be locale-dependent:
- Not reproduced with en-US
- Reproduced with hu-HU
Version: 22.214.171.124.alpha0+ (x64)
Build ID: 54b28638ab15f68731861ae903c732273b41f78a
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Created attachment 157663 [details]
Example file saved to xlsx twice with en-US locale - good
Created attachment 157664 [details]
Example file saved to xlsx twice with hu-HU locale - bad