Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 28 Mar 2024, 13:44

All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: 23 Jan 2021, 02:30 
Offline

Joined: 23 Jan 2021, 01:58
Posts: 6
DBGridEh Export To XLSX file question
I use Ehlib 9.5.012 trial.
After I use memtableeh to group dbgrideh, I need to export xlsx files with this format, but now I don't. is there any solution?


Top
 Profile  
 
PostPosted: 24 Jan 2021, 11:18 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

Version 9.5 does not support grouping of records when exporting to Xlsx.
Export of grouping rows was added in version EhLib 10.0.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 25 Jan 2021, 06:56 
Offline

Joined: 23 Jan 2021, 01:58
Posts: 6
EhLibSupport wrote:
Hello

Version 9.5 does not support grouping of records when exporting to Xlsx.
Export of grouping rows was added in version EhLib 10.0.


Hello,I've used the trial version of Ehlib 10.0. Now I have another problem. I have 60000 records, DataGrouping.Active : = true, the Form will close very slowly. It seems that you have released something


Top
 Profile  
 
PostPosted: 26 Jan 2021, 14:25 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

----
Check the opening and closing of the Form when starting the program in 'Run Without Debugging' mode.
The debugger can greatly slow down memory allocation and deallocation operations.

----
If that doesn't help, then in order to test the problem, we need to reproduce the problem on our side.
Try to create a demo project with a lot of data.
As a data for test, you can use a large table Cities1000 (123190 rows) from
<EhLib Archive>\Demos\Data\cities10000.mdb file

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 28 Jan 2021, 06:52 
Offline

Joined: 23 Jan 2021, 01:58
Posts: 6
I use the maindemo project in demo, the form working with huge data,

DataGrouping.Active : = true; the project compilation mode is release. When closing the form, it is still very slow. You can check it


Top
 Profile  
 
PostPosted: 28 Jan 2021, 16:17 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

I tested MainDemo, Section - 'Working With Huge Data', Button - 'Open Big Table'.
Сompilation mode - release or debug, have almost no effect on the speed of opening a table or forming a grouping.
After the formation of group records, closing the application takes a few seconds (up to ten seconds).

But starting the program in the mode - 'Run Without Debugging' mode speeds up the work of the program: opening data, forming groups, more than 20 times.
I did not see in your post if you tested the application in this mode.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC


Who is online

Users browsing this forum: Bing [Bot] and 55 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group