Bug 162910 - Text in Calc does not format correctly at different zoom levels
Summary: Text in Calc does not format correctly at different zoom levels
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Zoom
  Show dependency treegraph
 
Reported: 2024-09-10 20:49 UTC by becripps
Modified: 2024-09-11 20:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Document mentioned in linked discussion (140.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-10 23:39 UTC, Eyal Rozenberg
Details

Note You need to log in before you can comment on or make changes to this bug.
Description becripps 2024-09-10 20:49:49 UTC
Description:
Text will distort and not show properly at different zoom levels or on different machines.

Steps to Reproduce:
1.Make a calc spreadsheet.
2.Open it on a different machine.  The format will not be the same.
3.Change the zoom level - the format will not be the same.

Actual Results:
When I am working on a document from two different machines or when I zoom in to see what I'm doing better, the format will not be the same as a previous zoom level or what it was on the last machine I was working on it at.

Expected Results:
The format of the cell should be the same at every zoom level and on every machine because the document isn't changing.


Reproducible: Always


User Profile Reset: No

Additional Info:
You can see screen shots and a lot of good discussion about the problem HERE:

https://ask.libreoffice.org/t/libreoffice-calc-cells-format-differently-on-different-pcs/110640/11
Comment 1 Eyal Rozenberg 2024-09-10 23:36:00 UTC
> 2. Open it on a different machine.  The format will not be the same.

Different how?

What aspect of the formatting do you believe differs? And what will the difference be?

Also - is the bug report about changing the zoom level, or switching machines?
Comment 2 Eyal Rozenberg 2024-09-10 23:39:00 UTC
Created attachment 196376 [details]
Document mentioned in linked discussion
Comment 3 becripps 2024-09-11 01:17:18 UTC
(In reply to Eyal Rozenberg from comment #1)
> > 2. Open it on a different machine.  The format will not be the same.
> 
> Different how?
> 
> What aspect of the formatting do you believe differs? And what will the
> difference be?
> 
> Also - is the bug report about changing the zoom level, or switching
> machines?

Different as in not on the same machine.  I'm not trying to be obtuse... I just can't describe it any other way.  I work on it on Machine A at work.  I go home to Machine B and work on it there... it does not look the same on Machine B as it does on Machine A.

The format is different in that some of the text in the cells is cut off and not readable.  There are screenshots in the topic I linked if you would like to see.

The bug report is about the switching of machines... one of the repliers said that there was nothing I could do on my end to fix it and to post here about it.  So... ideally if you looked at a document on one machine, it would look the same when you were working on it on a different machine.
Comment 4 Mike Kaganski 2024-09-11 03:38:53 UTC
It is about different layout of the text based on cells' pixel size (which depends both on zoom, and on screen DPI, which makes this issue both for "it looks different with the same zoom on systems with different DPI screens", and "it looks different with different zoom on the same system"), caused by text layout using integers for pixels and font sizes internally. It is similar to the problems I tried to improve lately in e.g. bug 160702. As Noel noted in https://gerrit.libreoffice.org/c/core/+/166238/1#message-822e8d4f50de29e716bd122e7e648a955b66540f, there is room to improve it further, which may improve/fix this issue.