Bug 95449 - Calc sheet preview and print preview not match for rotated text and images
Summary: Calc sheet preview and print preview not match for rotated text and images
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: high major
Assignee: Not Assigned
Keywords: preBibisect, regression
Depends on:
Blocks: Calc-Images Print-Preview
  Show dependency treegraph
Reported: 2015-10-30 14:17 UTC by Ákos
Modified: 2021-07-19 06:59 UTC (History)
7 users (show)

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

Affected ods file (36.25 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2015-10-30 14:17 UTC, Ákos
screenshot (166.08 KB, image/jpeg)
2015-10-30 14:18 UTC, Ákos
Cell E16 properties Text orientation 60° (23.78 KB, image/png)
2018-04-22 08:17 UTC, Pessé Essille
print preview text orientation 60° & border 90° (22.96 KB, image/png)
2018-04-22 08:23 UTC, Pessé Essille
screenshot with lo6100beta2x64 (211.39 KB, image/png)
2018-06-26 07:25 UTC, Ákos

Note You need to log in before you can comment on or make changes to this bug.
Description Ákos 2015-10-30 14:17:36 UTC
Created attachment 120110 [details]
Affected ods file

In attached ods I have some inserted images, and this images in print preview and printed sheet isn't in your position.
The first affected version is, and the last good version is
I test only in Windows.

I attach the ods file and a screenshot with difference between LO and
The bug still exist in LO
Comment 1 Ákos 2015-10-30 14:18:04 UTC
Created attachment 120111 [details]
Comment 2 m.a.riosv 2015-10-31 15:17:51 UTC
Hi @Akos, thanks for reporting,

Versión: Build ID: f4ca7b35f580827ad2c69ea6d29f7c9b48ebbac7
Version: (x64) Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Versión: (x64) Build ID: 0b48731919433e46e4fda7e5a5ca27c08c28b981
Version: (x64) Build ID: 0b018d202dfcf4bb16b708e10085a4146243b0a0
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-10-25_23:32:01

Rotation text option affects how graphics are partially or completely hidden.

But resetting to default the whole sheet doesn't solve the issue for the mislead position of the graphics in preview.

Changed to the first version where the bug is reproducible.
Comment 3 Cor Nouws 2015-11-02 10:03:17 UTC
I do not see the problem in on 32 bits Linux with Unity.
Comment 4 Ákos 2015-11-02 10:26:35 UTC
I can confirm, that linux is probably not affected.
I test in linux:
Ubuntu 14.04 x64 - LO
Ubuntu 15.10 x64 - LO
and all it's OK.
Comment 5 Ákos 2016-02-15 11:53:45 UTC Comment hidden (obsolete)
Comment 6 Timur 2016-02-16 18:06:13 UTC Comment hidden (obsolete)
Comment 7 Ákos 2016-02-17 08:05:59 UTC
(In reply to Timur from comment #6)
> How do you get the printed page completely rotated?

In each cell I set the text orientation to 180.
Comment 8 Ákos 2016-06-13 14:49:52 UTC Comment hidden (obsolete)
Comment 9 Xisco Faulí 2016-09-13 14:29:12 UTC
As per today, this regression can't be bibisected as it was introduced before 4.4 branch and there's no bibisect repository for the affected branch, thus change 'bibisectRequest' to 'preBibisect'
Comment 10 Thomas Lendo 2017-06-05 22:03:16 UTC
I cannot confirm this issue on Ubuntu/Linux.
Both the print preview and the PDF export file are looking as intended.

Build-ID: b08217989558addbcaded122a4e7211ae24bbcff
CPU-Threads: 4; Betriebssystem:Linux 4.8; UI-Render: Standard; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-05-31_06:36:03
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Comment 11 Thomas Lendo 2017-06-06 09:14:08 UTC
Bug exists only in print preview on Windows.
PDF export shows no problem.

Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; Layout Engine: new

Version: (x64)
Build-ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
CPU-Threads: 8; BS-Version: Windows 6.19; UI-Render: Standard
Comment 12 Timur 2018-01-23 17:18:37 UTC
Text and images are rotated. 
It's interesting they disappear on double click, until cell is expanded.
Comment 13 Pessé Essille 2018-04-22 08:17:50 UTC
Created attachment 141532 [details]
Cell E16 properties Text orientation 60°

Hello, the full border is not 60° aligned. The text is 60° aligned, right. The borders are not 60° aligned, but 90°, in the display.
LO Dev Version: (x64) ; Build ID: d1407aac59f3f218a311452fc7dcb7692fdf5285 ; CPU threads: 4; OS: Windows 10.0; UI render: GL;  TinderBox: Win-x86_64@42, Branch:libreoffice-6-0, Time: 2018-04-20_23:29:55 ; Locale: fr-FR (fr_FR); Calc: C
Comment 14 Pessé Essille 2018-04-22 08:23:39 UTC
Created attachment 141533 [details]
print preview text orientation 60° & border 90°

Hello, in the print preview, the text is right 60° orientation, but the border are not. That's the cells below that are affected. :) fun
Comment 15 Ákos 2018-06-26 07:25:38 UTC
Created attachment 143123 [details]
screenshot with lo6100beta2x64

The bug still exist in:
Version: (x64)
Build ID: 0f4d2060bc90b4008fbc8e6d9a49ec7eeea60b78
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: hu-HU (hu_HU); Calc: CL 

And the export result is worse.
Comment 16 QA Administrators 2019-06-27 02:54:09 UTC Comment hidden (obsolete)
Comment 17 Ákos 2019-07-19 13:37:03 UTC
Bug exists only in print preview on Windows.
PDF export shows no problem.

LibreOffice x64
Comment 18 QA Administrators 2021-07-19 03:26:36 UTC Comment hidden (obsolete)
Comment 19 Timur 2021-07-19 06:59:02 UTC
NOK in Windows LO 6.4, OK in Windows LO 7.0 and 7.3+. WFM.