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.

Reply via email to