Description: lets say A1 cell have a word "ABC", and at A2 with formula = A1 * 2, the error is #VALUE!, where it should make A1=0. but if I do this to replace the formula at A2, it works, SUM(A1) * 2, which would equal to zero. Steps to Reproduce: lets say A1 cell have a word "ABC", and at A2 with formula = A1 * 2, the error is #VALUE!, where it should make A1=0. but if I do this to replace the formula at A2, it works, SUM(A1) * 2, which would equal to zero. Actual Results: lets say A1 cell have a word "ABC", and at A2 with formula = A1 * 2, the error is #VALUE!, where it should make A1=0. but if I do this to replace the formula at A2, it works, SUM(A1) * 2, which would equal to zero. Expected Results: lets say A1 cell have a word "ABC", and at A2 with formula = A1 * 2, the error is #VALUE!, where it should make A1=0. but if I do this to replace the formula at A2, it works, SUM(A1) * 2, which would equal to zero. Reproducible: Always User Profile Reset: No Additional Info: lets say A1 cell have a word "ABC", and at A2 with formula = A1 * 2, the error is #VALUE!, where it should make A1=0. but if I do this to replace the formula at A2, it works, SUM(A1) * 2, which would equal to zero.
There is not such bug. Pls take a look at the help about SUM() https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sum.html?DbPAR=CALC#id431636401649762 And about error 519 in https://help.libreoffice.org/7.3/en-US/text/scalc/05/02140000.html?&DbPAR=SHARED&System=WIN