Bug 144002 - excel template from ms website not rendering/printing properly
Summary: excel template from ms website not rendering/printing properly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2021-08-22 09:12 UTC by johnks
Modified: 2021-08-22 16:26 UTC (History)
3 users (show)

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


Attachments
excel template file (181.71 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.template)
2021-08-22 09:12 UTC, johnks
Details
excel printing sheet in one page (94.16 KB, image/jpeg)
2021-08-22 09:14 UTC, johnks
Details
excel rendering entire workbook in 3 pages (98.19 KB, image/jpeg)
2021-08-22 09:14 UTC, johnks
Details
LO recognizing summary sheet into 4 pages (93.43 KB, image/png)
2021-08-22 09:15 UTC, johnks
Details
LO recognizing all sheets into 8 pages (61.00 KB, image/png)
2021-08-22 09:15 UTC, johnks
Details
label going outside the box border (63.18 KB, image/png)
2021-08-22 09:16 UTC, johnks
Details

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2021-08-22 09:12:26 UTC
Description:
there is a simple https://templates.office.com/en-us/blue-balance-sheet-tm44461500
balance sheet template available from microsoft website. i tried to open it in libreoffice 7.2 and the file did open but there are rendering problems like the summary page at the end has a "Accumulated retained earnings" which is outside the bounding box.
the more troubling problem is that this workbook is not printing as it should. 
on excel 2019, each page only prints as 1 page so if we select "entire workbook" only 3 pages are printed. Libreoffice does not recognize the print area i think set in the template and is printing willy nilly. 

attaching screenshots as well as file

Steps to Reproduce:
1. download file from link or open attached file. test on excel as well
2. formatting error with large labels
3. try to print in libreoffice as well as in excel. 

Actual Results:
1. label is not honoring box as it is doing in excel 
2. printing is not happening as it should in excel. summary sheet is being printed in 3 pages, while in excel only 1 page is being printed. i understand margins are not being respected or something

Expected Results:
 labels should render same in calc as in excel and each sheets should print in one page as it does in excel


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.4 / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Flatpak
Calc: threaded
Comment 1 johnks 2021-08-22 09:12:56 UTC
Created attachment 174464 [details]
excel template file
Comment 2 johnks 2021-08-22 09:14:04 UTC
Created attachment 174465 [details]
excel printing sheet in one page
Comment 3 johnks 2021-08-22 09:14:33 UTC
Created attachment 174466 [details]
excel rendering entire workbook in 3 pages
Comment 4 johnks 2021-08-22 09:15:06 UTC
Created attachment 174467 [details]
LO recognizing summary sheet into 4 pages
Comment 5 johnks 2021-08-22 09:15:45 UTC
Created attachment 174468 [details]
LO recognizing all sheets into 8 pages
Comment 6 johnks 2021-08-22 09:16:10 UTC
Created attachment 174469 [details]
label going outside the box border
Comment 7 Roman Kuznetsov 2021-08-22 09:35:31 UTC
No problem in

Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL
Comment 8 Gabor Kelemen (allotropia) 2021-08-22 14:57:36 UTC
I see 4 page layout with:

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 5b025285b3528910a4360899abb2bbbaadc72c97
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded
Comment 9 Ming Hua 2021-08-22 16:26:59 UTC
I got 2 pages for the Summary sheet with:
Version: 7.2.0.3 (x64) / LibreOffice Community
Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded

I also see labels going out of the chart box like attachment 174469 [details].

However it seems the whole sheet is using "Franklin Gothic Book" font, which I don't have on my system.  So maybe font related?