Need "force text type" for XLS conversion

Posted on November 3, 2006 at 8:17am
Hi!

We generate the report contaning the table of values like '05.30'.

The output report have to be examined and updated by the user.
So we convert it to excel. For each cell excel highlites warning "!" like: "cell contains date value with no century assigned".
Then the user changes that value by means of pressing <ENTER> on cell, excel converts it to 'may 30'.

Is it possible to force the text type for the cell?

We have tried to use IS_DETECT_CELL_TYPE option but it does not help at all.
JasperReports® Library
sp_const's picture
sp_const
4
Joined: Oct 31 2006 - 9:59pm
Last seen: 16 years 10 months ago

1 Answer:

Posted on November 15, 2006 at 10:25am
Hi,

Why do you say it does not help at all?
Do you have an error, or things do not seem to change in any way?
Which XLS exporter are you using? The POI-based one or the JExcelApi one?

Thank you,
Teodor
teodord's picture
teodord
53184
Joined: Jun 30 2006 - 9:00am
Last seen: 3 hours 12 min ago
Feedback