Syncfusion.XlsIO.Base: Wrong BiffRecord

[Hixem]

I can´t read this:
Dim A As String = Hoja.Range(2, 1).Value.ToString

where hoja.range(2,1) = "=CN({430})"
(Is a personal formula made in VBA)


error :Syncfusion.XlsIO.Base: Wrong BiffRecord data format. FormulaRecord

error87.zip

[Melba Winshia]

Hi Haf,

Thank you for posting your query to us.

I am afraid that I was not able to reproduce the issue. Please refer to the following steps that I tried to reproduce it.

1. Created a template with formula "=CN({430})" in the cell 2,1
2. Read the cell 2,1
3. No exception was raised

Also I have created a simple sample to test this issue and it is available in the following link.

http://websamples.syncfusion.com/samples/XlsIO.Windows/F63555/main.htm

Please have a look at the above sample and if still the issue exists, could you please try reproducing it in the above sample or send us the reproducing steps so that we could sort out the cause of the issue and provide you a solution?

Regards,
Melba