[GH-ISSUE #76] constant memory mode problem #64

New issue

Closed

opened 2026-05-05 11:35:29 -06:00 by gitea-mirror · 3 comments

gitea-mirror commented

2026-05-05 11:35:29 -06:00

Owner

Originally created by @xakepsoft on GitHub (Nov 4, 2016).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/76

Originally assigned to: @jmcnamara on GitHub.

xlsx file created using {.constant_memory = LXW_TRUE , .tmpdir = NULL}
cannot be read by akeneo-labs xlsx php reader.

File created with 'options' contains xl/sharedStrings.xml however file without 'options' doesn't have that.

Is there a way to prevent creation of xl/sharedStrings.xml ???
I would like to disable it for a while until akeneo-labs guys fix their issue with shared strings.

LibreOffice reads both files ok.

Originally created by @xakepsoft on GitHub (Nov 4, 2016). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/76 Originally assigned to: @jmcnamara on GitHub. xlsx file created using {.constant_memory = LXW_TRUE , .tmpdir = NULL} cannot be read by akeneo-labs xlsx php reader. File created with 'options' contains xl/sharedStrings.xml however file without 'options' doesn't have that. Is there a way to prevent creation of xl/sharedStrings.xml ??? I would like to disable it for a while until akeneo-labs guys fix their issue with shared strings. LibreOffice reads both files ok.

gitea-mirror

2026-05-05 11:35:29 -06:00

closed this issue
added the
question

ready to close
labels

gitea-mirror commented

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

Author

Owner

@jmcnamara commented on GitHub (Nov 4, 2016):

File created with 'options' contains xl/sharedStrings.xml however file without 'options' doesn't have that.

Just to be clear, I think that should be the other way around.

Basically it works like this:

In default libxlsxwriter new() mode the constant_memory mode is off and the library writes any strings to the xl/sharedStrings.xml file. This can be considered a "standard" xlsx file.
When constant_memory in on the libxlsxwriter library avoids a non constant memory overhead by writing the strings "inline" in the worksheet.xml files and avoid using the xl/sharedStrings.xml file. This is a documented Excel feature that is supported by most spreadsheet applications. However, some applications don't support it, such as Apple Numbers.

If spreadsheet-parser doesn't support it then you should avoid using the constant_memory option in libxlsxwriter.

I hope that clears things up.

John

@jmcnamara commented on GitHub (Nov 4, 2016): > File created with 'options' contains xl/sharedStrings.xml however file without 'options' doesn't have that. Just to be clear, I think that should be the other way around. Basically it works like this: 1. In default libxlsxwriter `new()` mode the `constant_memory` mode is off and the library writes any strings to the `xl/sharedStrings.xml` file. This can be considered a "standard" xlsx file. 2. When `constant_memory` in on the libxlsxwriter library avoids a non constant memory overhead by writing the strings "inline" in the `worksheet.xml` files and avoid using the `xl/sharedStrings.xml` file. This is a documented Excel feature that is supported by most spreadsheet applications. However, some applications don't support it, such as Apple Numbers. If spreadsheet-parser doesn't support it then you should avoid using the `constant_memory` option in libxlsxwriter. I hope that clears things up. John

gitea-mirror commented

2026-05-05 11:35:42 -06:00

Author

Owner

@jmcnamara commented on GitHub (Nov 4, 2016):

P.S., This side-effect is documented: http://libxlsxwriter.github.io/working_with_memory.html#ww_mem_inline_strings

@jmcnamara commented on GitHub (Nov 4, 2016): P.S., This side-effect is documented: http://libxlsxwriter.github.io/working_with_memory.html#ww_mem_inline_strings

gitea-mirror commented

2026-05-05 11:35:45 -06:00

Author

Owner

@xakepsoft commented on GitHub (Nov 4, 2016):

Thanx, a lot.

I'll try to fix the reader so it conforms to standards.

@xakepsoft commented on GitHub (Nov 4, 2016): Thanx, a lot. I'll try to fix the reader so it conforms to standards.

gitea-mirror referenced this issue

2026-05-05 11:40:14 -06:00

[GH-ISSUE #117] Open error of file under Windows Excel 2016 #97

gitea-mirror referenced this issue