Bug 96852 - Calc: Add option in "Move/Copy Sheet..." for copying page format to another workbook
Summary: Calc: Add option in "Move/Copy Sheet..." for copying page format to another ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Styles Sheet
  Show dependency treegraph
Reported: 2016-01-01 21:41 UTC by baril_mathieu
Modified: 2021-08-19 23:36 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description baril_mathieu 2016-01-01 21:41:21 UTC
When copying one sheet to an other workbook, the following settings (at a minimum) are NOT transferred:

- Format/Page.../margings
- Format/Page.../Orientations
- Toggle grid lines for current sheet
- Print range

If copying multiple sheets, (not sure exactly when) could get the following cases:

1. Both sheets lost the above formatting
2. Only 1 sheet lost above formatting but the sheet before and/or after insert point loose above formatting. Using CTRL-Z will remove the inserted pages but will not revert corrupted sheets
Comment 1 A (Andy) 2016-01-02 12:34:49 UTC
Reproducible with LO, Win 8.1

If you copy the sheet to a new sheet within the same workbook then the format settings are copied.  But if you copy it to a new workbook then they are not copied.
Comment 2 Terrence Enger 2016-01-02 16:54:41 UTC
I see the reported problem both in Linux daily dbgutil repository
version 2016-01-02 and LibreOffice as delivered with
debian-wheezy.  I am setting version "3.5.4 release" and keyword

I notice that the paper format *is* copied into the new workbook.
This lends support to the idea that the reported bdhavior is a bug.
Comment 3 Xisco Faulí 2016-09-14 22:09:19 UTC Comment hidden (obsolete)
Comment 4 m.a.riosv 2017-12-30 12:57:26 UTC
Still with 
Build ID: f94d98db1be8c27e470b39d4b16ed406db3aef87
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: es-ES (es_ES); Calc: group
Comment 5 Arnaud Jeansen 2018-08-17 09:37:45 UTC
I have been looking into this and tracked down the actual function where the move is done to "sc/source/ui/view/viewfun2.cxx", in function "MoveTable".

See https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/viewfun2.cxx#2647

No clue yet as to what do in there to copy the page formatting though... :)
Comment 6 QA Administrators 2019-08-19 06:57:18 UTC Comment hidden (obsolete)
Comment 7 Ming Hua 2019-08-19 22:45:34 UTC
Still reproducible in:

Version: (x64)
Build ID: 684e730861356e74889dfe6dbddd3562aae2e6ad
CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: zh-CN (zh_CN); UI-Language: en-US
Calc: threaded
Comment 8 QA Administrators 2021-08-19 03:45:28 UTC Comment hidden (obsolete)
Comment 9 Timur 2021-08-19 05:12:54 UTC
This can only be an enhancement to have an option, not the change that would force it. So I retitle, in accordance with comment 1.
Comment 10 baril_mathieu 2021-08-19 23:36:04 UTC
Still reproducible in:

Version: (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded