https://bugs.freedesktop.org/show_bug.cgi?id=61803
Priority: medium Bug ID: 61803 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: VIEWING: TRUE FALSE showing up as 1,0 except when conditional formatting is applied Severity: normal Classification: Unclassified OS: Linux (All) Reporter: afo...@gmail.com Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 3.6.5.2 release Component: Spreadsheet Product: LibreOffice Problem description: TRUE FALSE are showing up as 1,0, not sure if that is accepted behavior - I have searched through the docs, but I would think it should show TRUE FALSE by default. Primarily I would not expect the representation of TRUE FALSE to change to 1,0 based on conditional formatting. Steps to reproduce: 1. populate two columns with some values 2. create a third column that would have eg) A1=B1 etc.. so you could get results. The third column will then be showing 1's and 0's 3. Select the third column and go to format > conditional formatting > conditional formatting > add > if cell value is equal to (enter a 1) then hit ok Now the 1's turn to TRUE's Current behavior: default TRUE FALSE seem to be 1's, 0's Expected behavior: I would expect either: that true false would always be the representation of true false or: for the representation to be consistent even with the application of conditional formatting. eg) if it starts with 0, 1 stay as 0, 1 or if it starts with true false stay with true false EFFECT: The side effect of this current behavior is lets say you only applied the conditional formatting to 1's as done above, you then have your 3rd column filled with TRUE'S AND 0's - so it is mixing them up. Operating System: Fedora Version: 3.6.5.2 release -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs