https://bugs.documentfoundation.org/show_bug.cgi?id=95466
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Hardware|Other |All Version|5.0.2.2 release |Inherited From OOo See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=60 | |539 Ever confirmed|0 |1 OS|Windows (All) |All Severity|normal |enhancement --- Comment #1 from [email protected] --- It is the same reason as described in Bug 60539 (for column-width). Formatting of a query is saved nowhere inside the Base-file. You could change the format when opening the query, but that is all. The only way to see the right formatted field is to create a form with a tablecontrol. This bug appears in all LO-versions and in all systems. If you will only see the format inside the query (and won't change the value in any other way), you could change the SQL-code to something like this: 'N$'||( "Amount" * "Rate" ) / 100||'0' "VAT Amout" ... but be careful. This changes the result to a sting. I will set this as an ask for an enhancement. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
