https://bugs.documentfoundation.org/show_bug.cgi?id=151196
Bug ID: 151196
Summary: FORMATTING "MM/DD/YYYY HH:MM" won't wrap (wrapping
uses pre-formatted data?)
Product: LibreOffice
Version: 7.5.0.0 alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If a Calc cell has Alignment set to "wrap", a formatted date with time which
contains a space should wrap at the space. But it does not wrap.
Instead "###" appears.
It is as if the text-wrapping machine works on the cell value before applying
formatting, which in this case introduces a space where wrapping can occur. If
that is true, then I think wrapping should use the post-formatted value.
Steps to Reproduce:
(Demo spreadsheet will be attached to this bug)
1. Format a cell with with the Number Format set to a Date form which
introduces a space, for example format code MM/DD/YY HH:MM AM/PM (note space
between date and time).
2. Set the "Alignment" format to "Wrap"
3. Increase the height of the cell to allow several lines to be visible.
4. Store a value in the cell, for example 9/10/11 12:13:14
4. Adjust the column width to be slightly too narrow for the entire date & time
Actual Results:
"###" appears in the cell
Expected Results:
Value should be wrapped, e.g.
09/10/11
12:13:14
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.8.0.0+
Build ID: 71a3f015f2ac45ad4a2625a3b6398f5d75feed40
CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: gtk3;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:libreoffice-6-4, Time:
2020-10-01_08:33:37
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
