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