github-starred/libxlsxwriter

Fork 0

mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00

[GH-ISSUE #280] worksheet_set_row_opt (constant_memory) shows inverted expander #224

New issue

Closed

opened 2026-05-05 11:59:00 -06:00 by gitea-mirror · 6 comments

gitea-mirror commented

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

Owner

Originally created by @znakeeye on GitHub (Apr 1, 2020).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/280

Originally assigned to: @jmcnamara on GitHub.

I see a glitch when setting the outline on each row, in sequence. E.g.:

lxw_row_col_options options = { .hidden = 0, .level = 1, .collapsed = 0 };
worksheet_set_row_opt(ws, currentRow++, LXW_DEF_ROW_HEIGHT, NULL, &options);

Actual:

Expected:

Why is it inverted like that?

Originally created by @znakeeye on GitHub (Apr 1, 2020). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/280 Originally assigned to: @jmcnamara on GitHub. I see a glitch when setting the outline on each row, in sequence. E.g.: ```c lxw_row_col_options options = { .hidden = 0, .level = 1, .collapsed = 0 }; worksheet_set_row_opt(ws, currentRow++, LXW_DEF_ROW_HEIGHT, NULL, &options); ``` **Actual:** ![outline_actual](https://user-images.githubusercontent.com/958469/78136217-8870e980-7423-11ea-9113-d64977efaec0.png) **Expected:** ![outline_expected](https://user-images.githubusercontent.com/958469/78136207-83ac3580-7423-11ea-83b9-368b80799b48.png) Why is it inverted like that?

gitea-mirror

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

closed this issue
added the
question

awaiting user feedback
labels

gitea-mirror commented

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

Author

Owner

@jmcnamara commented on GitHub (Apr 1, 2020):

For clarity, can you add a small complete compilable C program that demonstrates the issue.

@jmcnamara commented on GitHub (Apr 1, 2020): For clarity, can you add a small complete compilable C program that demonstrates the issue.

gitea-mirror commented

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

Author

Owner

@znakeeye commented on GitHub (Apr 1, 2020):

lxw_workbook_options wo { 1, NULL, 0 };
auto wb = workbook_new_opt("foo.xlsx", &wo);
auto ws = workbook_add_worksheet(wb, "Sheet1");

int row = 0;

lxw_row_col_options co = { 0, 1, 0 };
worksheet_set_row_opt(ws, row++, LXW_DEF_ROW_HEIGHT, NULL, &co);
worksheet_set_row_opt(ws, row++, LXW_DEF_ROW_HEIGHT, NULL, &co);
worksheet_set_row_opt(ws, row++, LXW_DEF_ROW_HEIGHT, NULL, &co);

workbook_close(wb);

@znakeeye commented on GitHub (Apr 1, 2020): ```c++ lxw_workbook_options wo { 1, NULL, 0 }; auto wb = workbook_new_opt("foo.xlsx", &wo); auto ws = workbook_add_worksheet(wb, "Sheet1"); int row = 0; lxw_row_col_options co = { 0, 1, 0 }; worksheet_set_row_opt(ws, row++, LXW_DEF_ROW_HEIGHT, NULL, &co); worksheet_set_row_opt(ws, row++, LXW_DEF_ROW_HEIGHT, NULL, &co); worksheet_set_row_opt(ws, row++, LXW_DEF_ROW_HEIGHT, NULL, &co); workbook_close(wb); ```

gitea-mirror commented

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

Author

Owner

@jmcnamara commented on GitHub (Apr 1, 2020):

That isn't a complete compilable C program.

P.S. I just checked and the "Actual" is the Excel default.

You can get the "Expected" by changing the Excel worksheet settings via worksheet_outline_settings(): https://libxlsxwriter.github.io/worksheet_8h.html#a9efae5027e762c9a29f6afa547e4b2db

In particular the symbols_below option.

@jmcnamara commented on GitHub (Apr 1, 2020): That isn't a complete compilable C program. P.S. I just checked and the "Actual" is the Excel default. You can get the "Expected" by changing the Excel worksheet settings via `worksheet_outline_settings()`: https://libxlsxwriter.github.io/worksheet_8h.html#a9efae5027e762c9a29f6afa547e4b2db In particular the `symbols_below` option.

gitea-mirror commented

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

Author

Owner

@znakeeye commented on GitHub (Apr 1, 2020):

Ah! Thanks a lot!

PS. Will improve my samples from now on :)

@znakeeye commented on GitHub (Apr 1, 2020): Ah! Thanks a lot! PS. Will improve my samples from now on :)

gitea-mirror commented

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

Author

Owner

@jmcnamara commented on GitHub (Apr 1, 2020):

No problem. Thanks for following up.

@jmcnamara commented on GitHub (Apr 1, 2020): No problem. Thanks for following up.

gitea-mirror commented

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

Author

Owner

@znakeeye commented on GitHub (Apr 1, 2020):

By the way, your API design is absolutely brilliant. Keep up the good work!

@znakeeye commented on GitHub (Apr 1, 2020): By the way, your API design is absolutely brilliant. Keep up the good work!

gitea-mirror referenced this issue

2026-05-05 12:16:00 -06:00

[PR #224] [MERGED] Respect LDFLAGS when linking #443