Issue 119929 - When dragging Base query into Calc cell - unnecessary column label gets included
Summary: When dragging Base query into Calc cell - unnecessary column label gets included
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-08 14:35 UTC by Dwayne Henderson
Modified: 2012-06-12 09:07 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Dwayne Henderson 2012-06-08 14:35:45 UTC 
I got this PostgreSQL sales database hooked up to OOo Calc, and the below query to count some sales.

But when I drag this query from "Data Sources" into a cell, Calc includes the word "count" in the cell above the actual count.

I can delete this column label manually, but when I do a Data > Refresh, it reappears. So the only way is to do Format > Rows > Hide. Highly unnecessary if you ask me.

Maybe some option like "Include column label" somewhere?

(I'd attach a sample but unfortunately my database contains a lot of sensitive information)

Thanks!
Comment 1 Dwayne Henderson 2012-06-08 14:36:23 UTC 
* I got this PostgreSQL sales database hooked up to OOo Calc to count some sales.
Comment 2 binguo 2012-06-12 09:07:35 UTC 
No sample file attached blocking verification on AOO3.4.O Rev. 1327774.