github-starred/libxlsxwriter
2
0
Fork 0
mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00
Code Issues 16 Projects Packages Wiki Activity Actions

[GH-ISSUE #184] Question: set page number #149

New issue
Closed
opened 2026-05-05 11:47:19 -06:00 by gitea-mirror · 8 comments
gitea-mirror commented 2026-05-05 11:47:19 -06:00
Owner
Copy link

Originally created by @petricf on GitHub (May 30, 2018).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/184

Originally assigned to: @jmcnamara on GitHub.

I have multiple sheets in a workbook. The first sheet is a intro sheet. From second sheet onwards i set a footer displaying the page number.
I want the second sheet start its page numbering again at 1 when printing.

Can this be done using libxlsxwriter ?

Originally created by @petricf on GitHub (May 30, 2018). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/184 Originally assigned to: @jmcnamara on GitHub. I have multiple sheets in a workbook. The first sheet is a intro sheet. From second sheet onwards i set a footer displaying the page number. I want the second sheet start its page numbering again at 1 when printing. Can this be done using libxlsxwriter ?
gitea-mirror 2026-05-05 11:47:19 -06:00
gitea-mirror commented 2026-05-05 11:47:27 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (May 30, 2018):

Is that possible in Excel? If so how do you do it?

<!-- gh-comment-id:393070272 --> @jmcnamara commented on GitHub (May 30, 2018): Is that possible in Excel? If so how do you do it?
gitea-mirror commented 2026-05-05 11:47:29 -06:00
Author
Owner
Copy link

@petricf commented on GitHub (May 30, 2018):

In LibreOffice 6.x: Menu Format -> Page, Tab Table, Item "First pagenumber" (translated from german)
Excel (> 2010): See guide at this location
Excel 2010: See guide at this location

<!-- gh-comment-id:393113839 --> @petricf commented on GitHub (May 30, 2018): In LibreOffice 6.x: Menu Format -> Page, Tab Table, Item "First pagenumber" (translated from german) Excel (> 2010): See guide at [this location](https://www.extendoffice.com/documents/excel/2338-excel-restart-page-numbering.html) Excel 2010: See guide at [this location](http://blogmines.com/blog/how-to-change-starting-page-number-in-excel-2010/)
gitea-mirror commented 2026-05-05 11:47:33 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (May 30, 2018):

That parameter can be set in libxlsxwriter using the worksheet_set_start_page() function.

However, I don't think that does what you expect it to do. It just sets the first page that will be printed.

<!-- gh-comment-id:393118955 --> @jmcnamara commented on GitHub (May 30, 2018): That parameter can be set in libxlsxwriter using the [worksheet_set_start_page()](https://libxlsxwriter.github.io/worksheet_8h.html#a817235e5ce7b1ea030bedd86ddbb9844) function. However, I don't think that does what you expect it to do. It just sets the first page that will be printed.
gitea-mirror commented 2026-05-05 11:47:34 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Jun 1, 2018):

Any update on this?

<!-- gh-comment-id:393821315 --> @jmcnamara commented on GitHub (Jun 1, 2018): Any update on this?
gitea-mirror commented 2026-05-05 11:47:36 -06:00
Author
Owner
Copy link

@petricf commented on GitHub (Jun 1, 2018):

Actually tested it. worksheet_set_start_page indeed sets the starting page number used when the page numbers are assigned during printing process.
The current doc of this function seems misleading. I got the impression this function for example skips the first two pages when set to 3.
But the fact is (under LibreOffice) it prints still all pages.
My suggestion is to update the doc to clarify this.

For me this question is hereby solved.

<!-- gh-comment-id:393833983 --> @petricf commented on GitHub (Jun 1, 2018): Actually tested it. worksheet_set_start_page indeed sets the starting page number used when the page numbers are assigned during printing process. The current doc of this function seems misleading. I got the impression this function for example skips the first two pages when set to 3. But the fact is (under LibreOffice) it prints still all pages. My suggestion is to update the doc to clarify this. For me this question is hereby solved.
gitea-mirror commented 2026-05-05 11:47:39 -06:00
Author
Owner
Copy link

@liufeijin commented on GitHub (Oct 4, 2018):

2010 excel
in each sheet we can set the any start number by "Click Page Layout > Page Setup", the start number for each sheet is independent, we can select a sheet and set the any start number.
But the total pages in footer is counting for whole workbook.

<!-- gh-comment-id:426876521 --> @liufeijin commented on GitHub (Oct 4, 2018): >2010 excel in each sheet we can set the any start number by "Click Page Layout > Page Setup", the start number for each sheet is independent, we can select a sheet and set the any start number. But the total pages in footer is counting for whole workbook.
gitea-mirror commented 2026-05-05 11:47:41 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Oct 4, 2018):

@liufeijin this feature request is ready to be closed. If you have an additional feature request then please start a new issue.

<!-- gh-comment-id:426908792 --> @jmcnamara commented on GitHub (Oct 4, 2018): @liufeijin this feature request is ready to be closed. If you have an additional feature request then please start a new issue.
gitea-mirror commented 2026-05-05 11:47:43 -06:00
Author
Owner
Copy link

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

I've made the docs (hopefully) a bit clearer for this function. Closing.

<!-- gh-comment-id:877800840 --> @jmcnamara commented on GitHub (Jul 11, 2021): I've made the docs (hopefully) a bit clearer for this function. Closing.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
coverity
cmake-improvements
cmake_pkgconfig_fix
ctest
button
tables
autofilter
dtoa
iwyu
openssl
gentoo
gh310
condition_format
rich_string_html
header_footer_images
custom_data_labels
object_position
gh265
constant_mode_comments2
constant_mode_comments
vml
md5
vcpkg
hyperlinks
api_refactor
win_fopen
gh203
rich_strings
chartsheet
in_mem_image
gh192
revert-162-master
data_validation
meson
charts
scan_build
utf8_strlen
tmpfileplus
custom_properties
insert_image
default_row
control_chars
worksheet_protect
dev
red_black
panes
mkstemp
defined_names
optimise
wip
v1.2.4
v1.2.3
v1.2.2
v1.2.1
v1.2.0
v1.1.9
v1.1.8
RELEASE_1.1.7
RELEASE_1.1.6
RELEASE_1.1.5
RELEASE_1.1.4
RELEASE_1.1.3
RELEASE_1.1.2
RELEASE_1.1.1
RELEASE_1.1.0
RELEASE_1.0.9
RELEASE_1.0.8
RELEASE_1.0.7
RELEASE_1.0.6
RELEASE_1.0.5
RELEASE_1.0.4
RELEASE_1.0.3
RELEASE_1.0.2
RELEASE_1.0.1
RELEASE_1.0.0
RELEASE_0.9.9
RELEASE_0.9.8
RELEASE_0.9.7
RELEASE_0.9.6
RELEASE_0.9.5
RELEASE_0.9.4
RELEASE_0.9.3
RELEASE_0.9.2
RELEASE_0.9.1
RELEASE_0.9.0
RELEASE_0.8.9
RELEASE_0.8.8
RELEASE_0.8.7
RELEASE_0.8.6
RELEASE_0.8.5
RELEASE_0.8.4
RELEASE_0.8.3
RELEASE_0.8.2
RELEASE_0.8.1
RELEASE_0.8.0
RELEASE_0.7.9
RELEASE_0.7.8
RELEASE_0.7.7
RELEASE_0.7.6
RELEASE_0.7.5
RELEASE_0.7.4
RELEASE_0.7.3
RELEASE_0.7.2
RELEASE_0.7.1
RELEASE_0.7.0
RELEASE_0.6.9
RELEASE_0.6.8
RELEASE_0.6.7
RELEASE_0.6.6
RELEASE_0.6.5
RELEASE_0.6.4
RELEASE_0.6.3
RELEASE_0.6.2
RELEASE_0.6.1
RELEASE_0.6.0
RELEASE_0.5.9
RELEASE_0.5.8
RELEASE_0.5.7
RELEASE_0.5.6
RELEASE_0.5.5
RELEASE_0.5.4
RELEASE_0.5.3
RELEASE_0.5.2
RELEASE_0.5.1
RELEASE_0.5.0
RELEASE_0.4.9
RELEASE_0.4.8
RELEASE_0.4.7
RELEASE_0.4.6
RELEASE_0.4.5
RELEASE_0.4.4
RELEASE_0.4.3
RELEASE_0.4.2
RELEASE_0.4.1
RELEASE_0.4.0
RELEASE_0.3.9
RELEASE_0.3.8
RELEASE_0.3.7
RELEASE_0.3.6
RELEASE_0.3.5
RELEASE_0.3.4
RELEASE_0.3.3
RELEASE_0.3.2
RELEASE_0.3.1
RELEASE_0.3.0
RELEASE_0.2.9
RELEASE_0.2.8
RELEASE_0.2.7
RELEASE_0.2.6
RELEASE_0.2.5
RELEASE_0.2.4
RELEASE_0.2.3
RELEASE_0.2.2
RELEASE_0.2.1
RELEASE_0.2.0
RELEASE_0.1.9
RELEASE_0.1.8
RELEASE_0.1.7
RELEASE_0.1.6
RELEASE_0.1.5
RELEASE_0.1.4
RELEASE_0.1.3
RELEASE_0.1.2
RELEASE_0.1.1
RELEASE_0.1.0
RELEASE_0.0.9
RELEASE_0.0.8
RELEASE_0.0.7
RELEASE_0.0.6
RELEASE_0.0.5
RELEASE_0.0.4
RELEASE_0.0.3
RELEASE_0.0.2
RELEASE_0.0.1
Labels
Clear labels   
awaiting user feedback

   
bug

   
cmake

   
cmake

   
docs

   
feature request

   
in progress

   
long term

   
medium term

   
medium term

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
question

   
ready to close

   
short term

   
under investigation

   
wontfix
No labels
awaiting user feedback
bug
cmake
cmake
docs
feature request
in progress
long term
medium term
medium term
pull-request
question
question
ready to close
short term
under investigation
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
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#149
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?