https://issues.apache.org/ooo/show_bug.cgi?id=104761
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Regina Henschel <[email protected]> --- "based on the CURRENT() cell value" CURRENT() is not the cell value, but it is the intermediate calculation result while calculating the formula. And I'm not sure about the internal order of calculation in case of function INDEX. For example =INDEX( A1:A5; B1+MATCH( CURRENT(); A1:A5 )-B1) will work. I guess, that you can use a total different and easier way to get your goal. You should discuss the problem in a mailing list or forum. http://wiki.openoffice.org/wiki/Communication -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
