Re: [libreoffice-users] Help with Conditional Macro Please

Hi :)
I think you can add extra characters in speech-marks can't you?  Something
like;

=CONCATENATE(C2," ",D2," ",TEXT(E2,"dd/mm/yy")," ",TEXT(F2,"dd/mm/yy))

Regards from
Tom :)


On 26 October 2014 19:44, Budgie <ajebay@errichel.co.uk> wrote:

> On 26/10/14 18:31, Brian Barker wrote:
>
> > At 18:14 26/10/2014 +0000, Alastair Noname wrote:
> >
> > > OK, looks simpler and though I would give it a try but having loaded
> > > my .csv file none of the formula are working. Is there somewhere these
> > > can be turned on and off?
> >
> > Do you mean that you see formulae instead of the results of those
> > formulae? If so, remove the tick from Tools | Options... | LibreOffice
> > Calc | View | Display | Formulae.
> >
> > Note also that if you save your work in its current .csv format, any
> > formulae cannot be saved. Instead, just the current values of results of
> > any formulae will be saved, and the functionality will be lost once you
> > reopen the document. To avoid this, you need to save the document in a
> > spreadsheet format, sensibly LibreOffice's default .ods format.
> >
> > I trust this helps.
> >
> > Brian Barker
> >
> >
> >  Hi Brian,
> Sorry about last post.  Email client (Thunderbird on X64 openSUSE 13.1,
> with KDE desktop) has just stalled.
>
> I have been working on the easy bits of my problem and have a solution
> except that the answer looks dreadful as I cannot find out how to insert
> spaces or commas into results of the formula to get the format
> presentable.  I am using:-
>
> =CONCATENATE(C2,D2,TEXT(E2,"dd/mm/yy"),TEXT(F2,"dd/mm/yy))
>
> I hope I can get the results looking better.
>
> That leaves me with the need to add the "conditional" element but LOOKUP
> may be the solution as just by chance the elements /2 become 1,2,3,4 as
> another subscriber has seen.
>
> On last question if I get it all worked out is how may I "freeze" the
> formula results.  I need to do this as I must remove a column used in the
> formula before exporting as .csv for importation into an accounting
> programme.
>
> Thanks for all your help so far.
> Budgie
>
>
> --
> 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