Apache OpenOffice (AOO) Bugzilla – Issue 111295
Text in characterfields is shown as "0"
Last modified: 2017-05-20 10:32:02 UTC
I have installed OOo320m16 in as a user in my linux-system (without JRE). When I open the form of the attached database (database is an example for another http://www.openoffice.org/issues/show_bug.cgi?id=109898) in the fields were no names, only the values "0". I tried another form with the wizard - the same problem.
Created attachment 69207 [details] Only "0" is shown in the character-fileds of the form
In tested with OOo 3.2, OOO320m16 and DEV300m76 on win7, forms works same as you described. The culprit in the underlaying "Name" table VARCHAR field formatted half text, half number. If I open table in edit mode, the "Vorname" Format code contain "0" not "@", if I add new field, it is formatted correctly, and works with forms. New table works without problem. Change your fields, or create new tables.
cc
I have designed the tables under OOo 3.1.1. The fields "Vorname" and "Nachname" are both varchar 50 and formatted with @. When I open the attachment in OOo 3.1.1 I see nothing formatted as "0".
I see the "0" in both 3.1.1 and 3.2 (which is a bug, also described in issue 208299). Essentially, the document is broken, and we need to add a workaround for fixing them while reading. Still, I am clueless on a) how the document broke and b) why people continue to say they don't see the problem in 3.1.1. Can you please describe as exactle as possible *which* 3.1.1. version you use? Which platform? From www.openoffice.org, or some other flavour from some other location=
I have downloaded my attachment form friday. It works correct with my system. The fields are varchar, the format "@". The form shows the text of the fields. My OpenOffice Version: 3.1.1 (OOO310m19 Build 9421) in the original version from de.openoffice.org on a SuSE 11.2-system.
Created attachment 69230 [details] Same problem, now in OOo 3.1.1, not in OOO320m16
I have added a new attachment. First I tried to reproduce the way of the first database. I designed a part of a table in 3.1.1 and the form, saved the data and closed 3.1.1. Opened the *.odb-file with OOo320m16, added a table and added a field in the first table. All was OK in OOo320m16. Closing OOo320m16, changing to the other user-account and opening: No text any more in the form, only "0" and in the table also "0".
I found one good workaround on forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=39&t=32802 - Open table for edit - Change data type from [Text]VARCHAR to [Text]VARCHAR_IGNORECASE (the format changes from 0 to @) - Change back to [Text]VARCHAR - Save changes - Close table edit window Then you can use form. I tested on win7 with OOo 3.2.1.
*** Issue 113881 has been marked as a duplicate of this issue. ***
confirmed set to new
while it is still unclear to me how this numeric format slipped in for a text column, I committed a fix to CWS dba34a, which will properly recognize this, and not attempt to format string columns using a numeric format.
grabbing and targeting
*** Issue 114153 has been marked as a duplicate of this issue. ***
fs->msc: please verify in CWS dba34a
verified in CWS dba34a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba34a