Issue 120406 - In database made in earlier OOo version, datasheet style form will only display (apparently) random integers (mostly value 0) irrespective of field types
Summary: In database made in earlier OOo version, datasheet style form will only displ...
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.0
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-30 10:21 UTC by Chris Yates
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
a contacts database exhibiting the erroneous behaviour described in the bug report (257.78 KB, application/vnd.sun.xml.base)
2012-07-30 10:21 UTC, Chris Yates 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Chris Yates 2012-07-30 10:21:49 UTC 
Created attachment 78781 [details]
a contacts database exhibiting the erroneous behaviour described in the bug report

In a database originally created in an earlier version (3.0 or 3.1 I think), datasheet style forms created using the wizard will only display (apparently) random integers (mostly of value 0) irrespective of field type. 

Potentially a related issue: the Notes field (memo data type) in the form table_employeres also exhibits this behaviour.

How to demonstrate error:

The forms "form_Employers_detail" and "form_Employers" both use "Query_table_Employers" as their datasource. The former is a non-datasheet type form and the latter is a datasheet style form. The former renders character fiels correctly, the latter does not.

Both forms were created in the wizard.

Related error:
Open table "table_employers". All fields render correctly apart from the "Notes" field. This is a memo field. Note that the form "form_employer_details" does render it correctly as a memo field.

This may be related to: https://issues.apache.org/ooo/show_bug.cgi?id=111295