https://bugs.freedesktop.org/show_bug.cgi?id=65685
Priority: medium
Bug ID: 65685
Assignee: [email protected]
Summary: constant in select list querying a spreadsheet yields
blanks
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 3.3.4 release
Component: Database
Product: LibreOffice
Steps to reproduce
(*) Download the soon-to-be-attached files smallspreadsheet.odt and
constant_in_select_list.odb to the same directory on your system.
(*) Open constant_in_select_list.odb in LibreOffice. Program presents
windown constant_in_select_list.odb.
(*) In Database pane click Queries, and in Queries pane right-click
query_with_constants. Program presents pop-up menu.
(*) In pop-up menu, select "Edit in SQL View...". Program presents
SQL window showing statement
SELECT "number", 'x', 12345, "word" FROM "Sheet1"
(*) If the program does not already show a data grid, press <F5>.
Program action actual: As shown in attached file query_window.png,
the data grid shows the middle two columns blank.
number 'x' 12345 word
------ --- ----- ----
1 one
2 two
3 three
Program action expected: The middle two columns should have
non-blank (albeit very boring) values.
number 'x' 12345 word
------ --- ----- ----
1 x 12345 one
2 x 12345 two
3 x 12345 three
I see this behaviour in LibreOffice version 3.3.4 (as delivered with
ubuntu-natty), version 4.1.0.0.beta2, and in a couple of other fairly
recent versions.
I am leaving bug status UNCONFIRMED to encourage testing on other platforms.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
