<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=38343#c21">Comment # 21</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=38343">bug 38343</a> from <a class="email" href="mailto:xv3247@gmail.com" title="Xavier Van Wijmeersch <xv3247@gmail.com>"> Xavier Van Wijmeersch</a> <pre>I agree with <a href="show_bug.cgi?id=38343#c19">comment19</a> "I am not sure if this is really a bug or only a misunderstanding of what are relative and absolute references. Indeed, in the test case provided by Sasha, if you change the references in B3:B10 from relative to absolute, then the filter works as expected." My opinion its a misunderstanding off relative and absolute references. I think it can be closed as WFM Best regards</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>