[GH-ISSUE #294] Footer date format #235

New issue

Closed

opened 2026-05-05 12:00:47 -06:00 by gitea-mirror · 3 comments

gitea-mirror commented

2026-05-05 12:00:47 -06:00

Owner

Originally created by @sapomuyverde on GitHub (Jun 3, 2020).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/294

Originally assigned to: @jmcnamara on GitHub.

Hi,
To put a footer I use

"&LCurrent date: &D" "&RCurrent time: &T";
worksheet_set_footer(worksheet2, footer2)

This puts the date in 03/06/2020 format, I normally use the dd-mmm-yyyy format in dates, how can I put the desired date format in the footer.

Regards,
Javier

Originally created by @sapomuyverde on GitHub (Jun 3, 2020). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/294 Originally assigned to: @jmcnamara on GitHub. Hi, To put a footer I use "&LCurrent date: &D" "&RCurrent time: &T"; worksheet_set_footer(worksheet2, footer2) This puts the date in 03/06/2020 format, I normally use the dd-mmm-yyyy format in dates, how can I put the desired date format in the footer. Regards, Javier

gitea-mirror

2026-05-05 12:00:47 -06:00

closed this issue
added the
question

awaiting user feedback
labels

gitea-mirror commented

2026-05-05 12:00:52 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jun 3, 2020):

how can I put the desired date format in the footer.

How would you do it in Excel? Is it even possible?

@jmcnamara commented on GitHub (Jun 3, 2020): > how can I put the desired date format in the footer. How would you do it in Excel? Is it even possible?

gitea-mirror commented

2026-05-05 12:00:53 -06:00

Author

Owner

@sapomuyverde commented on GitHub (Jun 3, 2020):

Hi,
By your answer I am assuming that is not possible, so a quick web search I see that this depends on the regional settings OS or also do it through VBA.

So I continue as is.

I appreciate your help.

Regards,
Javier

@sapomuyverde commented on GitHub (Jun 3, 2020): Hi, By your answer I am assuming that is not possible, so a quick web search I see that this depends on the regional settings OS or also do it through VBA. So I continue as is. I appreciate your help. Regards, Javier

gitea-mirror commented

2026-05-05 12:00:54 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jun 3, 2020):

By your answer I am assuming that is not possible,

I don't know if it is possible or not but as a general approach it is best to try figure out what you want to do in Excel first and then apply that to libxlsxwriter.

@jmcnamara commented on GitHub (Jun 3, 2020): > By your answer I am assuming that is not possible, I don't know if it is possible or not but as a general approach it is best to try figure out what you want to do in Excel first and then apply that to libxlsxwriter.