Issue 93194

Summary:	Datasources View Does Not Display All Field Entries
Product:	Base	Reporter:	ernest1315 <ernestk3200>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 2.4.0
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description ernest1315 2008-08-27 23:00:32 UTC

There is an apparent glitch in the Data Sources view. Please follow these
instructions: [1] Create a spreadsheet with data in it. [2] Register the
spreadsheet as a Data Source in Open Office. [3] Open the Data Sources view
(F4). The glitch is as follows:  If any of the cells in row 2 in the spreadsheet
contain numerical values (numbers), the text entries in all the cells in the
column below the numerical value will NOT be displayed in the Data Sources view
(even though the spreadsheet contains the data).  However, numbers will not be
affected in the column. Also, if any of the cells in row 2 in the spreadsheet
contain dates, the text entries in all the cells in the column below the date
entry will NOT be displayed AND any numerical values will be changed to a date.

Comment 1 marc.neumann 2008-08-29 10:30:57 UTC

This is a known limitation of the spreadsheet driver.

the driver use the format found in the first row as column format. So a number
in the first row set the form to number and so a string will not displayed. The
same with dates.

anyway I set this issue to ENHANCEMENT and send to the right developer.