Issue 119929

Summary: When dragging Base query into Calc cell - unnecessary column label gets included
Product: Calc Reporter: Dwayne Henderson <its.code.in.here>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: binbjguo
Version: 3.4.0   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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.