Improvements and Enhancements in SpreadSheet

March 26, 2014
Newbie 12 posts
Followers: 0 people
5

Improvements and Enhancements in SpreadSheet

Newbie 12 posts
Followers: 0 people
March 26, 2014

In the coming release we have made few updates in spreadsheet :

1. Overall performance has improved a lot. Read/write/update/format operations should be faster and consume less memory

2.  SpreadSheetWrite method now takes ’autosize’ parameter. If it is false, columns of output spread sheets wont be resized and users can avoid this expensive operation

3. New methods like SpreadSheetAddPagebreaks(adds page breaks in spreadsheet) and SpreadSheetAddAutofilter(Sets autofilter on the specific sheet) have been added

4. Internally POI has also been upgraded to 3.9 version

5. SpreadSheetAddRow/SpreadSheetAddRows/etc methods also take ’datatype’ attribute now where user can specify the datatype of data being added. In this case CF will not use default way of extracting the datatype of data being added (which sometimes lead to inconsistent behavior).

6. Tons of bugs have been fixed in this area

I will be writing in details about each point in next blog posts

 

Comments (5)
2014-03-27 08:57:51
2014-03-27 08:57:51

Amen, please document this is the release notes. While we’re at it, Hibernate?

Like
2014-03-27 08:32:03
2014-03-27 08:32:03

Pitty, would be nice to start of with current versions and not just POI.

Seems like SOLR is stuck on 3.4 (current version 4.7)

Zing Charts appears to be build 0.130812 (current build 0.140207)

FCKEditor version 2.6.4.1 (current version CKEditor 4.3.4)

It would be nice to have a support note which details the various 3rd party and open source libraries JS and JAR which version etc.

We have to wait a long time between releases at the moment and not having current libraries does not do any one any favours.

Things like using a 3.x version of SOLR instead of a 4.x are mind boggling.

Oh any news on Java 8 support as it is now available?

Like
2014-03-27 08:06:19
2014-03-27 08:06:19

Seriously? When, with CF12?

Like
2014-03-27 03:30:39
2014-03-27 03:30:39

Release will have 3.9 version. Upgrade to 3.10 will be done in future

Like
2014-03-26 07:50:30
2014-03-26 07:50:30

Will the final version use POI 3.10 released in February?

I hope handling of large datasets has been fixed so its useable.

Like
Add your comment