#38 Slow loading many columns few lines

[sundoctor]

Lazarus 1.8.4 FPC 3.0.4 x64 Windows7 64

If the simple source .ods or .xls file (without any formatting) contains many columns, (for example A..AZ) and a few rows (1..5) - the loading (WSS.LoadFromSpreadsheetFile()) eats up 100% CPU and very slow. The oposite case (a few columns and many rows) works very fast without heavy load. Please check.

[wp]

I cannot confirm, in my tests a file with columns A..AZ and rows 1..5 is loaded within less than 1 ms. Please be more specific. Post a demo program showing the issue. I don't know if you can post files here. If not re-post in the Lazarus forum (which I would prefer anyway because I am not checking the ccr tickets very often).