https://bugs.documentfoundation.org/show_bug.cgi?id=93415
Bug ID: 93415
Summary: ADDRESS function seems not caring about formula syntax
parameter set to "Excel A1"
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I noticed what I think must be a bug with LibreOffice Calc, here comes the
fact:
1) I'm using Version 4.3.4.1
2) I went to Menu "Tools" > "Options", then "Libre Office Calc" > "Formula" and
set "Formula syntax" to "Excel A1" so to make my formulas more compliant to
Excel "default form" changing "." to "!" for worksheets reference separator
(that means "Sheet1.A1" will become "Sheet1!A1").
3) I then put in A1 the formula: "=ADDRESS(1,1,,,"Sheet1")" and I expected
something like "Sheet1!A1" as result BUT what I get is "Sheet1.$A$1" (the . is
not converted to ! despite having set "Excel A1" on formula syntax) !!!
--
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
