[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 --- Comment #8 from Eike Rathke --- Importing an Excel file should switch the option to a proper value though, i.e. "Excel A1", unless it was explicitly saved with Calc using a different value, for example And it does for me.

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 m.a.riosv changed: What|Removed |Added Resolution|FIXED |NOTABUG --- Comment #7 from

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 ThomasU changed: What|Removed |Added Resolution|NOTABUG |FIXED --- Comment #6 from ThomasU

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 m.a.riosv changed: What|Removed |Added Resolution|--- |NOTABUG Status|REOPENED

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 --- Comment #4 from ThomasU --- Hi Miguel, I don't understand your reply. What I highlighted is the incompatibility between CELL() and INDIRECT(). In a sheet imported from Excel into LibreOffice, CELL() returns a $Sheet.A1 reference

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 --- Comment #3 from m.a.riosv --- Because INDIRECT($Sheet2!A1) is what you want, try INDIRECT("$Sheet2!A1"). -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 ThomasU changed: What|Removed |Added Status|RESOLVED|REOPENED Ever confirmed|0

[Libreoffice-bugs] [Bug 132519] INDIRECT() to other sheet from Workbook imported from Excel fails with Ref!

2020-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132519 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC|