Hi,
I'm reading an excel file and I get the following exception:One of the percentages in the specified location is outside the valid range of 0 to 100.Parameter name: valueActual value was {X=152.5391, Y=41.01563}.
I don't have any percentage row in the Excel.
Thank you in advance for your help
The percentages are not percentage values in cells, they are percentages that help position shapes on a worksheet. This is an error message from the set accessor of a WorksheetShape's TopLeftCornerPosition or BottomRightCornerPosition properties. However, its possible the assumption made about the valid range of values for these settings written out by Excel was incorrect. I would recommend submitting the issue to the support group along with the workbook file which caused the problem: http://ko.infragistics.com/gethelp.
Thank you so much.
Does these forums supported by Infragistics or not? If i need any any assistance/help with un aswered whon we should contact?
Regards
Pani
Do you have any suggestions for the above query?
Thanks and Regards
Pani.
We are facing the same issue. As a workaround we are following below steps.
1) Create a new blank worksheet
2) Open the worksheet you want to upload
3) Copy the contents of the worksheet to your new worksheet
However we would like to understand more on
1) Root cause for this issue
2) How we can avoid/fix this issue (without creating new sheet)
Any help is highly appriciated. Thanks in advance.
Regards,
thank you
I created a new excel file copy the data and it worked.