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
