Hi ,
We are mostly certain of migrating from interop to Aspose cells but getting issues more often.
We have an issue when setting a number format for a cell having date value.
I have attached a sample project(PARis_Excel_Requirement.zip (463.5 KB)) where i have replicated the above issue.
It will generate two excel files(“test_AsposeImplmn.xlsx” and “test_InteropImplmn.xlsx”), one uses aspose cells dll and other uses interop. Please compare and see the output is different.
The aspose generated excel output should match with the excel generated using interop(“test_InteropImplmn.xlsx”)
Please provide a solution as soon as you can.
FYI: The format setting related code is present in file ExcelOpsAspose.cs Line No: 395 , (public static void SetNumberFormat(string numberFormat, Range range)) method.
Note: I have removed aspose.cells dll because of size issue.
Regards,
Prathap