Bug 90360 - Queries don't remember fields format in calculated fields.
Summary: Queries don't remember fields format in calculated fields.
Status: RESOLVED DUPLICATE of bug 86315
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Hardware: All All
: high major
Assignee: Not Assigned
Depends on:
Reported: 2015-03-31 01:15 UTC by mrmister001
Modified: 2015-03-31 19:00 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description mrmister001 2015-03-31 01:15:34 UTC
When you run a query, you have the posibility to format the fields that display the query. Normally the query get the field format from the table, so if you have a table with a Numeric field that you formmated as currency without decimals, for example, the query will result the same format, numeric, currency no decimals.
However, if you create a calculated field, giving that field its name with the alias, when you get the result, you have the posibility also to format it, and show it in currency format (for example).
Okay, the problem is that even if you save the query, it doesn't remember the format type.
This is clearly a bug, because in tables you can remember the field formatting, however in queries, when calculated fields are involved, you cannot remember the fields formatting for calculated fields. Even if you give format to the calculated fields and you save the query, you'll lose that format next time you open the query.
Comment 1 Robert Großkopf 2015-03-31 19:00:42 UTC
This is an enhancement-request. It has been reported here:

There is only saved the name and the Code of the query inside the *.odb-file - nothing else.

I will mark this bug as a duplicate. If you don't think so please reopen this bug. You could also add a comment at Bug86315

*** This bug has been marked as a duplicate of bug 86315 ***