Hi,
I have migrated from aspose cells 4.7 to 5.3 and 6 and I have some performance problems when I have a lot of cells to merge in the latest version.
I create a test project for AsposeCells 4.7, 5.3 and 6.0.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I attach an
zip file with a solution with these 3 libraries and 3 projects.:<o:p></o:p>
-
TestingAsposeMergeMethod
– use Aspose.Cell 6.0<o:p></o:p>
-
TestingAsposeMergeMethod53
– use Aspose.Cell 5.3<o:p></o:p>
-
TestingAsposeMergeMethodOld47
– use Aspose.Cell 4.7<o:p></o:p>
The performance result
is very clear – version 5.7 and 6.0 are at least 100 times
slower than 4.7
<?xml:namespace prefix = v ns = “urn:schemas-microsoft-com:vml” /><v:shapetype id="_x0000_t75" stroked=“f” filled=“f” path=“m@4@5l@4@11@9@11@9@5xe” o:preferrelative=“t” o:spt=“75” coordsize=“21600,21600”>
<v:stroke joinstyle=“miter”>
<v:formulas>
<v:f eqn=“if lineDrawn pixelLineWidth 0”>
<v:f eqn=“sum @0 1 0”>
<v:f eqn=“sum 0 0 @1”>
<v:f eqn=“prod @2 1 2”>
<v:f eqn=“prod @3 21600 pixelWidth”>
<v:f eqn=“prod @3 21600 pixelHeight”>
<v:f eqn=“sum @0 0 1”>
<v:f eqn=“prod @6 1 2”>
<v:f eqn=“prod @7 21600 pixelWidth”>
<v:f eqn=“sum @8 21600 0”>
<v:f eqn=“prod @7 21600 pixelHeight”>
<v:f eqn=“sum @10 21600 0”>
</v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
<v:path o:connecttype=“rect” gradientshapeok=“t” o:extrusionok=“f”>
<o:lock aspectratio=“t” v:ext=“edit”>
</o:lock></v:path></v:stroke></v:shapetype>You will find also a picture where you see my test result named result.jpg