| Summary: | VIEWING: TRUE FALSE showing up as 1,0 except when conditional formatting is applied | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | afonit |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.6.5.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
I was going to attach an example workbook that had this then I realized: when I created a new workbook, this behavior was not occurring. it is only occurring in these existing workbooks that came from excel. So it does not appear to be the default behavior in LO that I thought it was. |
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