0

Microsoft Excel can't insert new cells because it would push non-empty cells off the end of the worksheet.

After updating to latest version of jet reports, starting to get this error in several spreadsheets when pressing run.

The tab in question does not have that many columns - up to  AT and rows up to: 147

Log does not show a lot:

just the same entries over and over after the first section:

 

2019-09-17 11.48.49.403 Thread1 Error logging initiated.
2019-09-17 11.48.49.403 Thread1 Jet Build: 20.3.19246.1
2019-09-17 11.48.49.403 Thread1 Bitness: 32-bit
2019-09-17 11.48.49.403 Thread1 OS Version: Microsoft Windows NT 6.2.9200.0
2019-09-17 11.48.49.427 Thread1 OS Culture: English (United Kingdom)
2019-09-17 11.48.49.427 Thread1 OS UI Culture: English (United Kingdom)
2019-09-17 11.48.49.438 Thread1 Program.Main:
2019-09-17 11.48.50.039 Thread1 Program.RunService: WaitHandle signaled
2019-09-17 11.48.50.377 Thread5 JetFrontFactory.CreateJetFront:
2019-09-17 11.48.50.381 Thread5 JetFrontFactory.CreateJetFront: C/Front directory: C:\Program Files (x86)\JetReports\JetFront\32012
2019-09-17 11.48.50.620 Thread6 NavCFrontDataSource.Open: Database Version: 6.0.32012.0
2019-09-17 11.49.25.248 Thread4 NavDataSource.OpenCompany: xxxxxxxxx
2019-09-17 11.49.26.216 Thread9 JetDataSource.ExecuteQueries: 8204
2019-09-17 11.49.26.218 Thread9 JetDataSource.ExecuteQuery:
2019-09-17 11.49.26.466 Thread9 NavCFrontDataSource.QuerySum:
2019-09-17 11.49.26.504 Thread9 NavDataSource.LogKeyFields: Key = , G/L Account No., Posting Date, Entry No.
2019-09-17 11.49.26.619 Thread9 NavCFrontDataSource.QuerySum: Complete
2019-09-17 11.49.26.623 Thread9 JetDataSource.ExecuteQuery:
2019-09-17 11.49.26.623 Thread9 NavCFrontDataSource.QuerySum:
2019-09-17 11.49.26.625 Thread9 NavDataSource.LogKeyFields: Key = , G/L Account No., Posting Date, Entry No.
2019-09-17 11.49.26.627 Thread9 NavCFrontDataSource.QuerySum: Complete
2019-09-17 11.49.26.628 Thread9 JetDataSource.ExecuteQuery:
2019-09-17 11.49.26.628 Thread9 NavCFrontDataSource.QuerySum:
2019-09-17 11.49.26.629 Thread9 NavDataSource.LogKeyFields: Key = , G/L Account No., Posting Date, Entry No.
2019-09-17 11.49.26.630 Thread9 NavCFrontDataSource.QuerySum: Complete

 

Then just stops.. I have check the max range of the used spreadsheet cells (ctrl end)  and its not that..

Using latest Excel version from Office 365.

Anyone got any ideas?

 

0 comments

Please sign in to leave a comment.