[dba-issues] [Issue 93194] Datasources View Does Not Display All Field Entries

[ernest1315]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93194
 Issue #|93194
 Summary|Datasources View Does Not Display All Field Entries
   Component|Database access
 Version|OOo 2.4.0
Platform|PC
 URL|
  OS/Version|Windows XP
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|none
 Assigned to|dbaneedsconfirm
 Reported by|ernest1315





--- Additional comments from [EMAIL PROTECTED] Wed Aug 27 22:00:32 + 
2008 ---
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.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[dba-issues] [Issue 93194] Datasources View Does Not Display All Field Entries

[msc]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93194


User msc changed the following:

What|Old value |New value

 Assigned to|dbaneedsconfirm   |requirements

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW





--- Additional comments from [EMAIL PROTECTED] Fri Aug 29 09:30:57 + 
2008 ---
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.


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]