Can't copy print range with page breaks to new spreadsheet

[ittrainee]

I have an xls document. I want to copy 1 sheet to a new workbook. I want to copy the whole content on that sheet including page breaks and print range settings.

But, when I try to copy the sheet by right click on the sheet tab > move or copy sheet, the sheet in the new workbook does something like a reset. It switched to normal view and the page break is not the same with the previous page break I set.

I’m using LibreOffice v 5.3.7
I have tried with the ODS files too, but the same case still appears.

Why does that problem appear?

[jimk]

It is not clear what you want to do. Copy what, and to where? Please write in complete sentences, starting with an uppercase letter and ending with . or ?. Also, the title is too long. See guidelines for asking.

[ittrainee]

Hi, Jim
Thank for your reply. I am newbie here, and i will read the guidelines.
I have a xls document. I want to copy 1 sheet to a new workbook. I want to copy whole content in that sheet including pagebreak and print range setting.
but, when I try to copy sheet by - right click on the sheet tab > move or copy sheet
the sheet in new workbook something like reset. It switched to normal view and the page break is not same with previous page break i set.
I hope this clearly explain you
Thank you

[mariosv]

Open xls file, right click on the tab to copy, select

'Move or Copy Sheet', 'Copy', 'Location To document' '- new document -'

[mikekaganski]

Looks like OP does just that?

[ittrainee]

thanks for the answer
but after i do that think
than the format of my workbook gone and i must recreating again the format

can you have another advice? so i can do copy sheet without loosing my format page

thank you

[mikekaganski]

Well: if you need a new spreadsheet, then just copy the entire file and remove needless other sheets…

[mariosv]

There is a reported bug tdf#96852 FORMATTING: “Move/Copy Sheet…” not copying page format