Bug 158702 - word wrap not working anymore
Summary: word wrap not working anymore
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-14 14:44 UTC by Falco
Modified: 2023-12-15 11:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
cell wrap wrong behavior example (30.18 KB, image/png)
2023-12-14 14:44 UTC, Falco
Details
Calc example (12.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-12-14 15:14 UTC, Falco
Details
screenshot of sample (31.13 KB, image/png)
2023-12-14 17:34 UTC, Falco
Details
various fonts sample (104.11 KB, image/png)
2023-12-14 18:24 UTC, Falco
Details
Screenshot (39.73 KB, image/png)
2023-12-14 21:27 UTC, m_a_riosv
Details
screenshot of sample in Safe mode (60.95 KB, image/png)
2023-12-15 00:08 UTC, Falco
Details
screenshot of sample in Safe mode and LO info popup (207.64 KB, image/png)
2023-12-15 00:10 UTC, Falco
Details
screenshot solved (65.18 KB, image/png)
2023-12-15 09:04 UTC, Falco
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Falco 2023-12-14 14:44:15 UTC
Created attachment 191421 [details]
cell wrap wrong behavior example

After upgrading to 7.6.4.1 (X86_64) BUILD e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 on Windows 10.0 build 19045, word wrapping of text inside cells causes overlapping instead of line feed.
Comment 1 Xisco Faulí 2023-12-14 15:02:29 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 Falco 2023-12-14 15:14:54 UTC
Created attachment 191424 [details]
Calc example

Wrong word wrap behavior with font family Liberation
Comment 3 Falco 2023-12-14 15:16:45 UTC
Added a simple calc file. Font family "Liberation" is affected, while Arial is not.
Comment 4 ady 2023-12-14 17:13:11 UTC
Please add the exact steps in order to arrive to the "wrong" result; if possible by using the file attached in comment 2.

When I open the file in my system, it is not clear to me where is the overlapping you mentioned in comment 0.

In addition to the required steps, maybe a screenshot of the "wrong" behavior might be helpful too; I mean a screenshot of the _same_ sample file that would be used for the steps.

One more point. The Summary currently says "word wrap not working anymore", implying that it was working correctly for you in some older version. It would be helpful to know on which version this was working correctly, or when exactly the feature changed for you, preferably with the same sample file (so the problem can be reproduced by other users).
Comment 5 Falco 2023-12-14 17:34:30 UTC
Created attachment 191431 [details]
screenshot of sample
Comment 6 Falco 2023-12-14 17:55:49 UTC
Existing file was working with 7.6.2.1 version and before.
I used that file every day for about a year without problems.
After upgrading to 7.6.4.1 today, the cells with word wrap formatting suddenly appear without line feed, causing text overlapping.
To supply the sample file, I :
- created a new ods file with Calc
- added a row with Font name for each cell (Liberation Serif, Arial, Liberation Mono, Liberation Sans, Liberation Mono)
- formatted the first row with Bold, horizontal align center, font family "Lucida Console", font size 10pt, vertical align middle, word wrap
- added a second row containing 4 cells with the same text 
"abbiamo provato a fare il word wrap"
- formatted each cell with horizontal align center, vertical align midddle, word wrap, font size 10pt
- applied font family according to the corrisponding column (Liberation Serif, Arial, Liberation Mono, Liberation Sans, Liberation Mono)
- sized columns to cause word wrap
- autosized the second row with double click over row numbers separating line
Result:
every cell in second row with a font family "Liberation" display a wrong text (overlapped), while cell B2, formatted as Arial, shows a correct wrapped text
Comment 7 ady 2023-12-14 18:05:39 UTC
(In reply to Falco from comment #5)
> Created attachment 191431 [details]
> screenshot of sample

Well, there you go; I don't see the same thing when I open attachment 191424 [details] and that's the reason I asked for the steps and the screenshot.

I tested with LO 7.6.3.2 and with LO Dev 24.8 alpha. No repro.

I have not tested with LO 7.6.4.

After opening attachment 191424 [details] as-is, should we perform some step(s) in order to see the problem?
Comment 8 Falco 2023-12-14 18:07:13 UTC
Testing various fonts, I found the same problem with:
- Linux Biolinum G
- Linux Libertine Display G
- Linux Libertine G
Comment 9 Falco 2023-12-14 18:18:49 UTC
(In reply to ady from comment #7)
> (In reply to Falco from comment #5)
> > Created attachment 191431 [details]
> > screenshot of sample
> 
> Well, there you go; I don't see the same thing when I open attachment 191424 [details]
> [details] and that's the reason I asked for the steps and the screenshot.
> 
> I tested with LO 7.6.3.2 and with LO Dev 24.8 alpha. No repro.
> 
> I have not tested with LO 7.6.4.
> 
> After opening attachment 191424 [details] as-is, should we perform some
> step(s) in order to see the problem?

I suppose 7.6.4.1 is required to reproduce the problem.
Just a cell with font family "Linux*" or "Liberation*" and word wrap enabled appears overlapped when text is larger then column width. 
No particular operation is needed, nor others formatting option seems involved.
Comment 10 Falco 2023-12-14 18:24:58 UTC
Created attachment 191432 [details]
various fonts sample
Comment 11 m_a_riosv 2023-12-14 21:27:12 UTC
Created attachment 191436 [details]
Screenshot

I can't see the issue with:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
and
Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 0ddd9f7e055a0c1ecb120de3e40c3fdb8373e9dc
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Comment 12 m_a_riosv 2023-12-14 21:28:36 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 13 Falco 2023-12-15 00:08:17 UTC
Created attachment 191438 [details]
screenshot of sample in Safe mode
Comment 14 Falco 2023-12-15 00:10:55 UTC
Created attachment 191439 [details]
screenshot of sample in Safe mode and LO info popup
Comment 15 ady 2023-12-15 01:10:09 UTC
Perhaps an interesting detail in your screenshots might be that MS-related fonts look fine whereas Linux-related fonts seem to be failing to wrap.

I wonder... Do you have all those fonts actually installed/available in your system?

I also wonder whether this problem could be somehow related to your specific locale settings (it). Perhaps we need someone to test with the same Language/UI/locale settings.
Comment 16 Falco 2023-12-15 09:04:56 UTC
Created attachment 191442 [details]
screenshot solved

Today screenshot after font restore from Control Panel > Fonts > Settings and windows reboot
Comment 17 ady 2023-12-15 11:23:21 UTC
(In reply to Falco from comment #16)
> Created attachment 191442 [details]
> screenshot solved
> 
> Today screenshot after font restore from Control Panel > Fonts > Settings
> and windows reboot

Great. Let's close as WFM then.