import .xls file containing ArrayFormula

[Jonathan Hartley]

Hey there.

I am importing an .xls file which contains two (identical) array formula, set on adjacent ranges of cells.

eg:
Array formula "=Row(A1:A10)", which has been expanded to display over cells B1:B5, and a second (but identical) formula, expanded over cells C1:C5 (see attached file twoArrays.xls)

When I import the .xls file using XlsIO, I can see the imported array formula by iterating over worksheet.Cells, and looking at their IRange.FormulaArray propery.

However, I don't know how to tell that there are two distinct array formula, as opposed to simply a single array formula that stretches across cells B1:C5.

I need to know because (like Excel) I need to prevent the user from trying to change or delete part of an array. Hence deleting B1:B3 is forbidden, but deleting B1:B5 should be allowed.

Anyone know how I can figure this out?

Thanks for any ideas or assistance,

Jonathan

twoArrays.zip

[Sarathi D]

Hi Jonathan,

We are currently looking into this issue. I will update you the status of the issue within two business days.

Sorry for the inconvenience caused.

Regards,
Sarathi

[Jonathan Hartley]

Thanks Sarathi, we appreciate any help you can give us.

[Jonathan Hartley]

Hi there Sarathi,
Just checking to see if there is any progress. Thanks for your time on this.

Jonathan

[Jonathan Hartley]

I've escalated this to a DirectTrac incident, 37493

[Rajarajeswari S]

Hi,

Thanks for using Syncfusion products.

Your direct trac incident ID 37493 has been updated. Please follow up twith that incident.

Regards,
Raji

[Rajarajeswari S]

Hi Jonathan,

Thanks for using Syncfusion products.

Currently we do not have any direct method to get the size of the array. This has been confirmed as a Feature Request. We will implement this feature in our forthcoming new version releases or service pack releases. We usually have a timeframe of at least three months between releases. The feature implementation would also greatly depend on the factors like product design, code compatibility and complexity. We will get back to you once the feature is implemented.

Please let me know if you have any other questions.

Thanks,
Raji