46938
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
Existing color palette is broken(or not used) when using cell styles from opened workbook and creating new
|
2009-11-16
|
48336
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Error reading date
|
2009-12-03
|
51089
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Conditional formula is constant over cells, although it shouldn't be
|
2011-05-04
|
51591
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
org.apache.poi.ss.util.SheetUtil.getColumnWidth(sheet,col,false) does not apply full HSSFCellStyle
|
2011-07-30
|
51693
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Missing column
|
2012-03-14
|
53264
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
unable to create record instance..Not enough data (0) to read requested (6) bytes
|
2012-06-12
|
52067
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFChart createSeries not working properly when adding more than one series
|
2013-02-26
|
52541
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
setRowSumsRight does not work
|
2013-03-04
|
55130
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
provide method HSSFSheet.lockSelectLockedCells
|
2013-08-06
|
55396
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Formula added before referenced sheet wipes out formula causes exceptions
|
2013-08-09
|
53858
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Reading Hyperlink address having number sign(#) from cell giving improper link address
|
2013-09-16
|
53832
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
setSheetOrder() still breaks inter-sheet references
|
2013-11-02
|
55844
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Inline custom colors not correctly extracted by HSSFCellStyle#getFillForegroundColorColor
|
2013-12-08
|
54318
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
BuiltinFormats; Changes in the order of predefined formats
|
2014-04-23
|
56742
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Filename missing from result of getFormulaCell for formulas that reference ranges in other files
|
2014-07-18
|
54647
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
addConditionalFormatting fails for whole column ranges
|
2014-08-25
|
40283
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Cells which control radio buttons get reset when read by Excel
|
2014-09-01
|
56140
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
ConditionalFormat with formula returns wrong target
|
2014-09-01
|
56893
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Overflow in UnicodeString results in corrupted file when setCellValue() is called with a string larger than 32767
|
2015-03-01
|
45641
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Add methods in HSSFSheet to retrieve information about row and column groups
|
2015-05-01
|
48699
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
RecordFormatException: Unexpected remaining size (12)
|
2015-05-22
|
49023
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Various Protection options while protecting sheet is not available
|
2015-05-31
|
49461
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
POI fails to read XLS file and throws RecordFormatException: Unable to construct record instance
|
2015-05-31
|
52084
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
[PATCH] byte level verifier of SST serialization in various methods
|
2015-05-31
|
49315
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Crash when opening Microsoft EXCEL workbook in Windows7
|
2015-06-01
|
55295
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
DateUtil.isCellDateFormatted should probably handle data format "reserved-0x1c"
|
2015-06-01
|
57994
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Error "Unexpected record type" when trying to open formatted XLS file
|
2015-06-15
|
57093
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
LeftoverDataException: Initialisation of record 0x31 left 22 bytes remaining still to be read
|
2015-06-20
|
54354
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Right Side Border not rendered.
|
2015-08-11
|
46704
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
There is no way to add an image to Header/Footer
|
2015-10-07
|
47916
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
sheet setRowGroupCollapsed is behaving unexpectedly - not working
|
2015-10-29
|
48043
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Excel complains about a POI generated function
|
2015-10-29
|
46266
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
moveCell corrupts the row against further edits
|
2015-10-29
|
52086
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
[PATCH] SSTRecord.serialize() performance improvement patch for huge hssf output
|
2015-10-29
|
53888
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Incorrect formula value for empty string value
|
2015-10-29
|
54639
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
If a formula contains AND(..., ISBLANK(...), ...), Excel always evaluates the ISBLANK to false
|
2015-10-29
|
54533
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Shifting rows does not shift the Zero Height flag
|
2015-10-29
|
46742
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Remaining functionality for Sheet.shiftRows()
|
2015-10-31
|
58507
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
public external link access at Workbook level
|
2015-11-04
|
45260
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
Excel file unreadable due to applyFont()
|
2015-11-07
|
46989
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Support Array formulas
|
2015-11-25
|
58672
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFName validateName works not as specified (backslash not allowed)
|
2015-11-30
|
54509
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
Cells in shifting rows are not used in column-referencing formulas.
|
2016-01-31
|
47071
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Date format Localization
|
2016-02-14
|
58838
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Some cells are null when they aren't
|
2016-02-15
|
56499
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
IFERROR fails when written to spreadsheet
|
2016-02-15
|
53178
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
RunTimeException: "Unexpected tAttr" in getCellFormula()
|
2016-02-17
|
56123
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
ShiftRows, Bug in POI 3.10 Beta 2: "Could not find 'internal references' EXTERNALBOOK"
|
2016-03-11
|
47374
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
[Patch] Leave all levels collapsed
|
2016-03-12
|
57932
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
After excel merged cells, cellStyle.setWrapText style of the cell (true) failure, can automatically wrap
|
2016-03-13
|
58006
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
[PATCH] HSSF/XSSFSheet ColumnWidth VBA Compatible Methods
|
2016-03-13
|
59214
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
java.lang.IllegalArgumentException: Sheet index (1) is out of range (0..0)
|
2016-03-23
|
59239
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Update existing DataValidations formulas
|
2016-03-27
|
57062
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
poi cannot read date is when first column is empty and second column in date
|
2016-04-05
|
48404
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Support formulas with multi-sheet 3D references
|
2016-04-05
|
58240
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
POI generated xls file fails validation
|
2016-04-10
|
59670
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Sheet.getRow().getCell() gets the value from the next sheet along
|
2016-06-15
|
57929
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Why HSSFWorkbook.removePrintArea(index) invalid?
|
2016-06-20
|
59732
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
File Excel Created From Apache POI Can't Open by Ms Excel (file corrupt)
|
2016-06-20
|
59673
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
HSSFWorkbook#setSheetOrder does not update external sheet indexes in formula references with ranges rather than single cells
|
2016-07-05
|
53564
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Cannot draw a diagonal border
|
2016-07-19
|
57037
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
RecordFormatException - Leftover 486 bytes in subrecord data
|
2016-09-08
|
45565
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
poi-3.5-beta1-20080718.jar - content from a TextBox object of a 2003 xls document is not extracted.
|
2016-09-22
|
55063
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Can not use "/" as delimiter for date in german excel
|
2016-09-22
|
45531
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFDateUtil.getJavaDate() should return Date for negative cell values
|
2016-10-11
|
46411
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
Formatting of Excel date values < 1.0 show different date to Excel
|
2016-10-11
|
46136
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Add an ignore warning for cells with Numbers as Text
|
2016-10-29
|
60347
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Reading password protected worksheet (version - excel 95,97-2003)
|
2016-11-06
|
56114
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
setAsActiveCell doesn't (always) work
|
2016-12-28
|
60517
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Incorrect parsing multiple sheet in formula
|
2017-01-04
|
60838
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Office 2013 AP after column style will be lost
|
2017-03-18
|
60960
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
I want create a xls workbook that the sheets are greater than 64 and every sheet have comment, but it not work at the version 3.12 and later version.
|
2017-05-31
|
61155
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Exception "java.lang.RuntimeException: Failed to find end of row/cell records" when opening a XLS file
|
2017-06-16
|
60985
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFPrintSetup throws NPE when accessing print settings of existing XLS
|
2017-08-25
|
56651
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
AutoFilter name conflict
|
2017-11-04
|
31114
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
HSSFWorkbook(POIFSFileSystem fs) - constructor throwing exception
|
2017-12-05
|
61981
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
DataFormatter.formatCellValue(cell) throws IllegalArgumentException when the format is ""ddd,mmm dd OR ""dddd, mmmm dd, yyyy
|
2018-01-09
|
57462
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Problem with autofilter when reordering sheets.
|
2018-01-16
|
62030
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Column shifting in HSSF and SXSSF scenario
|
2018-01-24
|
62170
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
NumberFormatException when trying to get reference from named range with getRefersToFormula()
|
2018-03-09
|
62551
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
The function setSheetname() in the BoundSheetRecord class does not have check on length of sheet name, it throws java.lang.IllegalArgumentException if sheet name is more than 31.
|
2018-07-18
|
59675
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
CellFormat with Chinese locale doesn't return date in Chinese
|
2018-10-21
|
50833
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
workbook.write(outputstream) corrupts cell comments for protected workbooks
|
2018-12-26
|
58002
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
EscherAggregate.createAggregate doesn't always read NoteRecord
|
2019-01-06
|
58525
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
[PATCH] Optimization of adding/modifying named cells
|
2019-01-06
|
57104
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
LeftoverDataException: Initialisation of record 0x5B left 1 bytes remaining still to be read.
|
2019-03-10
|
62439
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Initialisation of record 0x1D(SelectionRecord) left 1 bytes remaining still to be read.
|
2019-04-15
|
63218
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
org.apache.poi.util.RecordFormatException: Extern sheet is part of LinkTable
|
2019-04-16
|
58818
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Cell comment not readed(return null)
|
2019-07-09
|
61004
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFColor depends on java.awt.Color which is not available on Android and Google App Engine
|
2019-08-19
|
63708
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Treat Window2 record as optional
|
2019-08-29
|
63152
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Too many identical CellStyles cause .xls to be incorrectly rendered in Office 365
|
2019-09-06
|
63709
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Provide support for generating DDE formulas in Workbooks
|
2019-11-17
|
63665
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Drop down's options don't appear when clicking arrow in excel exported with Apache POI when there are many cell comments
|
2019-11-17
|
64291
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
RecordFormatException: Not enough data (2) to read requested (4) bytes
|
2020-03-30
|
47247
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Initialisation of record 0x850 left 3060 bytes remaining still to be read.
|
2020-06-05
|
64500
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
LeftoverDataException: Initialisation of record 0x85(BoundSheetRecord) left 28 bytes remaining still to be read
|
2020-06-05
|
64517
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
The formula in the cell cannot be modified correctly
|
2020-08-13
|
57952
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSF org.apache.poi.hssf.record.RecordFormatException: Unhandled Continue Record followining class org.apache.poi.hssf.record.TabIdRecord
|
2020-11-18
|
64674
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
the formula of cell is disabled when ExcelToHtmlConverter is used
|
2020-12-30
|
65245
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
In Excel97-2003(xls), [¥300] is incorrectly output as [$300]
|
2021-04-28
|
65398
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Apache POI (actual version 5.0.0) corrupts workbook if it is HSSF and a sheet contains a chart and Apache POI manipulates the HSSFPatriarch of that sheet in any way
|
2021-06-24
|
65877
|
POI
|
HSSF
|
dev
|
NEED
|
---
|
Error while trying open a write protected xls file
|
2022-02-21
|
65190
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Wrong formatting when format starts with 0#
|
2022-03-20
|
66166
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
the data validation area of the cell is incorrect
|
2022-07-08
|
57074
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFCell.getCellStyle().getFillForegroundColorColor() returns incorrect color for xls file created using Microsoft Excel 2007
|
2023-08-07
|
62394
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Excel loses styles and formating after writing certain rows. Even if Cellstyles are not exhausted
|
2023-08-07
|
57897
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
RecordFormatException: Unable to construct record instance
|
2023-08-07
|
59677
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
HSSFWorkbook#setSheetOrder corrupts cross-sheet references when there are complicated external sheet indices
|
2023-12-19
|
63390
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
org.apache.poi.hssf.record.FtCfSubRecord.<init>(FtCfSubRecord.java:60)
|
2023-12-21
|
57390
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Match function with array argument in formula results in "File error: data may have been lost"
|
2024-02-26
|
55747
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
nested function in IF's in formulas produce #VALUE! error in excel
|
2024-02-26
|
55324
|
POI
|
HSSF
|
dev
|
REOP
|
---
|
formula returning #VALUE
|
2024-02-26
|
60833
|
POI
|
HSSF
|
dev
|
NEW
|
---
|
Initialisation of record 0x31 left 4 bytes remaining still to be read.
|
2024-04-02
|