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.