Hello Rael,
From your post, my understanding on this issue is: you want to know why the
VSTO application returns incorrect array of cells when the range is a union
of nonadjacent cells. If I'm off base, please feel free to let me know.
According to the KB
http://support.microsoft.com/kb/q108518/, Microsoft
Excel returns the range of the Union's first Area by default when the
'sectionRange' is constituted by several nonadjacent ranges. Therefore, in
your sample code:
System.Array values=(System.Array)sectionRange.Cells.Value2;
The bounds of the array is 1¡1501 and 1¡15, and it counts to be 1500 * 14
= 21000, which equals the cell count of your first range.
To get the correct array of values, we could iterate the Areas in the Range
object:
for (int i = 1; i <= sectionRange.Areas.Count; i++)
{
Excel.Range range = sectionRange.Areas
as Excel.Range;
array = (System.Array)range.Cells.Value2;
}
Please let me know if you have any other concerns, or need anything else.
Sincerely,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support
==================================================
For MSDN subscribers whose posts are left unanswered, please check this
document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications. If you are using Outlook Express/Windows Mail, please make sure
you clear the check box "Tools/Options/Read: Get 300 headers at a time" to
see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
