autofilter is red incorrectly #296
Description
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 }) } }