FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files

[Shun Wang]

Hi,

 thanks for your work!

I cannot open the big .xlsx files with multiple columns(more than 725 I guess).to reproduce:

1. creat a .xlsx file with 725 columns;
2. build the freexl 2.0.0
3. try open that file.

It may because the `find_col_no function` can olny find max col as "ZZ" with two alphabet? I can reproduce it also on Linux and Windows. I also made an issue report at: FreeXL

cheers.

Shun Wang

[Shun Wang]

Hi all,  Can anyone help with the above issue? with thanks.

[a.fu...@lqt.it]

On Wed, 12 Mar 2025 22:58:59 -0700 (PDT), Shun Wang wrote:
> Hi all,  Can anyone help with the above issue? with thanks.
>

> 在2024年8月23日星期五 UTC+8 12:21:14 写道：
>
>> Hi,
>>  thanks for your work!
>>
>> I cannot open the big .xlsx files with multiple columns(more than
>> 725 I guess).to reproduce:
>>

>> * creat a .xlsx file with 725 columns;
>> * build the freexl 2.0.0
>> * try open that file.

>>
>> It may because the `find_col_no function` can olny find max col as
>> "ZZ" with two alphabet? I can reproduce it also on Linux and

>> Windows. I also made an issue report at: FreeXL [1]
>>
>> cheers.
>> Shun Wang
>

Hi Shun,

it's very likely that things are as you say.
Excel spreadsheets with so many columns are
not at all common, they are a real black
sheep.
Personally, in my long career spanning over
more than thirty years, I have never met one
or heard one mentioned by a colleague.

Of course, this doesn't mean that they can't
exist and that someone somewhere uses them,
but it certainly indicates that they are
extremely rare.

If you'll be kind enough to send me some sample
(even to my private mailbox) I'll be happy
to investigate on the problem.

bye Sandro

[Shun Wang]

Hi Sandro,

Sure, here is the .xlsx file with multiple columns more than 700+. see: https://drive.google.com/file/d/18j0o5026HOi9WV12auuoof1ICbB4MR8l/view?usp=sharing

Thanks for your work.

Shun.

[Shun Wang]

Hi Sandro,

And also this file was not opened, could you please have a look? see: https://drive.google.com/file/d/1e6t1LEK3-WyUSY9IAPVTDIA5sHa-OPJf/view?usp=drive_link

With Thanks!

Shun.