Issue 114816

Summary: Column formating is lost when changing query content
Product: Base Reporter: cot_al <orazio2>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, r4zoli
Version: OOo 3.2Keywords: oooqa
Target Milestone: ---   
Hardware: Unknown   
OS: Linux, all   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description cot_al 2010-09-29 10:27:01 UTC
When you design a query, you can see the result insing the button execute the
query. 
then clicking with right button on the column, you can define the format of the
column (numeric, financial, ...) then you cannot save the change, and even if
you save the change, as soon as you change something in your query (add or
remove a field) all the format are lost...
it would be noce to do so that the format remain associated to the columns!
(this commment  was experienced using mysql component/ODBC)
thank you
Comment 1 r4zoli 2010-09-29 14:16:22 UTC
In general use of OOo Base you can create query for two types of usage, for the
forms to use in subforms or controls, second use in report.

These situations the formatting go through forms and reports editors, the
content provided by queries.

The query result formatting more is an enhancement than bug.  

Change subcomponent, to none, the issue not SRB related.