Created attachment 131804 [details] screenshot The field that stores text is omitting the rest of the text after the '-' character is typed in.
Created attachment 131805 [details] database
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.
Created attachment 132614 [details] smaller example .odb Short version: I think that the problem is just the display of MEMO fields. 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
I see the problem as far back as Version: 4.2.0.0.alpha1+ Build ID: fc8f44e... . I am setting version to "4.2 all versions".
Is it possible that LibreOffice think about deploying a web application similar to Mirosoft Onedrive, a web-based office tool?
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 4.0.5.2 and also LO 3.6.7.2 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 3.6.7.2 Couldn't test here, but seems it is been inherited from OOo.