https://bugs.documentfoundation.org/show_bug.cgi?id=123510
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEEDINFO |RESOLVED
--- Comment #7 from m.a.riosv <[email protected]> ---
If all values in the range to sum are numbers or text numbers not other kind of
strings, then =SUMPRODUCT(A1:A2*1) can work, because it forces the conversion.
And direct references to one cell with text numbers should work also.
Another issue sure is that change the behavior can break existing forms.
Forms don't take care of what the receiver does with the values, in this case a
spreadsheet.
If you want reopen as request for enhancement on the second box of Importance
field, adapting the title.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs