sp_const Posted November 3, 2006 Share Posted November 3, 2006 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. Link to comment Share on other sites More sharing options...
teodord Posted November 15, 2006 Share Posted November 15, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now