[Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #16 from QA Administrators --- Dear Simon, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order

[Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #15 from QA Administrators --- Dear Simon, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #14 from Wolfgang Jäger --- An actual bug shown in the example the bug reporter attached may be that the interection mode is handled as if the defined range was $Sheet1.$A$3:$A$20. But this is also the case if

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 Wolfgang Jäger changed: What|Removed |Added CC||j...@psilosoph.de --- Comment

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #12 from ady --- (In reply to m.a.riosv from comment #11) > (In reply to ady from comment #10) > > . > > =SUM(OFFSET(myRange; 1; 0)) > > Result: 152 (the enire named range except for the first upper-left value) > > Because

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #11 from m.a.riosv --- (In reply to ady from comment #10) > . > =SUM(OFFSET(myRange; 1; 0)) > Result: 152 (the enire named range except for the first upper-left value) Because in this case, OFFSET return a reference, not a

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 ady changed: What|Removed |Added Version|6.4.7.2 release |Inherited From OOo --- Comment #10 from

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 ady changed: What|Removed |Added Hardware|x86 (IA32) |All OS|Linux (All)

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #9 from ady --- Using attachment 173044, still repro in 7.6.alpha built 2023-04-27. In attachment 173044, the named range upper-left cell is A3, but the OFFSET formula doesn't seem to take cell A3 as base. Instead, it just

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #8 from QA Administrators --- Dear Simon, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 raal changed: What|Removed |Added CC||r...@post.cz --- Comment #6 from raal

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #5 from Simon --- (In reply to Uwe Auer from comment #2) > (In reply to Simon from comment #0) > > 1.create named range of multiple cells say myRange > > 2.create cell =OFFSET( myRange, 1, 0) > > This doesn't work at all

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #4 from Simon --- (In reply to m.a.riosv from comment #1) > Please can attach your sample file to test. Done -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #3 from Simon --- Created attachment 173044 --> https://bugs.documentfoundation.org/attachment.cgi?id=173044=edit spreadsheet showing error -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 --- Comment #2 from Uwe Auer --- (In reply to Simon from comment #0) > 1.create named range of multiple cells say myRange > 2.create cell =OFFSET( myRange, 1, 0) This doesn't work at all and gives a "#VALUE!" (wrong data type) error.

[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

https://bugs.documentfoundation.org/show_bug.cgi?id=142953 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o