I created an Excel with Apache POI XSSF. I needed to make certain columns readonly. so I set the sheet as protected and then set the cellstyle to unlocked for the editable columns. When the user clicks on any of the non-editable columsn I get this message about the chart/sheet being protected and user needs a password to unprotect it. This is higly misleading since only certain columns are readonly. How do I can change this alert message ?
How to change dialog box message when cells in excel is readonly - with Apache POI XSSF
41 Views Asked by user3594089 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 EXCEL
- Power Query / M Code, extract a list of tables into one main table, some column headers same but some different and in different order (and in row 2)
- Is there a way to validate the cell format (from excel) to fetch the symbol from it (in Java)?
- Excel - Visual Basic, macro with autofill "1"
- Getting Run-time error '13': Type Mismatch using .Find
- Getting website metadata (Excel VBA/Python)
- Excel Code Editor doesn't work (blank window)
- How to find out how many of each 2, 3 and 4 required to fit in 100 using excel?
- How would I apply a rather complex summation formula like this in Excel?
- Removing a Button from Customized Excel Ribbon
- Excel - Update Item Description Based on Accessories Ordered with It
- select duplicates from data based on another column
- How to use VBA to bold just some text
- VBA Code to filter and get values from csv to excel worksheet
- Look up max alpha numeric value
- Azure Batch for Excel VBA
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 XSSF
- Attempting to write a row[10] in the range [0,21] that is already written to disk
- Apache POI throwing NPE
- How to change dialog box message when cells in excel is readonly - with Apache POI XSSF
- Positioning an Image in the middle of a cell using ApachePOI
- Apache POI centering all cells in all sheets
- Apache POI SXSSFWorkbook ideal window size
- Apache POI 5.2.2 : How to draw a XSSFSimpleShape based on Offsets and Dimensions in Centimeters?
- Java Apache POI XSSFWorkbook saving column data as text instead of numeric
- How do I make a Junit test to test a method that returns XSSFWorkbook?
- excel sheet style changed after mergin it into one new excel file
- How to get xlm macro sheet from excel with apache poi XSSFWorkbook?
- How to sanitize window objects to prevent reflected XSS attacks in java
- NPOI XSSFRichTextString/XSSF Hyperlink Excel with hyperlink for part of text
- Unsure how to resolve "ERROR StatusLogger Log4j2" error
- Java multiple constructors with different data types, oke or not, and how to handle?
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 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?