[libreoffice-users] Re: Dialog?

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