I am using Apache poi 4.1.1 for SXSSFSheet. When calling sheet2.setAutoFilter(new CellRangeAddress(2,2,0,17)); internally the poi library validates sheetname. For this it group the letters and digits separately and tries to parse them. Eg. For sheetname AB00000000000000000011, it will split into AB and 00000000000000000011.Tried to adjust the range for autofilter. Tried to to change version of poi library.However the parsing logic for digit is as below in library which throws NumberFormatExcpetion for bigger values. Is there an alternative to set filter for worksheets with bigger sheet names.In org.apache.poi.ss.util.CellReference.java in method isRowWithinRange it is trying to do Long.parseLong(rowStr) throwing exception for bigger values.
your text
For SXSSFSheet autofilter is not working for Sheetname with bigger numeric values
51 Views Asked by Wonder At
0
There are 0 best solutions below
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in APACHE-POI
- Problem with sample code to set font properties for a whole XWPF Paragraph that includes Word fields
- Create filter on Integer column (with default values selected) while creating pivot table using apache poi
- Apache POI has some vulnerability with POI OOXML jar file
- The total number of document pages in the footer is not calculated correctly
- OutOfMemoryError: Java heap space. Read/Process Large Excel File(150MB) With Limited Memory (-Xmx130m) using Sax Parser
- Convert .docx to pdf using XDocReport
- Package[package ognl] of target class[class ognl.MethodFailedException] of target [ognl.MethodFailedException[java.lang.NoSuchFieldError:Factory]]
- word poi5.1.0 How to make chart add a series
- Is it possible to change Pivot Chart's (Pie chart) data color created using Pivot Table reference using Apache POI?
- Excel runs Apache-POI generated XLSX file but complains about working formula
- How to read Raw value rather then the formatted value from the excel sheet using POI library using XSSFReader class
- Apache POI Word insert both table and text at the same level
- Apache POI: get zoom level by using reflection
- APACHE POI: adding comment to existing word document
- Problem read formula excel file with apache poi
Related Questions in WORKSHEET-FUNCTION
- Using XLOOKUP against multiple sheets - Spill function not working as expected, but identical non-spill copied down formulas are working
- Hide/Unhide Blank Row Based on Cell Value and MsgBox Question
- If statement in Worksheet_Change not working with On Error Resume Next
- WorksheetFunction SumProduct Error 1004 in nested loop
- Different results for XIRR between Excel and ExcelFinancialFunctions 3.2.0
- Google Sheet - Data separation in Rows
- How do I Target Multiple cell inputs Worksheet_Change that will have different outcomes?
- Check if column not empty inside COUNTIFS function in zoho worksheet
- Handling formula result to Vlookup in VBA
- VBA refer to a column used range in a formula
- OpenAI API VBA function returns #Value! but MsgBox displays response
- How can set the Transpose function base index to 0 in Excel VBA?
- Comparing log in times of faculty and remarks will either be Present, Late or Absent
- Is there a way to autofill WorksheetFunction.Sum down the column?
- Which formula should I use to add column E values, grouped by year?
Related Questions in AUTOFILTER
- Update Cell Value in Filtered Sheet Via VBA
- VBA Paste on filtered sheet
- VBA autofilter to filter cells of strings (that contain numbers) and numbers
- Autofilter xlFilterAllDatesInPeriod"month" runs to an error suddenly
- Copying rows to another workbook based on if a cell holds a numeric value / condition: isnumeric = true
- Loop through an Excel sheet with an Autofilter on and copy ONLY specific column values from these filtered rows
- VBA "Object Required" Error (424) when trying to manipulate/delete filtered rows in vba macro
- Excel Interop Autofilter Range
- Macro to automatically delete row with the word "total"
- How autofilter column with specific text and numeric values?
- Delete Specific Items from Filtered Table
- VBA Excel - Copying Filtered Cells
- 3 criteria for Autofilter Macro, error: Expect Expression problem solving
- How to store filtered ranges into array?
- Excel VBA AutoFilter Error Filtering with Date Range
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?