We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

import .xls file containing ArrayFormula

Thread ID:





68027 Sep 6,2007 05:45 PM UTC Dec 26,2007 09:16 AM UTC WinForms 6
Tags: XlsIO
Jonathan Hartley
Asked On September 6, 2007 05:45 PM UTC

Hey there.

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

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,



Sarathi D [Syncfusion]
Replied On September 8, 2007 01:56 AM UTC

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.


Jonathan Hartley
Replied On September 10, 2007 06:51 PM UTC

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

Jonathan Hartley
Replied On September 13, 2007 03:46 PM UTC

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


Jonathan Hartley
Replied On September 19, 2007 02:27 PM UTC

I've escalated this to a DirectTrac incident, 37493

Rajarajeswari S [Syncfusion]
Replied On December 26, 2007 04:23 AM UTC


Thanks for using Syncfusion products.

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


Rajarajeswari S [Syncfusion]
Replied On December 26, 2007 09:16 AM UTC

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.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon