[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
bugzilla-daemon at freedesktop.org
Wed Aug 8 15:09:58 CEST 2012
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.
More information about the Libreoffice-bugs
mailing list