https://bugs.documentfoundation.org/show_bug.cgi?id=150080
Bug ID: 150080 Summary: error Product: LibreOffice Version: 7.3.2.2 release Hardware: x86 (IA32) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: LibreOffice Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: dvien...@gmail.com 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. -- You are receiving this mail because: You are the assignee for the bug.