https://bugs.freedesktop.org/show_bug.cgi?id=46555
Bug #: 46555
Summary: UI, Cannot change relative to absolute references in
Excel R1C1 syntax
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Pressing the Shift+F4 keys whilst selecting a cell containing a cell reference
should cycle the cell reference between the four combinations of relative and
absolute reference.
If the worksheet syntax is set to 'Calc A1' or 'Excel A1' the references cycle
correctly between relative and absolute, whereas in 'Excel R1C1' syntax the
reference doesn't change.
To reproduce the fault, set the syntax to 'Excel R1C1' from
Tools/Options/LibreOffice Calc/Formula/Formula Option tab, Syntax and select
'Excel R1C1'. Save.
Select a cell containing a cell reference and press Shift+F4 to cycle the
reference between relative and absolute reference.
This bug has been in LibreOffice since Open Office.
I am running LibreOffice 3.4.4 OOO340m1 (Build:402) on Ubuntu 11.10 Oneiric
Ocelot.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
