Read Cell values as it is

Aspose.Cells Product Family
1

Hi Team,

We came across a situation where some factset formulas are being used in a workbook. It works when excel is opened in MS Office. But when the workbook is read through Aspose, it tries to calculate and throws an error in the cell value as it doesn’t understand those FDS functions.

Is there a way to read the cell value as it is without performing any calculation ??

Kindly let us know asap as it a showstopper.

Thanks,
Pradeep.A.B

2

@Pradab,

Thanks for your query.

Well, you may try to use load data filtering options (e.g All except Formula) while loading your template file. See the sample code segment for your reference:
e.g
Sample code:

 var filePath = @"e:\test2\Book1.xls";
            var loadFilter = new LoadFilter(LoadDataFilterOptions.All & ~LoadDataFilterOptions.Formula);
            var asposeOptions = new Aspose.Cells.LoadOptions
            {
                MemorySetting = MemorySetting.MemoryPreference,
                LoadFilter =  loadFilter
            };
            var workbook = new Workbook(filePath, asposeOptions);

Anyways could you attach your template file and paste your code (runnable) that you were using, we will check and help you through.