Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Hi :)
I think it restricts the type of data that can be entered.

Similar to the date one the numbers one probably wont allow text.  Text
ones will allow numbers but will format them as text so you probably can't
easily do calculations on them.

Errr, wouldn't this be easier as a database?  Forms and Reports should be
easier but that is only part of what you are doing there.  Maybe get Base
to read the spreadsheets as it's Tables/back-end?  I'm really not sure and
i'm sure you have explored various ideas to find the best fit for now.

Regards from
Tom :)





On 13 August 2014 17:57, Jim Byrnes <jf_byrnes@comcast.net> wrote:

Using LibreOffice 3.5.7.2 on Ubuntu 12.04 if it makes any difference.

I am designing a dialog that will be opened by a macro, accept some data
and then place the data in the proper cells of a Calc sheet. The data will
consist of text, numbers and dates. In the dialog design environment I see
there are text fields, numeric fields and date fields available.

Is there any advantage to using the various types of fields other than the
date field will only accept date formats and the numeric field will only
accept digits? Will using them possibly keep me from having to write
conversion routines when putting date data in date formated cells or
numeric data in numeric formated cells?

Thanks,  Jim


--
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



-- 
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.