Attached spreadsheet shows simple addition in cell F25 to fail and return #VALUE! when one of the terms contains text. The same happens with subtraction. Note, by contrast, that the function SUM is able to tolerate text-containing cells in its parameter list. Possibly noteworthy is the fact that functions such as MIN, MAX, AVERAGE, &c, also all tolerate text-containing cells in their parameter lists. LO 3.5.7.2; Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b. OO calc 3.3.0 behaves in the same manner.
No attached file here. Please try again to attach & explain how to see that problem.
Dear Bug Submitter, Please read the entire message before proceeding. This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of FDO
Created attachment 162631 [details] sample for OP, samples for questionable results reopening as imho it's a valid question / valid conflict ... seeing it different to the OP, '#VALUE!' can be handeled by a user, silent semi intelligent 'help' is dangerous, for or against all highlighted results can be argued from different and conclusive points of view: - you shouldn't calculate text, - you should convert strings to numbers if applicable, - '+' and 'SUM' should have same result, - omission of arguments should be visible to the user - conversion of arguments should be visible to the user - school math standard, - TDF math standard, - excel compatibility, and plenty more ... the essential point is: while we are arguing about flavours of special points calc produces irritated users and wrong results ‚in the field’, (these wrong results may be right from the one or other point of view, that doesn’t help a user who had conclusive other expectations) the question of all questions is: 'where do we want to go'? and there could hardly be any other answer than: 'informed users which can handle the results’, (it’s a little as with democracy, informed people could handle that, if after elections 'politics' follows 'superior aspects' or if the flood of information overwhelms the individual because of the size of the administrative unit or information is manipulated, democracy is a worthless fraud) and ex$el compatibility: yes, it’s an important point, but should not spread errors or hinder progress, otherwise calc is blocked from ever becoming better than ex$el thus any formula which gets arguments or parameters which do not fully fit the type needed should mark it’s results accordingly, and these warnings should spread downstreams (it’s a spreadsheet isn’t it?) text proposal: ‚unusual or conflicting types detected within the arguments used for this cell, conversion and / or omission took place, pls. double check your results‘, imho ex$el started going that path, i don't know if already with warnings for arguments in formulas, but they started marking cells with 'deviating formatting' years ago, which is an attempt to produce 'informed users' and thus the right direction.
did i miss re-opening? or did someone re-close?
(In reply to b. from comment #5) > did i miss re-opening? or did someone re-close? I think it's an enhancement, but I can't invent a summary for it =( Eike, what's your opinion here?
Whether or if and how text is accepted as operands to mathematical operators entirely depends on the settings under Tools -> Options -> Calc -> Formula, Detailed Calculation Settings; if you check Custom settings several modes are available for conversion from text to number. Always #VALUE! is recommended to spot data errors early, but that's not what some other software does and not what is used in legacy documents so not the default (yet?) but the awkward "also locale dependent" instead.. See help https://help.libreoffice.org/latest/en-GB/text/shared/optionen/detailedcalculation.html > - '+' and 'SUM' should have same result, No. By definition SUM, AVERAGE, MAX, MIN, ... and other functions accepting cell ranges as number sequences *ignore* all text cells. Not a bug.