Bug 106482 - DISPLAY: MEMO field not showing all the content in tableview
Summary: DISPLAY: MEMO field not showing all the content in tableview
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2017-03-10 18:11 UTC by John Smith
Modified: 2017-11-02 23:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

screenshot (219.31 KB, image/jpeg)
2017-03-10 18:11 UTC, John Smith
database (61.54 KB, application/vnd.sun.xml.base)
2017-03-10 18:12 UTC, John Smith
smaller example .odb (3.74 KB, application/vnd.oasis.opendocument.database)
2017-04-16 18:29 UTC, Terrence Enger

Note You need to log in before you can comment on or make changes to this bug.
Description John Smith 2017-03-10 18:11:43 UTC
Created attachment 131804 [details]

The field that stores text is omitting the rest of the text after the '-' character is typed in.
Comment 1 John Smith 2017-03-10 18:12:17 UTC
Created attachment 131805 [details]
Comment 2 Timur 2017-03-10 19:00:59 UTC
Please write exact steps to reproduce a problem. Also if it's only with this file or from scratch. Not obvious since your PEP has 69 records.
Comment 3 Terrence Enger 2017-04-16 18:29:34 UTC
Created attachment 132614 [details]
smaller example .odb

Short version: I think that the problem is just the display of MEMO

In the attached embedded_HSQLDB.odb, Table1 includes fields
    f1 : MEMO
    f2 : VARCHAR
    f3 : CHARACTER (fixed)

As the column widths in data view are adjusted to be narrower than the
stored data, the program always truncates f1 at a space or hyphen.
The result looks neat, hiding the fact of the truncated display.
Fields f2 and f3 are less neat, even truncating the display in the
middle of a letter.  The truncation is obvious to the viewer.

I am setting status NEW and adjusting the summary according to what I
have observed.

I am setting see-also bug 79026.  It differs from the present bug in ...
    (*) different backend
    (*) update, not just display
    (*) form rather than data view
Comment 4 Terrence Enger 2017-04-16 18:34:29 UTC
I see the problem as far back as Version: Build ID:
fc8f44e... . I am setting version to "4.2 all versions".
Comment 5 John Smith 2017-04-30 07:06:38 UTC
Is it possible that LibreOffice think about deploying a web application similar to Mirosoft Onedrive, a web-based office tool?
Comment 6 Robert Großkopf 2017-04-30 14:37:14 UTC
Seems the GUI interprets "-" as a hyphen if it must produce a line-break. If you will change the width of the column the other text will appear. Also changing the height of the column will work.

I couldn't see it ever worked in another way. LO and also LO will show the same behavior. (Tested with OpenSUSE 42.1 64bit rpm Linux)

Showing all the content of a MEMO-field in the table-GUI shouldn't be allowed with automatic row-height, because the content of such a field could be very large. Only MEMO allows to save line-breaks and paragraphs. So the automatic row-height will only show the height of one row.

A possible enhancement will be to show there is more content with a (red) triangle like it is shown in fields of the report-builder.

Other enhancement will be: Don't let "-" be interpreted as a hyphen. But how should set hyphens instead?

I will set this one to ENHANCEMENT and the version to LO Couldn't test here, but seems it is been inherited from OOo.