https://bugs.documentfoundation.org/show_bug.cgi?id=145384

            Bug ID: 145384
           Summary: Doesn't tolerate lowercase in formula range
           Product: LibreOffice
           Version: 7.2.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 176001
  --> https://bugs.documentfoundation.org/attachment.cgi?id=176001&action=edit
And RTF doc made with Microsoft Word using a lowercase range - this is
correctly imported

In Microsoft Word I entered lowercase for a range it saved SUM(a1:a3) in the
RTF file.  LibreOffice Writer correctly changed this to SUM(<A1:A3>) when
importing.

But if I manually enter a lowercase range SUM(<a1:a3>) in LibreOffice Writer
its not tolerated.  The value changes to 0 and when I go back to the formula
editor the formula has become SUM(<?:?>).  Perhaps the rules for ranges is
uppercase only but this seems overly strict and unfriendly since we are inside
angle brackets (meaning range).  Writer should tolerate lowercase ranges or
convert it to uppercase.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to