CSV file loading issue - Githubissues

unvell / ReoGrid

Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.

https://reogrid.net

MIT License

1.32k stars 390 forks source link

CSV file loading issue #519

Closed lancelot0817 closed 5 months ago

lancelot0817 commented 6 months ago

Description & To Reproduce

grid.Load("C:\\mypath\\data.csv", IO.FileFormat.CSV);

By default, ReoGrid will expand the size of worksheet in order to load and fill all data from a CSV. But it seems that after loading the CSV file, only 100 columns can be displayed.

Screenshots

Edition

Windows Form

Environment

OS: Windows 10
Language of OS: Tradionnal Chinese

lancelot0817 commented 5 months ago

My solution is to manually modify the file CSVFormat.cs, where this line of code exists:

if (!autoSpread && toBuffer.Count >= targetRange.Cols) break;