On 05/22/2013 03:34 AM, jnrigg wrote:
> What I need to know first is whether this is occurring in a table
of the database or in a form. If the latter, you may be able to correct
the problem by editing the properties of the fields in the form. The
fields in the form also contains number formatting.
Dan, it is occurring in a table. The database has no forms.
I have been using this database for over 10 years (but previously in
OpenOffice). I was under the impression (perhaps wrongly) that a form wasn't
needed if you were comfortable entering data directly into a table. When
used in OpenOffice, the "cost" field always had the exact cost (two decimal
places) but when used with LibreOffice, the cost filed is rounded off to .00
cents.
I did not convert this database when I moved from OpenOffice to Libreoffice.
I just opened the old file using LibreOffice Base.
I assume you are telling me that the rounding is because I am opening and
viewing the database in "table view" rather than "form view"? If so, is
there a simple way to convert my entire database so that all info will
display as "forms"? Or am I mis-interpreting your message?
--
View this message in context:
http://nabble.documentfoundation.org/rounding-off-number-results-in-Base-tp4056773p4057266.html
Sent from the Users mailing list archive at Nabble.com.
Sorry, but given the facts as you have presented, I have no idea
of what happened nor why it happened.
--Dan
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.