Apache OpenOffice (AOO) Bugzilla – Issue 114816
Column formating is lost when changing query content
Last modified: 2013-02-07 22:41:22 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
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.