autofilter is red incorrectly

[sparkyandrew]

sheet.get_auto_filter() is not always reading the autofilter correctly.

This case, there's one autofilter ("A4:DH9") for sheet and two autofilter ("B1:DG1") in custom sheet view, fn get_auto_filter() always get the autofilter in custom sheet view.

Code:

let input_file = "../excel/autofilter2.xlsx"; let book = umya_spreadsheet::reader::xlsx::read(input_file).unwrap(); let sheet1 = book.get_sheet_by_name("Sheet1").unwrap(); if let Some(auto_filter) = sheet1.get_auto_filter() { println!( "auto_filter for from_sheet {} is {:?}", sheet1.get_name(), auto_filter ); } Output: auto_filter for from_sheet Sheet1 is AutoFilter { range: Range { start_col: Some(ColumnReference { num: 2, is_lock: false }), start_row: Some(RowReference { num: 1, is_lock: false }), end_col: Some(ColumnReference { num: 111, is_lock: false }), end_row: Some(RowReference { num: 1, is_lock: false }) } }

autofilter2.xlsx

[MathNya]

@sparkyandrew Thank you for your inquiry. We have identified the cause. umya-spreadsheet does not support custom sheet views. As a result, it was unable to correctly retrieve values from features like autofilter. This requires support for custom sheet views. Since this involves a fairly large-scale modification, we will address it in Version 3.0.0.