| View previous topic :: View next topic |
| Author |
Message |
valterb
The Anomaly
(earlier version)
Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy
|
 Posted: Tue Mar 13, 2007 12:34 am Post subject: wiki page about addition of time formatted cells |
|
Rodrido and Jacqueline.
I'm translating the page that Rodrigo has written in neowiki about this and that Jacqueline has translated here.
Well, I have a problem with this. I'm using NeoOffice 2.1 EAP patch 1, and when I do the sum the result is directly 50:10 and not 2:10.
The cell that contain the result is formatted as "Number" ->""Default", and only if I change the format to "time" the result change to 2:10 (I'm sorry if the format category is not that in the english version of NeoOffice, I'm guessing this from my italian one).
Is this a differnce introduced with version 2.1??
Valter |
|
| Back to top |
|
 |
RoyFocker
Oracle
Joined: Sep 23, 2006
Posts: 218
Location: Rome, Italy
|
| Posted: Tue Mar 13, 2007 4:49 am Post subject: |
|
| Valterb: if you make an addition with ∑, the format will come on number as you say, but if you operate with cells from other sheets or other cells not adjacents, the automatical format will be HH:MM:SS or HH:MM |
|
| Back to top |
|
|
valterb
The Anomaly
(earlier version)
Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy
|
| Posted: Tue Mar 13, 2007 5:06 am Post subject: |
|
Rodrigo, which version are you using?
Valter |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Tue Mar 13, 2007 6:06 am Post subject: Re: wiki page about addition of time formatted cells |
|
| valterb wrote: | Rodrido and Jacqueline.
I'm translating the page that Rodrigo has written in neowiki aboutthis and that Jacqueline has translated here.
Well, I have a problem with this. I'm using NeoOffice 2.1 EAP patch 1, and when I do the sum the result is directly 50:10 and not 2:10.
The cell that contain the result is formatted as "Number" ->""Default", and only if I change the format to "time" the result change to 2:10 (I'm sorry if the format category is not that in the english version of NeoOffice, I'm guessing this from my italian one).
Is this a differnce introduced with version 2.1??
Valter |
It's normal behaviour. See the second method Rodrigo give
in Fr
"En utilisant le format Standard
Sélectionnez la cellule devant contenir le résultat.
Allez dans le menu Format puis dans le sous-menu Cellules...
Sélectionnez Nombres
Dans la section Catégorie sélectionnez Nombre
Dans la section Format choisissez Standard
Cliquez sur OK"
I checked the two methods with two problems that I described on Roy's Talk Page
[[HH]] instead of [HH] and using "Sigma" (the Greek letter doesn't appear in this message ?) needs some care.
I corrected the [[HH]] in the Fr version and changed a bit the "Sigma" use to show the issues.
10.4.8 Neo EAP patch 1
Jacqueline |
|
| Back to top |
|
|
RoyFocker
Oracle
Joined: Sep 23, 2006
Posts: 218
Location: Rome, Italy
|
| Posted: Tue Mar 13, 2007 6:51 am Post subject: |
|
NeoOffice 2.0 Beta Patch 15
I corrected the text in spanish!
(valterb: mi fai sentire come uno che viene qua a chiedere soporte  ) |
|
| Back to top |
|
|
valterb
The Anomaly
(earlier version)
Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy
|
| Posted: Wed Mar 14, 2007 3:54 am Post subject: |
|
How can I remove a double posting?
Valter
Last edited by valterb on Wed Mar 14, 2007 3:55 am; edited 1 time in total |
|
| Back to top |
|
|
valterb
The Anomaly
(earlier version)
Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy
|
| Posted: Wed Mar 14, 2007 3:54 am Post subject: |
|
Hi friends, I have probably misunderstood what you have written in that page. Now i catch this and compleate the translation. Thanx a lot to both of yiu.
| RoyFocker wrote: | | (valterb: mi fai sentire come uno che viene qua a chiedere soporte ) |
Rodrigo, non so cosa vuol dire soporte....
Valter |
|
| Back to top |
|
|
RoyFocker
Oracle
Joined: Sep 23, 2006
Posts: 218
Location: Rome, Italy
|
| Posted: Wed Mar 14, 2007 4:29 am Post subject: |
|
Lo dicevo perchè ogni volta che qualcuno viene al foro di "neooffice support" prima di rispondere tutti le chiediamo sulla versione e il patch che sta adoperando... 
soporte = support in spagnolo... Non so come si dice in italiano
I made some corrections in spanish text.
Thanks to all. Now I can put the categories of the page... |
|
| Back to top |
|
|
valterb
The Anomaly
(earlier version)
Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy
|
| Posted: Wed Mar 14, 2007 4:35 am Post subject: |
|
Hai ragione, ma visto che da NoeOffice 2.0 beta a NO 2.1 ci sono un sacco di cambiamenti potrebbe succedere che un comportamento che uno ha con una versione sia in realtà stato cambiato in una versione successiva.
Ciao, Valter
P.S. in italiano soporte dovrebbe essere supporto. |
|
| Back to top |
|
|
|
