https://bugs.documentfoundation.org/show_bug.cgi?id=120577
--- Comment #9 from Oliver Brinzing <[email protected]> ---
(In reply to Jon R Kibler from comment #7)
> I believe the correct fix is for both addition and sum to throw a #VALUE
> error when encountering a string. That would result in consistent behavior
> that would give the clue that one of the numbers is being viewed as a string.
you can adjust LO for basic operations to your needs via
Menu "Tools/Options.../LibreOffice Calc/Formula"
-> Detailed Calculation Settings
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/detailedcalculation.html?DbPAR=SHARED#bm_id3146799
why do you want to make LO become incompatible with excel?
https://a4accounting.com.au/handling-text-in-calculation-cells-in-excel/
--
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
