Bug 140085 - FILEOPEN XLSX Counting the number of autofiltered records in status bar does not happen
Summary: FILEOPEN XLSX Counting the number of autofiltered records in status bar does ...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Autofilter
  Show dependency tree / graph
 
Reported: 2021-02-02 09:48 UTC by NISZ LibreOffice Team
Modified: 2021-03-09 13:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
attachment 150713 file saved by Calc as xlsx (5.63 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-02-02 09:48 UTC, NISZ LibreOffice Team 		Details
Screenshot of the problem in Calc (55.97 KB, image/png)
2021-02-02 09:48 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2021-02-02 09:48:21 UTC 
Created attachment 169384 [details]
attachment 150713 [details] file saved by Calc as xlsx

This is split off from bug #124701 for the case of XLSX file format.

Steps to reproduce:
    1. Open attached file
    2. Position the selection to cell A1

Actual results:
The status bar shows “9 of 9 records found”

Expected results:
The status bar should show “6 of 9 records found”

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7eb289c49cc7245ef3001a39be0c15d06bbe875b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2021-02-02 09:48:40 UTC 
Created attachment 169385 [details]
Screenshot of the problem in Calc
Comment 2 m_a_riosv 2021-02-04 15:55:01 UTC 
I don't think it's a matter of file type, if it happens with both.
Comment 3 László Németh 2021-02-28 09:59:56 UTC 

*** This bug has been marked as a duplicate of bug 124701 ***
Comment 4 NISZ LibreOffice Team 2021-03-09 13:31:46 UTC 
Verified in:

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 72841008bf422dfd8553240b3a78f0474d03523c
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded Jumbo