We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Porductive Bug in Aspose.Cells using DataViews

Sven Schmid> Hi !
amjad sahi> hello
Sven
Schmid>
we are using Aspose.Cells from nearly beginning when it was
called Aspose.Excel

Sven Schmid> this
year we make migration of all our projects to new .net (VS 2008)

Sven Schmid> and we used in Aspose.Excel a function to
bind a DataView to an SmartMarker

Sven
Schmid>
e.g. aDesigner.SetDataSource(“TestcaseSum”,
aView1);

Sven Schmid> I tested now all
Aspose.Cells Dlls beginning from Version Number 4.4.0 to now
4.8.1

Sven Schmid> and all have the
same bug

Sven Schmid> this
SetDataSource will bind COMPLETE datatable to excel

Sven Schmid> not only the view data
amjad sahi> let me check
Sven Schmid> ok
amjad
sahi>
please wait a bit

amjad
sahi>
thanks

Sven Schmid> I can
send you a complete test program with the testcase if you want

amjad sahi> please wait a while
amjad sahi> we need to check certain
aspects

amjad sahi> sorry for making you
wait a bit

amjad sahi> yes we found the
issue

amjad sahi> we will figure it out
soon.

amjad sahi> you can help us a bit
if you could post a query in Aspose.Cells forum to mention your issue
there

amjad sahi> so that all the
developers could see it and also to centralize the issue

Sven Schmid> can I put there also the test case program
?

amjad sahi> if you ask me i can post
the issue on your behalf too.

Sven
Schmid>
this will be good

amjad
sahi>
well no need really

amjad
sahi>
i have reproduced the issue

Sven
Schmid>
ok

Sven Schmid> can you
send me an information mail to me when the
hotfix is available ?

amjad sahi> ok i
will post your issue to Aspose.Cells forum

Sven Schmid> Super !
amjad sahi> an automatic mail would sent to you when the
issue is posted to the forum

Sven
Schmid>
One additional question I have

amjad sahi> no problem
amjad sahi> have a good day
Sven Schmid> we use very often this smart
marker

Sven Schmid> and we have now in
productiion enviroment very large records

amjad
sahi>
no problem we will figure it out soon.

Sven Schmid> so large that sometimes we have memory
problem with using dataset or dataview or any object with smart
marker

Sven Schmid> is there any
possibility to use smart marker e.g. with a datareader

Sven Schmid> or any function which consumes not so much
memory ?

Sven Schmid> currently we use
this in web application an when 2 users produces a big report then the memory
grows up to 1.5 GB and the app server says goodbye

amjad sahi> well we have look certain aspects if we can
support DataReader object for smart marker’s data source

amjad sahi> but we will look and let you know about it
soon.

Sven Schmid> this will be
great

Sven Schmid> thx and have a good
day

amjad sahi> bye

This message was posted using Email2Forum by Amjad Sahi.

Hi,

As per our conversation on live chat, we have found the issue. Your issue has been logged into out issue tracking system with an issue id: CELLSNET-12048. We will figure it out and let you know about it soon.

Thank you.

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed your issue.

Thank You & Best Regards,

Hi,

And, we have added your feature requrest “Using DataReader object in Smart Markers” into our internal issue tracking system with an issue id: CELLSNET-12060. We will notify you when it is supported.

Thank you.

Hi,


p
{
margin: 0pt;
font-family: Arial,Verdana,Tahoma;
font-size: 12px;
}
.footer { color:Gray; font-size: 11px; text-align: center; }
.back1 { background-color: whitesmoke; }
.back2 { background-color: #f1f5e1; }
.back3 { background-color: cornsilk; }

Please try the attached version. We have supported IDataReader as the data source of smart marker. Please use the method WorkbookDesigner.SetDataSource(string name,IDataReader dataReader, int rowCount). If your smart marker does not contain "noadd", we have to insert rows according to the parameter "rowCount". And, we do not support "Group" option if the data source is DataReader.


Thank you.

The issues you have found earlier (filed as 12048) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.