Re: XSSFSheet.addMergedRegion giving excel error

more info... In fact merging cell from two rows, for example row 49 and row 50 for cells in certain region say column f to column l is giving excel error(warning), if it is merging the cell in the same row there is no excel error. sheet.addMergedRegion(new CellRangeAddress( 49, 50,Column.f$,C

XSSFSheet.addMergedRegion giving excel error

After doing some research, I found out that XSSF.addMergedRegion method is giving Excel error Excel found unreadable content in xyz.xlsm, Do you want to recover the contents of the workbook? If you trust the source of this workbook, click yes." When I click Yes, I get another popu up "Excel

Excel error "Excel found unreadable content" with POI 3.7 and excel 2007

Using POI 3.7 FINAL Office 2007. I am using "SS" usermodel to create XSSF sheet and trying to open the file .xlsm in Excel 2007 , getting the error "Excel found unreadable content in xyz.xlsm, Do you want to recover the contents of the workbook? If you trust the source of this workbook, click ye

Re: POI Excel 2007 Cell Comment creation doesn't work

Can somebody help me on my question. My post is still in pending list. please help. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-Excel-2007-Cell-Comment-creation-doesn-t-work-tp2295530p3381376.html Sent from the POI - User mailing list archive at Nabble.com.

Re: POI Excel 2007 Cell Comment creation doesn't work

I am facing similar problem, I am using XSSF to create the 2007 spreadsheet and writing the content in it. when I open the file in .xlsm format from application I got error "Excel found unreadable content, do you want to recover the contents of this workbook?" so on... can somebody help me, wha

Re: POI 3,7 sheet.shiftRows() corrupted the cells

Is there any workaround to insert rows in sheet instead of shiftRows(), if this method is available in ss usermodel, I am wondering why it is not working properly, it could be a bug. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-7-sheet-shiftRows-corrupted-the-c

Re: POI 3,7 sheet.shiftRows() corrupted the cells

Nick Burch-11 wrote: > > On Tue, 8 Feb 2011, hartford123 wrote: > > Could you create a junit test that uses the SS usermodel, which tries the > shift + read trick on both HSSF and XSSF? From what you say, it should > work with hssf, and fail for xssf. That unit test can th

Re: POI 3,7 sheet.shiftRows() corrupted the cells

This is the xml showing errors - http://schemas.openxmlformats.org/spreadsheetml/2006/main";> error033440_77.xml Errors were detected in file 'D:\Documents and Settings\xdbd138\Local Settings\Temporary Internet Files\Content.IE5\VDHUZB60\TDPTemplate[4].xlsm' - Removed Records: Merge c

Re: POI 3,7 sheet.shiftRows() corrupted the cells

Nick, you are right we were using HSSF and we upgraded to poi 3.7 and changed the code to SS user model so that it takes both XSSF and HSSF. Here is the code I am using.Suppose when shiftRows() is done for 2 rows to shift down,ie from 47 to 49, then current row is showing 49 and if I want

poi 3.7, excel 2007, macro enabled workbook giving problem

We upgraded from poi 2.5 to 3.7 version and upgraded MSoffice 2003 version to 2007 version. I tweaked the code to change the usermodel to ss usermodel so that both .xls and .xlsm(macro enabled 2007 workbook) files can be opened by my application. when I run the application to open .xlsm file f

Re: macros not enabled with POI 3.7 version

OK. I figured out myself by google search. I forced the macros to function by using FormulaEvaluator as follows FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator(); for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) { Sheet

macros not enabled with POI 3.7 version

I have excel template with macros created with in it. My application uses 2.5 version of POI and access this template and evaluates the macros , but the problem is comign with POI version 3.7 ,recently we upgraded to 3.7 , now accessing the same templates(.xls files) is not evaluating the macros

Re: Need help with org.apache.poi.POIXMLException

I am subscribed user.. why this post is still pending and needs to be approved. Approvers, Can you approve it please. thanks, Sujatha. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Need-help-with-org-apache-poi-POIXMLException-tp3352158p3354709.html Sent from the

Need help with org.apache.poi.POIXMLException

In my application, we are upgrading from poi 2.5 version to poi3.7 to support excel 2007 files. for now I converted HSSF usermodel to XSSF model, but trying to read .xls file, got the following exception, is it because I am not reading .xlsx file? Does XSSF support only excel 2007 files(.xlsx)

Re: please help with java.lang.VerifyError

thank you Nick! you are right, it is pointing to old jar version2.5 and I removed that from classpath and the problem is resolved. thanks again, Sujatha. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/please-help-with-java-lang-VerifyError-tp3351905p3352072.html Sent f