[Libreoffice-bugs] [Bug 138896] AutoFilter sort reference not updated with nested IF statement

[bugzilla-daemon at bugs.documentfoundation.org]

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

Colin <that.man.colin at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
             Status|NEEDINFO                    |UNCONFIRMED

--- Comment #4 from Colin <that.man.colin at gmail.com> ---
(In reply to Xisco Faulí from comment #3)
> Thank you for reporting the bug.
> Unfortunately without clear steps to reproduce it, we cannot track down the
> origin of the problem.
> Please provide a clearer set of step-by-step instructions on how to
> reproduce the problem.
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' once the steps are provided

There is a fully functioning spreadsheet attached with clear and concise
instructions on what cell to read, what is contained in the cell which column
to sort on and where to look after the sorting event.
The ascending ordered cell clearly demonstrates the efficacy of the simple
formula and the descending order sort clearly demonstrates how the second IF
statement does not respond appropriately to the sorting commands.

  Note the cell references in Cell M10
  =IF(J10="";"";IF(J11="";SUM(J7:J10);"")) xx--note the SUM() coordinates
  Note the cell references and result in Cell M434
  =IF(J434="";"";IF(J435="";SUM(J431:J434);"")) xxxx--- SUM() coordinates
  Sort Descending on Column Filter B
  Note the cell references and result in Cell M56 (The last pertinent cell)
  =IF(J56="";"";IF(J55="";SUM(J431:J434);"")) xx-- wrong SUM() coordinates

What could be more specific than the preceding seven lines accompanied by the
previously enclosed CALC file?

Please could you provide clear steps to define what I have missed - vagaries
don't help anybody

I have reset it to unconfirmed - perhaps somebody could actually read the
instructions already provided and then make an informed decision.

-- 
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/20201214/57ab43b9/attachment.htm>