Issue 84889

Summary: Spreadsheet as existing database => group by don't work!
Product: Base Reporter: brot <brot>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues-openoffice.org, issues
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: All   
OS: Linux, all   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Base file used to create this issue none

Description brot 2007-12-27 19:19:55 UTC 
!!!The problem also occurs in the older version 2.2 on Linux and in version 2.3
on windows XP!!!

If you create a new database and connect it to an existing spreadsheet, it's not
possible to create a query like:
***
select email, count(*) as counter from address group by email
***
The column 'counter' is always null/empty.

I will try to attach a ods-file for testing purpose!
Comment 1 brot 2007-12-27 19:29:09 UTC 
Created attachment 50580 [details]
Base file used to create this issue
Comment 2 christoph.lukasiak 2008-01-22 15:04:18 UTC 
not yet implemented, but good idea for a feature enhancement
(this functionallity is not supported for spreadsheet database files)
Comment 3 christoph.lukasiak 2008-01-22 15:05:25 UTC 
send further to the requirements team
Comment 4 leggewie 2008-09-25 20:04:00 UTC 
"Group by" or any other "function" does not work at all for me