https://issues.apache.org/bugzilla/show_bug.cgi?id=44866
Summary: Problem with office SP3.
Product: POI
Version: 3.0-dev
Platform: Other
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P1
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
We are creating the Excel report, Report gets open fine in case of Office sp2,
but with office SP3 following msg gets when we open the excel report.
" Damage to the file was so extensive that repairs were not possible.
Excel
attempted to recover your formulas and values, but some data may have been
lost or corrupted."
We can see all the data but the fonts, colors and formula vanished.
To create the report following steps are performed
1. Get the template to generate the template.
fs = new POIFSFileSystem(new
FileInputStream(servlet.getServletContext().getRealPath("/") + tPath +
"//TestReport.xls"));
2. Create Work book
wb = new HSSFWorkbook(fs);
3. HSSFSheet sheet = wb.getSheet(name);
// name = here name of sheet present in template
HSSFRow row = sheet.getRow(4);
HSSFCell cell = row.getCell(4);
if (cell == null) {
cell = row.createCell(4);
}
setCell(cell, "Data to print in report.");
and wb object is set in request attribute and use to open excel report.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
