[Libreoffice-bugs] [Bug 41138] New: Unexpected calculation when use single quote with numbers

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Thu Sep 22 23:37:50 PDT 2011


https://bugs.freedesktop.org/show_bug.cgi?id=41138

           Summary: Unexpected calculation when use single quote with
                    numbers
           Product: LibreOffice
           Version: LibO 3.4.3 release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: mika.pihlamo at gmail.com


When number (not number?) start with single quote add operator calculate it as
number, but sum function did not.

A1 = 12
A2 = '4

= sum(a2:a3) evaluate to 12
= A1+A2 evaluate to 16

That is not logical.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.


More information about the Libreoffice-bugs mailing list