HI!
AVKORTA is the commando that takes the sum to nearast even sum down = .1-4 will
be “AVKORTA” down to 0.0. When “HELTAL” will rounding up .5-9.
Regards,
Marino
From: Tom Davies
Sent: Tuesday, July 16, 2013 3:03 PM
To: Marino / WellnessWebshop.se ; Tinkerer ; users@global.libreoffice.org
HI!
You are right. I think the rules is simular in Sweden. I think this
tradition to have the rounded sum on the invoice is to make it easier during
accounting. But this is not the motivation to make this to complicated. Many
invoice in Sweden today has no visible currency rounding.
So, I th
= SHORTENING
Any new idea?
Kind regards,
Marino
-Ursprungligt meddelande-
From: Tom Davies
Sent: Sunday, July 14, 2013 11:02 AM
To: Marino / WellnessWebshop.se ; users@global.libreoffice.org
Subject: Re: [libreoffice-users] Visible currency rounding
Hi :)
Is AVKORTA = Truncate, ie just chopping
Hi!
I want to have visible currency rounding on an invoice template that I have
made i Libre Office. I have this formula in the cell for currency rounding:
=OM(HELTAL(K50+K51)-(K50+K51)>-0,5;AVKORTA(HELTAL(K50+K51)-(K50+K51);3);AVKORTA(HELTAL((K50+K51)+1)-(K50+K51);2))
But something is wrong,
Works perfect - thanks!
Marino
-Ursprungligt meddelande-
From: Carl Paulsen
Sent: Wednesday, July 10, 2013 3:57 AM
To: users@global.libreoffice.org
Subject: Re: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 -
was [libreoffice-users] Error in Calc custom formats between c
f viewing this list's
emails though.
Good luck and regards from
Tom :)
Marino / WellnessWebshop.se wrote
THANKS!
This works perfect! Exactly as I want it to work - you have saved many
hours for me :-)
Kind regards,
Marino
-Ursprungligt meddelande-
From: Errol Goetsch
oops, perhaps a
09:57 PM, Marino / WellnessWebshop.se wrote:
Thanks Steve!
Ive tried this now, but I got Err:501 for this. Any idea why?
Best regards,
Marino
-Ursprungligt meddelande- From: Steve Edmonds
Sent: Monday, July 8, 2013 7:46 PM
To: Marino / WellnessWebshop.se
Cc: users@global.libreoffic
Thanks Steve!
Ive tried this now, but I got Err:501 for this. Any idea why?
Best regards,
Marino
-Ursprungligt meddelande-
From: Steve Edmonds
Sent: Monday, July 8, 2013 7:46 PM
To: Marino / WellnessWebshop.se
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Info
Hi!
I woud like to know if following is possible:
I am about to create an importfile for my products in a webshop. Here I must
have the name of all images and its path and file extansion. The path is always
the same, but the name of the image is individual for each product. My idea is
to have