Issue 84889 - Spreadsheet as existing database => group by don't work!
Summary: Spreadsheet as existing database => group by don't work!
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.1
Hardware: All Linux, all
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-12-27 19:19 UTC by brot
Modified: 2013-02-07 22:36 UTC (History)
2 users (show)

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


Attachments
Base file used to create this issue (9.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-12-27 19:29 UTC, brot
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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