Free Support Forum - aspose.com

Date and number formatting

Hi Team,


we are using licensed version of aspose.cells and producing excel output using smartmarker.
when i produce output its getting the date and number formatting based on excel setting but i want to force it and format it based on the user who is using my application.
say If US user logs in it should format in MM/DD/YYYY and if UK user then DD/MM/YYYY.
Same thing applies for number formatting.
Can you please let me know how can we achieve this using smart marker.
rajsingh85007:
Hi Team,

we are using licensed version of aspose.cells and producing excel output using smartmarker.
when i produce output its getting the date and number formatting based on excel setting but i want to force it and format it based on the user who is using my application.
say If US user logs in it should format in MM/DD/YYYY and if UK user then DD/MM/YYYY.
Same thing applies for number formatting.
Can you please let me know how can we achieve this using smart marker.
Hi,

Thanks for your posting and using Aspose.Cells.

Please download and use the latest version:Aspose.Cells for .NET (Latest Version).

We have recently introduced copystyle attribute, which you can use to copy the style of existing cells in the new cells using SmartMarkers.