https://bugs.documentfoundation.org/show_bug.cgi?id=160371
ady <adylo811...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|unspecified |Inherited From OOo
Keywords| |filter:xlsx
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
--- Comment #2 from ady <adylo811...@gmail.com> ---
The problem is that when importing and/or exporting the intersection operator
(whether with Formula Syntax as Calc A1 or as Excel A1 or as R1C1) from/to
xlsx, the import and/or export fails when using INDIRECT().
To be clear, the _argument_ for INDIRECT() is not the issue – the import/export
in such case is already known to "fail", not portable, because it is always
treated as a string.
The case presented here is about intersecting between INDIRECT()'s.
Using Calc A1 (!) syntax:
=(INDIRECT("Column_1")!INDIRECT("Row_1"))
...where "Column_1" and "Row_1" are known range names, _seems_ to work. But
save as a new xlsx file and reload > Err:508.
OTOH:
=(Column_1!Row_1)
and:
=SUM(Column_1!Row_1)
will still work after saving as xlsx and reloading.
This works correctly when saving as ods.
Tested with recent 24.8 alpha.
--
You are receiving this mail because:
You are the assignee for the bug.
