I am using boolean operations but want the result is readable in ONES and ZEROES. Formatting them as numbers give the correct aspect. But, after having save the spreadsheet and re-open it in another session, the format is back to boolean aspect (true oe false).
Created attachment 123534 [details] spreadsheet I currently use (ods file) This spreadsheet is a step by step CRC computation.
This problem occurs also with linux version.
Not reproduced. For me, if I change a cell in your file to number format, it stays that way after save & reload. You should probably try with a newer version (5.1.1). Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha0+ Build ID: 235411c9d47ecba88e46d859ea93bcecefb0c46e CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on March 11th 2016 64-bit, KDE Plasma 5 Build ID: 5.1.1.3 Arch Linux build-1 CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; Locale: fi-FI (fi_FI.UTF-8)
Created attachment 123547 [details] PDF of the sheet and the application version
you can see attached an exported PDF from V5.1.1.3 (french version) of the spreadsheet with hash(es) in cells where there are results of formule "XOR(cellX; cellY) or a copy of a cell that contains this result. When cells are enlarged, words "VRAI" (true) or "FAUX" (false) are readable. The spreadsheet was saved when all cells were formatted in number.
I can't reproduce. Win10x64 Version: 5.0.5.2 Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3 TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-0, Time: 2016-03-07_09:00:12 Version: 5.1.1.3 (x64) Build ID: 89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Please try resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/UserProfile Usually it's enough renaming/deleting the file "user/registrymodifications.xcu", it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.
Always bad after renaming user profile.
A solution (may be) : Using "text" format for all the cells from C3 to T66 solves the problem! Preceeding format was "number". If you can confirm you can close this bug report.