[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #30 from m.a.riosv <miguelangelrv at libreoffice.org> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170911/8d182ee7/attachment.html>