Bug 37755 - FORMAT: formats genering text strings (from cell content) doesn't adhere to text alignment format.
Summary: FORMAT: formats genering text strings (from cell content) doesn't adhere to t...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: preBibisect, regression
Depends on:
Blocks: Number-Format
  Show dependency treegraph
 
Reported: 2011-05-30 08:41 UTC by gui
Modified: 2024-02-20 03:12 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Demo document with a clear example (13.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-18 01:50 UTC, gui
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gui 2011-05-30 08:41:41 UTC
If you define the format for a cell in a Spreadsheet to wrap text automatically in the alignment tab of the Format/Cells menu, and you write a long text format in that cell, the text is splitted in several lines, all of them short enough to fit the cell width

BUT

if you input a number value for that cell and you assign to that cell a number format too much long to fit the cell width (say a user format as:  "the value of the calculation was "0.00" expressed in usual units")

IT IS NOT SPLITTED IN SEVERAL LINE, AND THE CELL VALUE IS SUBSTITUTED BY THE "###" STRING

In OpenOffice 3.3.0 in both cases the resulting text line was correctly (and consistently ;-) splitted
Comment 1 Björn Michaelsen 2011-12-23 12:04:12 UTC Comment hidden (obsolete)
Comment 2 gui 2012-01-18 01:50:37 UTC
Created attachment 55722 [details]
Demo document with a clear example

Here you will find a demo calc sheet where to check the bug (generated with LOdev 3.5beta3
Comment 3 gui 2012-01-18 01:53:54 UTC
Verified the bug with LOdev3.5beta3, and it still persist. Added a spreadsheet as an attachment to check it (and understand it) generated with same version LOdev3.5beta3
Comment 4 gui 2014-01-23 17:25:22 UTC
Just writting to say that bug still persists in LO Windows XP v.4.1.4.2
Comment 5 gui 2014-02-03 22:55:20 UTC
Updated version: problem persists in LO 4.2.0.4
Comment 6 Joel Madero 2014-11-04 03:37:26 UTC
Never confirmed by QA team - moving to UNCONFIRMED.
Comment 7 Buovjaga 2014-11-16 09:20:59 UTC
(In reply to gui from comment #2)
> Created attachment 55722 [details]
> Demo document with a clear example
> 
> Here you will find a demo calc sheet where to check the bug (generated with
> LOdev 3.5beta3

Confirmed and also reproduced from scratch. If the Format code name is too long, cell value gets substituted by ###.

Win 7 64-bit Version: 4.4.0.0.alpha2+
Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-12_01:10:08

Ubuntu 14.10 64-bit Version: 4.4.0.0.alpha2+
Build ID: 3cf226622a3d8c09d655034dbcc81695f1662b87
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-15_23:24:22
Comment 8 QA Administrators 2015-12-20 16:13:01 UTC Comment hidden (obsolete)
Comment 9 gui 2016-01-05 18:20:40 UTC
I'm not sure the bug existed in 3.3 version; we detected it first in v.4.1, and still persists in version 4.4.7.2 over WinXP SP3.
I'll check other versions and OS asap.
"Demo document.." attachment runs perfectly (badly! ;-) as a bug's example.
Comment 10 Joel Madero 2016-01-05 18:36:35 UTC
Version is oldest version (as explained in QA Admin spam mail :) ). Reversing update
Comment 11 QA Administrators 2017-03-06 14:11:05 UTC Comment hidden (obsolete)
Comment 12 gui 2017-04-17 23:41:42 UTC
Added keyword "regression" as it had right behaviour in version 3.3; the problem persist in 5.3 version (I'll check the subversion in a while). Regards
Comment 13 QA Administrators 2018-12-03 03:59:07 UTC Comment hidden (obsolete)
Comment 14 QA Administrators 2021-05-15 04:18:00 UTC Comment hidden (obsolete)
Comment 15 Jean-Baptiste Faure 2022-02-19 16:14:42 UTC
Still reproducible in 

Version: 7.3.2.0.0+ / LibreOffice Community
Build ID: e331ce93775c11bdfc2c8782bc1217c835d01b93
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_20.04_x86-64
Calc: threaded

Best regards. JBF
Comment 16 QA Administrators 2024-02-20 03:12:09 UTC
Dear gui,

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