[GH-ISSUE #111] Wrong Styles in large Sheet file #91

New issue

Closed

opened 2026-05-05 11:38:50 -06:00 by gitea-mirror · 3 comments

gitea-mirror commented

2026-05-05 11:38:50 -06:00

Owner

Originally created by @mileder on GitHub (Jul 19, 2017).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/111

Originally assigned to: @jmcnamara on GitHub.

after creating the large excel sheet (approx. 25.000 lines) the styles are not assigned / available.

In the XML file of sheet styles have negative id's: probably overflow somewhere

Originally created by @mileder on GitHub (Jul 19, 2017). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/111 Originally assigned to: @jmcnamara on GitHub. after creating the large excel sheet (approx. 25.000 lines) the styles are not assigned / available. In the XML file of sheet styles have negative id's: probably overflow somewhere

gitea-mirror

2026-05-05 11:38:50 -06:00

closed this issue
added the
question
label

gitea-mirror commented

2026-05-05 11:38:55 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jul 19, 2017):

Hi,

As you say it is probably an overflow issue. However the type should be int32_t so it should take several billion unique formats to overflow.

Do you actually have so many unique formats that the default size would overflow?

The best thing would be to post a small working example that demonstrates the issue.

John.

@jmcnamara commented on GitHub (Jul 19, 2017): Hi, As you say it is probably an overflow issue. However the type should be int32_t so it should take several billion unique formats to overflow. Do you actually have so many unique formats that the default size would overflow? The best thing would be to post a small working example that demonstrates the issue. John.

gitea-mirror commented

2026-05-05 11:38:58 -06:00

Author

Owner

@mileder commented on GitHub (Jul 20, 2017):

i send you an email with example file

@mileder commented on GitHub (Jul 20, 2017): i send you an email with example file

gitea-mirror commented

2026-05-05 11:38:59 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jul 24, 2017):

In general an output file doesn't tell me much. A sample program that creates the file is usually required to figure out what is wrong.

At a guess I would say that you are using a lxw_format that isn't initialized correctly. All lxw_format instances should be created as follows:

lxw_format *format = workbook_add_format(workbook);

Memcpying the format and modifying it also doesn't work. Check you code for things like that.

Otherwise, reduce your program down to a small program that can reproduce this issue

@jmcnamara commented on GitHub (Jul 24, 2017): In general an output file doesn't tell me much. A sample program that creates the file is usually required to figure out what is wrong. At a guess I would say that you are using a `lxw_format` that isn't initialized correctly. All `lxw_format` instances should be created as follows: ```C lxw_format *format = workbook_add_format(workbook); ``` Memcpying the format and modifying it also doesn't work. Check you code for things like that. Otherwise, reduce your program down to a small program that can reproduce this issue