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

On 08/14/2014 03:03 AM, Tom Davies wrote:
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 :)

I was asking about the different types of data strictly from a programing perspective. If I use all text fields I imagine I will have to convert text to numbers and dates to put them in formatted cells. I was wondering if using numeric and date fields would save me from doing the conversion. Just doing a little preplanning. If no one knows, I'll just do some experimenting.

It is a fairly complex multi-sheet spreadsheet that right now forces me to enter some data in more than one place. The sheets are constantly changing so I don't see any way to directly link the cells on the various sheets so I thought a macro was the way to go.

Regards,  Jim

On 13 August 2014 17:57, Jim Byrnes <> wrote:

Using LibreOffice 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.