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.33k stars 396 forks source link

Named Range is not displayed in the address bar after 100 columns (column CV) #500

Open Ashwini-cl opened 1 year ago

Ashwini-cl commented 1 year ago

Hi Team,

The xlsx file has more than 100 columns, and all the columns have a unique named range defined. But when the same xlsx file is loaded in the  Reogrid,it only loads the first 100 named ranges on the address bar on clicking each column; the rest of the named range addresses are updated as CV1, which is the 100th column in the RO grid editor.

Attached is a screenshot of the named range having only 100 columns defined in the Reo Grid demo application of the 2.1 version. image

Please kindly assist me on the above issue. Let me know if you need any further details on the same.

To Reproduce

  1. Create the xlsx file with more than 100 columns.
  2. Define a named range for each column.
  3. Load the xlxs file in the REO Grid Editor.
  4. Check the address bar when selecting the each column to verify the named range value.

Screenshots

attched

Edition

Which edition of ReoGrid do you using?

Environment