Problem with zss Spreadsheet

asked 2008-09-30 15:43:33 +0800

c3c
3

I'm trying to use zss Spreadsheet to show a sheet generated with jasper reports xls exporter.
But i got this exception:

Caused by: org.zkoss.zss.model.ModelException: Incorrect format at 2, charcter M in "d/MM/yy H:mm"
at org.zkoss.zss.model.impl.NumberFormatImpl.dispatchState(NumberFormatImpl.java:828)
at org.zkoss.zss.model.impl.NumberFormatImpl.parseChar(NumberFormatImpl.java:924)
at org.zkoss.zss.model.impl.NumberFormatImpl.parse(NumberFormatImpl.java:1353)
at org.zkoss.zss.model.impl.NumberFormatImpl.parseFormat(NumberFormatImpl.java:325)
at org.zkoss.zss.model.impl.NumberFormatImpl.<init>(NumberFormatImpl.java:80)
at org.zkoss.zss.model.impl.FormatImpl.newNumberFormat(FormatImpl.java:363)
at org.zkoss.zss.model.impl.FormatImpl.setFormatCodes(FormatImpl.java:112)
at org.zkoss.zss.model.impl.ExcelImporter.importCellStyle(ExcelImporter.java:391)
at org.zkoss.zss.model.impl.ExcelImporter.importEachCell(ExcelImporter.java:231)
at org.zkoss.zss.model.impl.ExcelImporter.importEachRow(ExcelImporter.java:209)
at org.zkoss.zss.model.impl.ExcelImporter.importEachSheet(ExcelImporter.java:199)
at org.zkoss.zss.model.impl.ExcelImporter.importFromStream(ExcelImporter.java:124)
at org.zkoss.zss.model.impl.ExcelImporter.importFromURL(ExcelImporter.java:177)
at org.zkoss.zss.model.impl.ExcelImporter.imports(ExcelImporter.java:80)
at org.zkoss.zss.ui.Spreadsheet.getBook(Spreadsheet.java:271)
at org.zkoss.zss.ui.Spreadsheet.getSelectedSheet(Spreadsheet.java:319)
at org.zkoss.zss.ui.Spreadsheet.getOuterAttrs(Spreadsheet.java:962)

Seems that NumberFormatImpl doesn't soupport the format used in the cells with dates generated with jasper reports.

I think it's a bug, but I prefer to ask first, before reporting it. There's any possible workaround?

delete flag offensive retag edit

9 Replies

Sort by » oldest newest

answered 2008-10-01 12:51:49 +0800

ivanceras
18

Hi,

Is zk spreadsheet project still on going?
I see in sourceforge that there is no/little activity in it.

Please let me know.

Regards,
ivanceras

link publish delete flag offensive edit

answered 2008-10-02 00:48:24 +0800

dennis
3679 ● 1 ● 6
http://www.javaworld.com....

Please post it a bug to zss bug tracker, and provide the jasper report jrxml and exception stack trace. thanks

link publish delete flag offensive edit

answered 2008-10-03 00:30:42 +0800

henrichen
3869 ● 2
ZK Team

ivanceras,

Yes. The project is still on going. We would like to hear feedbacks about this components, too. How will you use this component? What feature you feel most important. Please feedback.

link publish delete flag offensive edit

answered 2008-10-04 11:21:50 +0800

ivanceras
18

Im glad. It is still active.

I've seen the demo, I see it very useful for viewing spreadsheet reports. The only drawback, is I can't see the chart on .xls file. I can't also find the sourcecode of zk spreadsheet, for me to peep at the code, somehow, finding for a way to separate the extraction of chart data from database instead of from the spreadsheet. The chart data will be handled by generating the image before attaching it the spreadsheet, or perhaps viewable using flash charts mounted as part of the component...

thanks,
ivanceras