xou/elixlsx

Warning if sheet name is too long

Closed this issue · 3 comments

kuon commented

If I do

    sheet = %Elixlsx.Sheet{name: "I am a very long sheet name sorry", rows: [[1,2],[1,2]]}
    workbook = %Elixlsx.Workbook{sheets: [sheet]}
    Elixlsx.write_to_memory(workbook, "#file.xlsx")

I got a warning when opening the file in excel (the Data is OK).

I got a warning when opening the file in excel (the Data is OK).

We currently work at the bug with the warning message, see ticket #26.

Did this appear only on long sheet name? Which OS and version of excel do you use?

kuon commented

Yeah, only on long sheet name. I use excel 365 on windows 10.

xou commented

Thanks @kuon for reporting this and @Fabi755 for the fix!