Bug 43136 - FILESAVE Unable to use custom paper size if saving in xls and xlsx formats.
Summary: FILESAVE Unable to use custom paper size if saving in xls and xlsx formats.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: x86 (IA32) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: XLS-Limitations XLSX-Limitations XLS
  Show dependency treegraph
 
Reported: 2011-11-21 06:36 UTC by ZioTibia81
Modified: 2025-07-06 03:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot ilustrating possible options in MS Office (22.68 KB, image/png)
2019-07-03 22:24 UTC, Bartosz
Details
How it looks like in LibreOffice 7.5 (555.96 KB, image/png)
2023-07-06 06:16 UTC, Bartosz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ZioTibia81 2011-11-21 06:36:33 UTC
- Open a new sheet
- Format -> Page

... see default page format (A4 in my case)

- Change page format on a custom size (45x32cm in my case)
- File -> save as
- Select a name and save in Excel 97/2000/XP/2003

... close calc

Reopen file just saved and you can see that page size is A4 and not custom.

There are no problems saving on ODS format.
Comment 1 ZioTibia81 2012-01-31 00:31:40 UTC Comment hidden (obsolete)
Comment 2 ZioTibia81 2012-03-19 04:27:05 UTC Comment hidden (obsolete)
Comment 3 Roman Eisele 2012-05-03 09:22:14 UTC
This is a Calc issue, therefore changed 'Component' field accordingly. Therefore, 'CALC' is no longer necessary in the Summary field.

Changing the version back to LibO 3.4.3 (according to comment #1). Please note that the 'Version' field should contain the EARLIEST version in which the problem is known to exist, NOT the newest one!

Lowering the severity a bit: IMHO this may be an important issue, of course, but not a 'critical' one (no crash, no loss of data, if I understand correctly).
Comment 4 A (Andy) 2014-11-28 22:05:17 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2015-12-20 16:10:52 UTC Comment hidden (obsolete)
Comment 6 ZioTibia81 2015-12-20 21:30:06 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2017-01-03 19:57:29 UTC Comment hidden (obsolete)
Comment 8 ZioTibia81 2017-01-03 21:38:24 UTC Comment hidden (obsolete)
Comment 9 ZioTibia81 2017-01-04 09:46:37 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2018-01-05 03:41:27 UTC Comment hidden (obsolete)
Comment 11 ZioTibia81 2018-01-05 08:20:24 UTC
Not solved:

Versione: 5.4.3.2 (x64)
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
Thread CPU: 12; SO: Windows 6.19; Resa interfaccia: predefinito; 
Versione locale: it-IT (it_IT); Calc: group
Comment 12 Bartosz 2019-07-03 22:24:50 UTC
Created attachment 152545 [details]
Screenshot ilustrating possible options in MS Office

The issue is a limitation of the xlsx and xls format (see above screenshot). 

Maybe we could workaround it by introducing margins?
Comment 13 QA Administrators 2021-07-03 04:03:34 UTC Comment hidden (obsolete)
Comment 14 ZioTibia81 2021-07-05 07:25:05 UTC
Still

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 24; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: threaded
Comment 15 QA Administrators 2023-07-06 03:15:22 UTC Comment hidden (obsolete)
Comment 16 Bartosz 2023-07-06 06:16:06 UTC
Created attachment 188228 [details]
How it looks like in LibreOffice 7.5
Comment 17 Bartosz 2023-07-06 06:40:40 UTC
Here is the instruction how to setup Custom Page Size under Excel:
https://www.youtube.com/watch?v=hAUZcWyeYEc&t=9s
Comment 18 QA Administrators 2025-07-06 03:10:50 UTC
Dear ZioTibia81,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug