Created attachment 118187 [details]
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:
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.
Reproducible with Verze: 18.104.22.168
ID sestavení: 1b1a90865e348b492231e1c451437d7a15bb262b
Works with version 4.0, regression
This is by design (so not abug), see https://bugs.documentfoundation.org/show_bug.cgi?id=42481
Especially comment 18.
If you want empty strings treated as 0, you need to change the settings in:
Tools > Options > LO Calc, Formula.
Detailed calculation settings.
(In reply to GerardF from comment #2)
> This is by design (so not abug), see
> Especially comment 18.
> If you want empty strings treated as 0, you need to change the settings in:
> Tools > Options > LO Calc, Formula.
> Detailed calculation settings.
Let this open, I change the settings and still obtain #VALUE! :(
(In reply to GerardF from comment #3)
> Let this open, I change the settings and still obtain #VALUE! :(
Yes, I have the mentioned setting active.
As I wrote, it worked until 4.4.2 without changing any settings or file contents.
This is calculating with strings within an array/matrix formula.
*** This bug has been marked as a duplicate of bug 91453 ***
Migrating Whiteboard tags to Keywords: (bibisectRequest)