Skip to content
This repository has been archived by the owner on Jul 22, 2022. It is now read-only.

Repeat specific rows or columns on every printed page #171

Open
webmobiles opened this issue Feb 1, 2018 · 3 comments · May be fixed by advisr-io/excel4node#87
Open

Repeat specific rows or columns on every printed page #171

webmobiles opened this issue Feb 1, 2018 · 3 comments · May be fixed by advisr-io/excel4node#87
Labels
enhancement
Milestone
2.0.0

Comments

@webmobiles
Copy link

Hello
there is a way to Repeat specific rows or columns on every printed page ?

here two links how to do it in excel or openoffice. but i don't know if is possible in excel4node, if not there is a way to collaborate to implement this?

thanks

openoffice:
https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Printing/How_I_do_select_a_row_(or_rows)_in_my_spreadsheet_to_repeat_on_every_page_when_printed%3F

excel:
https://support.office.com/en-ie/article/repeat-specific-rows-or-columns-on-every-printed-page-0d6dac43-7ee7-4f34-8b08-ffcc8b022409
@natergj
Copy link
Owner

natergj commented Feb 3, 2018

@webmobiles, Thanks for including the link to the support docs, that helps understand these feature requests a lot!
excel4node does not currently support this feature, but it is covered in the ECMA-376 2nd edition Part 1 under section §18.2.5 so it is something that could be implemented.

I will mark this as an enhancement request and slate it for the 2.0 release. I am still accepting PRs to version 1.x if you would like to implement the feature sooner. There are submission guidelines in the CONTRIBUTING.md file.

@natergj natergj added this to the 2.0.0 milestone Feb 3, 2018
@altoblond
Copy link

Hello,

I would also be greatly interested in this feature.

@raphamartinez
Copy link

Hello,

Has this feature evolved since 2018? Very interested, thank you.

draperunner added a commit to draperunner/excel4node that referenced this issue Nov 1, 2023
@draperunner
Add support for print titles (repeated rows or columns)
00c6ffe 
This will allow you to specify a range of rows and/or columns to repeat
on every printed page. Rows will be repeated on the top of the page,
columns will be on the left side of the page.

The special defined name "_xlnm.Print_Titles" is mentioned in §18.2.5 of
ECMA-376 5h Edition Part 1 2016 but also earlier versions.
(https://www.ecma-international.org/publications-and-standards/standards/ecma-376/)

Fixes natergj#171
@draperunner draperunner linked a pull request Nov 1, 2023 that will close this issue
Open
draperunner added a commit to draperunner/excel4node that referenced this issue Nov 1, 2023
@draperunner
Add support for print titles (repeated rows or columns)
d13b95d 
This will allow you to specify a range of rows and/or columns to repeat
on every printed page. Rows will be repeated on the top of the page,
columns will be on the left side of the page.

The special defined name "_xlnm.Print_Titles" is mentioned in §18.2.5 of
ECMA-376 5h Edition Part 1 2016 but also earlier versions.
(https://www.ecma-international.org/publications-and-standards/standards/ecma-376/)

Fixes natergj#171
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
2.0.0
Development

Successfully merging a pull request may close this issue.

Add support for print titles (repeated rows or columns) draperunner/excel4node
4 participants
@natergj @webmobiles @altoblond @raphamartinez