https://bugs.documentfoundation.org/show_bug.cgi?id=93673
Bug ID: 93673
Summary: Formulas with dates don’t work any more (since 4.4.3)
Product: LibreOffice
Version: 4.4.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: libreoffice.20.geckoespre...@spamgourmet.com
Created attachment 118187
--> https://bugs.documentfoundation.org/attachment.cgi?id=118187&action=edit
Time sheet (German)
In the attached spreadsheet (a time sheet), I use the following formula to sum
up time values depending on the current date:
F2: {=SUM(($B$4:$B$368<=TODAY())*$F$4:$F$368)}
Column B contains dates, Column F times.
Starting with version 4.4.3, the formula resolves to #VALUE!, the status
message telling me “Error: Wrong data type”.
The document is German, but I marked some fields (times) which you can edit in
orange. As soon as one line is filled with values, all cells in row 2 should
display proper values.
I checked that this happens only in versions 4.4.3 and above (currently 5.0.0).
4.4.2 and below worked fine.
Hopefully you accept this as a bug, since it renders several of my spreadsheets
useless. On Windows I could stay at version 4.4.2 if necessary, but with
prepackaged Linux distributions, I will run into serious trouble soon…
Thanks for your help.
--
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
