[GH-ISSUE #48] Feature request: Per-cell indentation #40

Closed
opened 2026-05-05 11:27:55 -06:00 by gitea-mirror · 2 comments
Owner

Originally created by @evanmiller on GitHub (Apr 8, 2016).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/48

Originally assigned to: @jmcnamara on GitHub.

Hi, I am currently porting code from xlslib over to libxlsxwriter. One of the incompatibilities I'm hitting is that xlslib allows setting certain attributes on a per-cell basis, including indentation and font, without explicitly defining a workbook-wide format.

I am unfamiliar with XLSX internals, but I would like to request the ability to set the indentation of each cell without having to define a separate format for that indentation level. Right now I am forced to create formats for the Cartesian product of (numeric format strings) x (indentation levels), and the code is getting hairy.

Originally created by @evanmiller on GitHub (Apr 8, 2016). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/48 Originally assigned to: @jmcnamara on GitHub. Hi, I am currently porting code from xlslib over to libxlsxwriter. One of the incompatibilities I'm hitting is that xlslib allows setting certain attributes on a per-cell basis, including indentation and font, without explicitly defining a workbook-wide format. I am unfamiliar with XLSX internals, but I would like to request the ability to set the indentation of each cell without having to define a separate format for that indentation level. Right now I am forced to create formats for the Cartesian product of (numeric format strings) x (indentation levels), and the code is getting hairy.
gitea-mirror 2026-05-05 11:27:55 -06:00
Author
Owner

@jmcnamara commented on GitHub (Apr 8, 2016):

without explicitly defining a workbook-wide format.

The main issue here is that in Excel indentation and fonts are part of formats and are in fact workbook wide. The library could hide that but for now it doesn't.

Right now I am forced to create formats for the Cartesian product of (numeric format strings) x (indentation levels), and the code is getting hairy.

I feel your pain. This is a frequently requested feature in the Perl and Python versions as well.

However, realistically it isn't going to be implemented in the short term until it is implemented first in the other versions and ported over.

<!-- gh-comment-id:207422618 --> @jmcnamara commented on GitHub (Apr 8, 2016): > without explicitly defining a workbook-wide format. The main issue here is that in Excel indentation and fonts are part of formats and are in fact workbook wide. The library could hide that but for now it doesn't. > Right now I am forced to create formats for the Cartesian product of (numeric format strings) x (indentation levels), and the code is getting hairy. I feel your pain. This is a frequently requested feature in the Perl and Python versions as well. However, realistically it isn't going to be implemented in the short term until it is implemented first in the other versions and ported over.
Author
Owner

@jmcnamara commented on GitHub (Jan 2, 2017):

Closing this as it is unlikely to be implemented.

<!-- gh-comment-id:269928970 --> @jmcnamara commented on GitHub (Jan 2, 2017): Closing this as it is unlikely to be implemented.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/libxlsxwriter#40
No description provided.