Aspose.Cells Smart Markers

Aspose.Cells Product Family
1

Hello,


We are using Excel Template with Formula to populate Excel Data.

Question : Is there a way to have Formula (on each row) without using the Smart Markers (for formula) ?

This is very frustrating since if we need to insert some columns (on our termplate), those formula will not be updated by Excel like standard formula.

We were using using SorftArtisans ExcelWriter component before that let you easily do that (and we migrate to Aposce.Cells), but by converting all our formula to Smart Markers, this is a big drawback for us (since we have a lot of formula).

Thank you

Martin
2

Hi Martin,

Thanks for your posting and using Aspose.Cells.

Please share your sample code and also your sample expected output excel file. You can create expected output excel file manually using Microsoft Excel. Please provide the simplest excel file which serves the purpose so that we could focus on the main issue. We will then look into it and provide you a sample code to achieve your expected excel file which you can then later incorporate into your main code. Thanks for your cooperation.