Bug 89219 - LO BASE: Formatted Field Form Control Text formatting broken, displays only zero numeral and numbers
Summary: LO BASE: Formatted Field Form Control Text formatting broken, displays only ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL: http://ask.libreoffice.org/en/questio...
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Forms
  Show dependency tree / graph
 
Reported: 2015-02-08 03:45 UTC by Doug
Modified: 2024-12-23 14:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Open form "Fields" - Varchar shows '0' | open Form "Tablecontrol" - Varchar shows text (18.85 KB, application/vnd.oasis.opendocument.database)
2015-02-15 09:39 UTC, Robert Großkopf 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Doug 2015-02-08 03:45:47 UTC 
STEPS TO REPRODUCE:

1.  Create text field on Table1, enter text
2.  Create Form1 with Table1 as source
3.  Create formatted control by creating any kind of control and then doing `replace with` `formatted field`
4.  In control dialog, change formatting to `text` which is represented by symbol `@`
5.  Navigate through records with form

ANTICIPATED RESULT:

Field control should display text.

UNEXPECTED RESULT:

Field only displays text as '0' as if it is a numeric field.  Formatting unsuccessful or broken.  Does not display text, only number and converts letters to '0'
Comment 1 Buovjaga 2015-02-08 13:37:03 UTC 
Reproduced.

Win 7 Pro 64-bit, LibO Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: fi_FI

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 2 Robert Großkopf 2015-02-15 09:39:00 UTC 
Created attachment 113396 [details]
Open form "Fields" - Varchar shows '0' | open Form "Tablecontrol" - Varchar shows text

There is a difference in the behavior of the formatted field inside a tablecontrol of a form and as separate field. 
If you create a tablecontrol the formatted field shows text the right way.
If you are using a form with separate controls the formatted field shows '0' instead of text.

Have created an attachment which shows the different behavior in two forms. In both forms a formatted field with the same format is used.

My System OpenSUSE 13.2 64bit rpm Linux, LO 4.3.6.2
Comment 3 Robert Großkopf 2015-02-15 10:39:05 UTC 
Another hint:
Open the control in the form "Fields". Right mouseclick on control "txtVarchar". Properties: Formatted Field → General → Formatting. Delete the word "text" at this position.
Save the form, restart.
The control will show text now - instead of wrong '0'.
Comment 4 QA Administrators 2016-02-21 08:34:58 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2016-02-21 09:09:14 UTC 
Tested with 5.1.1.1, OpenSUSE 42.1 64bit romp Linux.
Created a form with control. 
Opened the form - shows the text in the text-control.
Replaced the text-control to formatted field.
Opened the form for editing.
Shows now ",00" instead of text.
Reopened and changed the formatted-control to "text".
Opened the form for editing.
Shows now "0" instead of text.

Only way to show text here is to delete every formatting - also the word "text" in the properties of the control.

Bug still exists.
Comment 6 QA Administrators 2017-03-06 15:05:49 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2017-03-07 15:42:02 UTC 
Bug still exists with LO 5.3.1.1, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 8 QA Administrators 2018-03-08 03:44:42 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2020-03-08 02:50:49 UTC Comment hidden (obsolete)
Comment 10 Robert Großkopf 2020-03-08 06:59:48 UTC 
Bug still exists with LO 6.4.2.1, OpenSUSE 15.1 Leap, 64bit rpm Linux.
Comment 11 QA Administrators 2022-03-09 03:46:38 UTC Comment hidden (obsolete)
Comment 12 Robert Großkopf 2022-03-09 08:07:54 UTC 
Bug still exists with LO 7.3.1.2, OpenSUSE 15.3 Leap, 64bit rpm Linux.
Comment 13 QA Administrators 2024-03-09 03:15:33 UTC Comment hidden (obsolete)
Comment 14 Robert Großkopf 2024-03-09 07:19:59 UTC 
Bug still the same in LO 24.2.1.2 on OpenSUSE 15.4 64bit rpm Linux