[Libreoffice-bugs] [Bug 53244] New: EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 53244
           Summary: EDITING: Referencing cell on other sheet changed from
                    3.5.x to 3.6.0.0 release
    Classification: Unclassified
           Product: LibreOffice
           Version: unspecified
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: mondane.woodworker at gmail.com


Problem description: 

In a calc document which worked properly before 3.6.0 release (in 3.5.5.3), the
following formula for referencing a field on another sheet worked:

=Januari!A2

Using the exclamation point is the Excel way.

as of 3.6.0 release, the Excel way no longer works. The following formula does
work:

=Januari.A2

But it's a lot of work changing all reference using ! to using a . (dot).

Steps to reproduce:
1. create 2 sheets, one named 'Januari', one with 'bar' as name
2. fill cell A2 on sheet Januari with the string 'foo'
3. place the following formula in cell A1 on sheet 'bar': =Januari!A2

Current behavior:

The contents in cell A1 on sheet 'bar' display '#NAME?'

Expected behavior:

The contents in cell A1 on sheet 'bar' should display 'foo'

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.1 (KHTML, like Gecko)
Chrome/21.0.1180.60 Safari/537.1

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