Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed May 13, 2015 7:48 am

I'm currently evaluating the full Spire.XLS version and trying to open the attached XLSX file, I get this error:


System.ArgumentOutOfRangeException was unhandled
HResult=-2146233086
Message=The number must be between 10 and 400.
Parameter name: ZoomScalePageBreakView
Source=Spire.XLS
ParamName=ZoomScalePageBreakView
StackTrace:
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.set_ZoomScalePageBreakView(Int32 value)
at spr4279.3(XmlReader A_0, XlsWorksheetBase A_1)
at spr4279.4(XmlReader A_0, XlsWorksheetBase A_1)
at spr4279.0(XmlReader A_0, XlsWorksheet A_1, Stream A_2, List`1 A_3)
at spr4279.0(XmlReader A_0, XlsWorksheet A_1, String A_2, MemoryStream& A_3, MemoryStream& A_4, List`1 A_5, Dictionary`2 A_6, Dictionary`2 A_7)
at spr524.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at spr4279.0(Dictionary`2 A_0)
at spr268.0(List`1& A_0)
at spr268.1(List`1& A_0)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(String A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(spr2455 A_0, Object A_1, String A_2, ExcelParseOptions A_3, Boolean A_4, String A_5, ExcelVersion A_6)
at spr859.0(Object A_0, String A_1, ExcelParseOptions A_2, Boolean A_3, String A_4, ExcelVersion A_5)
at spr1006.0(String A_0, ExcelParseOptions A_1, Boolean A_2, String A_3, ExcelVersion A_4)
at Spire.Xls.Workbook.LoadFromFile(String fileName, ExcelVersion version)
at Spire.Xls.Workbook.LoadFromFile(String fileName)
at TaedExcelComponentsTestConsole.Program.SpireXlsTest(String sourceXlsFilePath, String sourceXlsxFilePath, String targetXlsFilePath, String targetXlsxFilePath) in c:\_data\Master\CONSTABLE2\Apps\VW\ZK\2015\Research\TaedExcelComponentsTest\Source\Program.cs:line 38
at TaedExcelComponentsTestConsole.Program.Main(String[] args) in c:\_data\Master\CONSTABLE2\Apps\VW\ZK\2015\Research\TaedExcelComponentsTest\Source\Program.cs:line 25
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
Attachments
TaedExcelComponentTestFile_Source_Spire.zip
(19.99 KiB) Downloaded 251 times

palomraz
 
Posts: 1
Joined: Wed May 13, 2015 7:35 am

Wed May 13, 2015 8:27 am

Hello,

Thanks for your inquiry.
I have reproduced your issue. And I have posted the issue to our dev team. We will inform you when it is fixed. sorry for the inconvenience.

Best Regards,
Sweety
E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Wed Jul 15, 2015 8:00 am

Hello,

Sorry to keep you waiting.
The new version of Spire.XLS( Spire.XLS Pack Version:7.8 ) solved your issue "Error "The number must be between 10 and 400" opening XLSX" has been released. Please download it via link below and have a try:
http://www.e-iceblue.com/Download/download-excel-for-net-now.html

Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Thu Jul 16, 2015 7:54 am

Hello,

Have you tried the Spire.XLS( Spire.XLS Pack Version:7.8 )?
Has your issue been resolved?
Thanks for your feedback.

Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS