[GH-ISSUE #344] worksheet_merge_range to display numerical data #277

New issue

Closed

opened 2026-05-05 12:05:26 -06:00 by gitea-mirror · 2 comments

gitea-mirror commented

2026-05-05 12:05:26 -06:00

Owner

Originally created by @sapomuyverde on GitHub (Jul 12, 2021).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/344

Originally assigned to: @jmcnamara on GitHub.

There is some restriction in which I cannot use worksheet_merge_range to combine columns and put numeric data?, I mean,
I have tried to put a numeric data: something like this:

worksheet_merge_range(worksheet, 6, 11, 6, 14, totalCtes, numberWithoutDecimalCenter)

and it didn't work, so I had to convert the variable to string and it worked, is it expected behavior?.

Regards,
Javier

Originally created by @sapomuyverde on GitHub (Jul 12, 2021). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/344 Originally assigned to: @jmcnamara on GitHub. There is some restriction in which I cannot use worksheet_merge_range to combine columns and put numeric data?, I mean, I have tried to put a numeric data: something like this: worksheet_merge_range(worksheet, 6, 11, 6, 14, totalCtes, numberWithoutDecimalCenter) and it didn't work, so I had to convert the variable to string and it worked, is it expected behavior?. Regards, Javier

gitea-mirror

2026-05-05 12:05:26 -06:00

closed this issue
added the
question
label

gitea-mirror commented

2026-05-05 12:05:30 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jul 12, 2021):

and it didn't work, so I had to convert the variable to string and it worked, is it expected behavior?.

Yes.

From the docs for worksheet_merge_range:

The worksheet_merge_range() function writes a char* string using worksheet_write_string(). In order to write other data types, such as a number or a formula, you can overwrite the first cell with a call to one of the other write functions. The same Format should be used as was used in the merged range.

// First write a range with a blank string.
worksheet_merge_range (worksheet, 1, 1, 1, 3, "", format);
 
// Then overwrite the first cell with a number.
worksheet_write_number(worksheet, 1, 1, 123, format);

@jmcnamara commented on GitHub (Jul 12, 2021): > and it didn't work, so I had to convert the variable to string and it worked, is it expected behavior?. Yes. From the docs for [worksheet_merge_range](https://libxlsxwriter.github.io/worksheet_8h.html#ad5a2a09ec65c0f286b756235c7327225): > The `worksheet_merge_range()` function writes a char* string using `worksheet_write_string()`. In order to write other data types, such as a number or a formula, you can overwrite the first cell with a call to one of the other write functions. The same Format should be used as was used in the merged range. ```C // First write a range with a blank string. worksheet_merge_range (worksheet, 1, 1, 1, 3, "", format); // Then overwrite the first cell with a number. worksheet_write_number(worksheet, 1, 1, 123, format); ```

gitea-mirror commented

2026-05-05 12:05:33 -06:00

Author

Owner

@sapomuyverde commented on GitHub (Jul 12, 2021):

I didn't check the docs, thanks for clarifying.

@sapomuyverde commented on GitHub (Jul 12, 2021): I didn't check the docs, thanks for clarifying.