Re: [libreoffice-users] Problems with format in Calc

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 <tomraymondtom@gmail.com> wrote:

From: Thomas Damratowski <tomraymondtom@gmail.com>
Subject: Re: [libreoffice-users] Problems with format in Calc
To: users@global.libreoffice.org
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 <tomdavies04@yahoo.co.uk> 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 <gurus.knugum@gmail.com> wrote:
>
> From: Johnny Rosenberg <gurus.knugum@gmail.com>
> Subject: Re: [libreoffice-users] Problems with format in Calc
> To: users@global.libreoffice.org
> Date: Wednesday, 1 February, 2012, 22:11
>
> 2012/2/1 Jean Milot <jmilot@dotriver.eu>:
> > 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: users+help@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
>
> --
> For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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