Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Number Format in Calc
Number Format in Calc
 
   NeoOffice Forum Index -> NeoWiki and Website Development
View previous topic :: View next topic  
Author Message
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Thu Dec 13, 2007 6:58 am    Post subject: Number Format in Calc

I've written this page because my husband was complaining (ranting?) about Calc: he could not get a numbers column formatted as he wanted Smile

en français

and

in English PPT.

Jacqueline
Back to top
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Dec 14, 2007 8:59 am    Post subject:

TPT Smile
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Dec 14, 2007 11:33 am    Post subject:

Nice. Thanks Very Happy

Jacqueline
Back to top
amayze
The Merovingian


Joined: Oct 24, 2005
Posts: 561
Location: Edinburgh, Scotland

PostPosted: Mon Dec 17, 2007 6:48 am    Post subject:

A very clear article, thanks.
Just a couple of things in the English version:
1. There is an "ou" in the table under Scientific Format which should be an "or".

2. In the UK we use "." for decimals and "," for thousands - I don't know if this is the same in the rest of the English speaking world, but the European way round looks wrong in English!

I can do the edits if you think they are a good idea as I have a wiki login.

HtH

Andy.
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Mon Dec 17, 2007 7:31 am    Post subject:

Thank you very much for pointing these carelessnesses out Embarassed

Of course, it's a good remark. Feel free to fix these mistakes.

If you have trouble with the last table, which is a screenshot, I'll replace it easily.

Jacqueline
Back to top
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Mon Dec 17, 2007 7:47 am    Post subject:

Thanks from me, too. I caught some of the "ou" errors, but obviously not all of them. And I meant to ask about the , vs. . issue. In the US we use , for thousands and . for decimals, but I couldn't remember if that was true in England and other English speaking countries. I was in a hurry that day, so I forgot to ask here.

Lorinda
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Mon Dec 17, 2007 10:25 am    Post subject:

Andy,

I've uploaded a new screenshot. You'll have to empty the cache of your browser to see the new image.

Jacqueline
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Mon Dec 17, 2007 11:31 am    Post subject:

I've replaced all the commas with periods and "ou" with "or".

Hope that I did not forget something. Thanks for checking.

Jacqueline
Back to top
valterb
The Anomaly
(earlier version)


Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy

PostPosted: Fri Dec 21, 2007 7:58 am    Post subject:

I'm translating that article.
In the italian article, in paragraph "Thousands separator" I have added a part regarding the italian thousand separatr that is "˙" as in "1˙234".
With italian keyboard this is obtained typing shift+alt+f.
What about other international keyboards?

Valter
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Dec 21, 2007 9:56 am    Post subject:

I didn't find it in the French keyboard. I had to use the Character Palette to insert it: Unicode 02D9 in the Punctuation section. Crying or Very sad

Jacqueline
Back to top
valterb
The Anomaly
(earlier version)


Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy

PostPosted: Fri Dec 21, 2007 10:28 am    Post subject:

But, is actually this "˙" character the thousand separator in French?

It took a while for me to find it, but than I use the Mac OS X Keyboard Viewer.
I saw that in the french keyboard viewer there isn't this sing...

Valter
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Dec 21, 2007 11:59 am    Post subject:

valterb wrote:
But, is actually this "˙" character the thousand separator in French?
Valter

No. We use period or space as thousands separator. So this character is useless for us, at least for that purpose.

Jacqueline
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Jan 04, 2008 11:23 am    Post subject:

I've added a note about how to get the user-defined formats available in all new Calc documents (without having to redefine them), in French and in English (PPT). Seemed important to me.

Jacqueline
Back to top
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Jan 04, 2008 11:51 am    Post subject:

I polished the English addition Very Happy

Lorinda
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Jan 04, 2008 12:00 pm    Post subject:

Thanks Lorinda Very Happy

Jacqueline
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoWiki and Website Development All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.