Free Support Forum - aspose.com

range.applyStyle failing for large number of data


#1

We are using Aspose.Cells to format a report. We are using
range.applyStyle to apply custom style.

The report has 102 columns and 10000 plus records.

Our observation is for a report with
11167 rows the style is getting applied correctly.

But same report with 11255 rows the style stops applying correctly from column 45. All previous columns have correct styling.

The styling for date field is coming incorrectly. The required format is dd-mmm-yyyy but when the styling breaks the format changes to 1900-01-01 00:00:00.0

Can you please let us know why styling is breaking for large dataset.


#2

@deepthis,

Thanks for details.

This should not be a problem for Aspose.Cells APIs if using smaller dataset or larger range of cells. The formatting should be applied correctly to all the cells of the range in rows and columns in the worksheet. May be your underlying data in those cells are not Date/Time values or strings. For your information, to apply numbers formattings to a cell demands the underlying value/data should be in proper data type otherwise the formatting won’t be applied correctly.

Anyways, please provide us sample (Java/.NET) code (runnable) or program to reproduce the issue on our end, we will check it soon. Also provide your template file(s) (if you are using any).

PS. You may zip your files prior attaching here.