https://bugs.documentfoundation.org/show_bug.cgi?id=163964
Bug ID: 163964
Summary: Converting Calc Expression to MS Excel (name > @name)
works in formula but not inside another Expression
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In Calc I created some expressions (from menu Sheets > Named Ranges and
Expressions) e.g:
expr1 = A1xA2
expr2 = B2 + expr1
I can use both expressions in the formula bar in calc simply by typing expr1 or
expr2 to do some stuff with them.
The file is saved as .xlsx (because sadly I really have to).
When I open it in MS Excel, in the formula bar, any reference to the above
expression are correctly converted to @expr1 or @expr2.
@expr1 throws the correct value but @expr2 throw a syntax error #NAME?.
Looking into those expressions in Excel (Name Manager), the expressions refers
to:
expr1 = A1xA2 (showing correct value)
expr2 = B2 + expr1 (showing #NAME? value) - notice that this is exactly the
same than in calc, and expr1 is not converted to @expr1 inside expr2.
In there if I modify expr2 to B2 + @expr1 then @expr2 throws the correct value.
--
You are receiving this mail because:
You are the assignee for the bug.
