Re: [O] Tbl: precision for cells

2013-05-20 Thread Darlan Cavalcante Moreira 

If everything fail you can always process the table with babel to create a
new table the way you like. You could add a function for that to the
library of babel to have it always available.

It is less convenient then a format specifier for the whole table as you
want, but it is a very powerful and flexible way.

--
Darlan

At Sun, 19 May 2013 16:05:33 +0200,
Suvayu Ali wrote:
> 
> On Sun, May 19, 2013 at 06:11:03AM +0200, Manfred Lotz wrote:
> > 
> > I know that I could add ;%.2f to each formula in the table. However, I
> > would like to specify %.2f only one time for the whole table. 
> 
> The format specifier is per formula.  I do not know of any way to have a
> per table format specifier, sorry.
> 
> Cheers,
> 
> -- 
> Suvayu
> 
> Open source is the future. It sets us free.
>

Re: [O] Tbl: precision for cells

2013-05-19 Thread Suvayu Ali 
On Sun, May 19, 2013 at 06:11:03AM +0200, Manfred Lotz wrote:
> 
> I know that I could add ;%.2f to each formula in the table. However, I
> would like to specify %.2f only one time for the whole table. 

The format specifier is per formula.  I do not know of any way to have a
per table format specifier, sorry.

Cheers,

-- 
Suvayu

Open source is the future. It sets us free.

Re: [O] Tbl: precision for cells

2013-05-18 Thread Manfred Lotz 
On Sat, 18 May 2013 17:07:36 +0200
Suvayu Ali  wrote:

> On Fri, May 17, 2013 at 10:18:08PM +0200, Manfred Lotz wrote:
> 
>  [...chomp...chomp...chomp...]
> 
> > As the numeric fields are currency fields could I specify somehow
> > for the whole table that there are exactly 2 decimals after the dot?
> 
> Have you looked at the Chapter on tables in the manual?
> 
> 
> 
> Hope this helps,
> 

Yes, I had checked this out. However, didn't find anything on this page
helping me.

I know that I could add ;%.2f to each formula in the table. However, I
would like to specify %.2f only one time for the whole table. 

-- 
Manfred

Re: [O] Tbl: precision for cells

2013-05-18 Thread Suvayu Ali 
On Fri, May 17, 2013 at 10:18:08PM +0200, Manfred Lotz wrote:

 [...chomp...chomp...chomp...]

> As the numeric fields are currency fields could I specify somehow for
> the whole table that there are exactly 2 decimals after the dot?

Have you looked at the Chapter on tables in the manual?



Hope this helps,

-- 
Suvayu

Open source is the future. It sets us free.

[O] Tbl: precision for cells

2013-05-17 Thread Manfred Lotz 
I have a table like this

| Item |F1  |   F2 |   F3 |
|--++--+--|
| w| 579.12 | 110.0328 | 689.1528 |
| x|   28.8 |5.472 |   34.272 |
| y|   13.2 |2.508 |   15.708 |
| z|24. | 4.56 |28.56 |
|--++--+--|
| Sum  | 513.12 |  97.4928 | 610.6128 |

As the numeric fields are currency fields could I specify somehow for
the whole table that there are exactly 2 decimals after the dot?


So that I have this:
| Item |F1  |   F2 |   F3 |
|--++--+--|
| w| 579.12 |   110.03 |   689.15 |
| x|  28.80 | 5.47 |34.27 |
| y|  13.20 | 2.51 |15.71 |
| z|  24.00 | 4.56 |28.56 |
|--++--+--|
| Sum  | 513.12 |97.49 |   610.61 |


-- 
Thanks,
Manfred