Excel Export

[Roeland]

When copying to Excel there is an upper limit of 65k records (at least in my version).

Could you make extra worksheets when there are more records then Excel can handle?

I see 2 solutions:
- start a new sheet after 65000 records (set it in the preferences) so I have some room to handle the records.

- Even better is when you could start a new sheet when one of the columns of an "order by"-clause change value.

Thank you,

Roeland

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Roeland]

How about this feature? I know that Excel 2007 could handle up to 1 million records, but i and my clients don't have this version yet.

Suggestion:
- make a preference for the Maximum value.

 

[Marco Kalter]

It's still on the to-do list. A preference could be a useful option, and would still allow you to make use of any improvement in Excel 2007.

 

[Dave Sharpe]

Marco - Any progress on the question of exporting more that 65K rows?

I was hoping to use larger export size as a reason for getting office upgrade authorized.

Thanks

Dave

 

[Marco Kalter]

It requires an enhancement of a 3rd party component that we are using, and this is scheduled for 8.0 later this year.

 

[Dave Sharpe]

Marco - I understand, thanks for the prompt reply

Dave