Hi :) Ouch. I don't know how to get rid of the comma :( Is it even possible? I have a feeling that it would involve a horribly complicated line continuing after the NNNN in order to try to get it to do a backspace. Even if it's possible it's likely to be best avoided.
Perhaps post a bug-report/'feature request'? Regards from Tom :) --- On Thu, 2/2/12, Thomas Damratowski <[email protected]> wrote: From: Thomas Damratowski <[email protected]> Subject: Re: [libreoffice-users] Problems with format in Calc To: [email protected] Date: Thursday, 2 February, 2012, 0:32 NNNN changes to the day, but adds a ',' at the end of the day "monday,". Running Windows 7 LibreOffice 3.4.5 OOO340m1 (Build:502) On Wed, Feb 1, 2012 at 6:13 PM, Tom Davies <[email protected]> wrote: > Hi :) > The ' over-rides the formatting and sets it as text. Did you type the ' > or did it just appear magically? Was there a typo when you set the date > format? > Regards from > Tom :) > > > --- On Wed, 1/2/12, Johnny Rosenberg <[email protected]> wrote: > > From: Johnny Rosenberg <[email protected]> > Subject: Re: [libreoffice-users] Problems with format in Calc > To: [email protected] > Date: Wednesday, 1 February, 2012, 22:11 > > 2012/2/1 Jean Milot <[email protected]>: > > Hi all, > > > > I have a date in a cell : 2012-01-02 > > I would like to have the day so i change format : Date / NNNN but when i > > change the format. > > > > I have the apparition of " ' " at the beginning of the cell. > > > > If i remove it it works i obtain the day. > > > > For now, i use : JOURSEM(date) > > > > Thanks. > > NNNN works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays > ”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and > ”måndag” (monday) for 2012-01-02. > > > You didn't mention your operating system or version of LibreOffice, > maybe there is a bug in your version? > > > > Kind regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ > > -- > For unsubscribe instructions e-mail to: [email protected] > 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 > > -- > For unsubscribe instructions e-mail to: [email protected] > 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 > -- For unsubscribe instructions e-mail to: [email protected] 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 -- For unsubscribe instructions e-mail to: [email protected] 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
