You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/10/15 08:11:12 UTC
[Bug 63849] New: Error writting table with column name containing LF
(line feed)
https://bz.apache.org/bugzilla/show_bug.cgi?id=63849
Bug ID: 63849
Summary: Error writting table with column name containing LF
(line feed)
Product: POI
Version: 4.0.1-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: marek.lech@atena.pl
Target Milestone: ---
Created attachment 36829
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36829&action=edit
File written by POI
I am reading xlsx file which contains defined table, then i am writting this
file back with another name. When trying to open this new file Excel complains
with message: "We found a problem with some content in 'file.xlsx'. Do you want
us to recover as much as we can?....". I have found, that problem is with
table. Original file has table written as:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<table xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="xr xr3"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3"
id="1" xr:uid="{26A11951-810F-49EC-AAFA-5722529390E0}" name="tblPojazdy"
displayName="tblPojazdy" ref="A1:C2" totalsRowShown="0" headerRowDxfId="6"
dataDxfId="5" tableBorderDxfId="4" headerRowCellStyle="Normalny 2 2"
dataCellStyle="Normalny 2 3">
<autoFilter ref="A1:C2"
xr:uid="{D0BFECB1-1E52-4089-B920-3A52DB2D9F23}"/>
<tableColumns count="3">
<tableColumn id="12"
xr3:uid="{B01BB46B-E7FD-4689-8E30-2B2DC686DD21}" name="Suma ubezpieczenia"
dataDxfId="3" dataCellStyle="Walutowy 3"/>
<tableColumn id="16"
xr3:uid="{C2B2204D-FC92-4D87-A503-BE359CB3F23A}" name="AC_x000a_[serwis]"
dataDxfId="2" dataCellStyle="Normalny 2 3"/>
<tableColumn id="22"
xr3:uid="{C3D15AB3-0D6E-4F8D-B4D2-18CAC734CC80}" name="Składka AC"
dataDxfId="1" dataCellStyle="Normalny 2 3">
<calculatedColumnFormula>tblPojazdy[AC
'[serwis']]*tblPojazdy[Suma ubezpieczenia]</calculatedColumnFormula>
</tableColumn>
</tableColumns>
<tableStyleInfo showFirstColumn="0" showLastColumn="0"
showRowStripes="1" showColumnStripes="0"/>
</table>
but POI is generating:
<?xml version="1.0" encoding="UTF-8"?>
<table mc:Ignorable="xr xr3" id="1"
xr:uid="{26A11951-810F-49EC-AAFA-5722529390E0}" name="tblPojazdy"
displayName="tblPojazdy" ref="A1:C2" totalsRowShown="0" headerRowDxfId="6"
dataDxfId="5" tableBorderDxfId="4" headerRowCellStyle="Normalny 2 2"
dataCellStyle="Normalny 2 3"
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3">
<autoFilter ref="A1:C2"
xr:uid="{D0BFECB1-1E52-4089-B920-3A52DB2D9F23}"/>
<tableColumns count="3">
<tableColumn id="12"
xr3:uid="{B01BB46B-E7FD-4689-8E30-2B2DC686DD21}" name="Suma ubezpieczenia"
dataDxfId="3" dataCellStyle="Walutowy 3"/>
<tableColumn id="16"
xr3:uid="{C2B2204D-FC92-4D87-A503-BE359CB3F23A}" name="AC
[serwis]" dataDxfId="2" dataCellStyle="Normalny 2 3"/>
<tableColumn id="22"
xr3:uid="{C3D15AB3-0D6E-4F8D-B4D2-18CAC734CC80}" name="Składka AC"
dataDxfId="1" dataCellStyle="Normalny 2 3">
<calculatedColumnFormula>tblPojazdy[AC
'[serwis']]*tblPojazdy[Suma ubezpieczenia]</calculatedColumnFormula>
</tableColumn>
</tableColumns>
<tableStyleInfo showFirstColumn="0" showLastColumn="0"
showRowStripes="1" showColumnStripes="0"/>
</table>
Difference is in column name, originaly name="AC_x000a_[serwis]".
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63849] Error writting table with column name containing LF
(line feed)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63849
Marek <ma...@atena.pl> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #36830|Orriginal file created in |Original file created in
description|Excel |Excel
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63849] Error writting table with column name containing LF
(line feed)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63849
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63849] Error writting table with column name containing LF
(line feed)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63849
--- Comment #1 from Marek <ma...@atena.pl> ---
Created attachment 36830
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36830&action=edit
Orriginal file created in Excel
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org