https://bugs.documentfoundation.org/show_bug.cgi?id=160515
m_a_riosv <miguelange...@libreoffice.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |miguelangelrv@libreoffice.o | |rg --- Comment #3 from m_a_riosv <miguelange...@libreoffice.org> --- Seems a hard-recalc solves the issue. Maybe the issue is the Autocalculte is not triggered for $Query.B35 because their formula is out of the PT range. Also a hard-recalc is pending at opening the file before apply the filter. At opening $Query.B35 has not the right value. With the option in Menu/Tools/Options/LibreOffice Calc/Formula/Recalculate on file load — For Excel 2007 and newer active, at list on this case solve the issue. Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.