https://bugs.documentfoundation.org/show_bug.cgi?id=64499

m.a.riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
                   |                            |rg

--- Comment #30 from m.a.riosv <[email protected]> ---
Created attachment 136168
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136168&action=edit
Sample with another cell using INDEX instead OFFSET

I think issue comes from using volatile functions In the formula cell

On the first sample file, added a second cell for the formula using INDEX
instead OFFSET:
=OFFSET($A$13;$B$7-1;4)            doesn't work
=INDEX($A$13:$E$500;$B$7;5)        works

I have found it with a question on the Spanish Ask using TODAY in a financial
function in the cell with the formula, changing for a reference makes it works.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to