[Bug 160088] Conditional formatting not working with dates <1900
https://bugs.documentfoundation.org/show_bug.cgi?id=160088 ady changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160088] Conditional formatting not working with dates <1900
https://bugs.documentfoundation.org/show_bug.cgi?id=160088 Bill Maier changed: What|Removed |Added CC||libre.book...@passinbox.com --- Comment #3 from Bill Maier --- I agree with the comments by Werner Tietz and Rafael Lima. I think a question that must be asked is this: should the program allow users to treat dates as raw numeric values? If so then everything is working fine. If not, then when the user enters the condition "[date] > 0" an error should be flagged. For consistency I think dates should not be treated as numbers, but I can see this being defined either way. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160088] Conditional formatting not working with dates <1900
https://bugs.documentfoundation.org/show_bug.cgi?id=160088 --- Comment #2 from Rafael Lima --- I'd say this is NAB. If the point of using "> 0" is to simply determine whether the cell is empty or not, you could simply use the "is not equal to" rule of the conditional formatting and then add "" as the value. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160088] Conditional formatting not working with dates <1900
https://bugs.documentfoundation.org/show_bug.cgi?id=160088 --- Comment #1 from Werner Tietz --- Any Date before Calc-»Epoch« (1899-12-30) is a negative floatingpoint-number in units of days before 1899-12-30 -- You are receiving this mail because: You are the assignee for the bug.