[Libreoffice-bugs] [Bug 35020] New: Find & Replace changes case of sheet name in formulas Windows XP

[bugzilla-daemon at freedesktop.org]

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

           Summary: Find & Replace changes case of sheet name in formulas
                    Windows XP
           Product: LibreOffice
           Version: LibO 3.3.1 release
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: wjkirby at gmail.com


Created an attachment (id=44131)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=44131)
screen shot of error

When using a multi-sheet spreadsheet that has a formula on one sheet that
retrieves data from another sheet. Using find & replace to make change in cell
number will change the case of the sheet's name from uppercase to lowercase
causing the formula to fail. I've included a screen shot to help explain what
I'm seeing. If you look at the formula bar you will see the sheet name is
lowercase. If you look at the tabs at the bottom of the spreadsheet you will
see that the sheet name is actually uppercase. Before I do the find & replace,
the formula contains uppercase letters for the sheet name. This happens on
Windows XP but not in Ubuntu 10.10

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