D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] OO Spreadsheet decimal

 

I've found the same thing in Excel it's

0.00_ ;[Red](-0.00)

which gives 
Type in 1234

and get 12.34

Wonderful! :)

On Tue, 2010-08-10 at 16:36 +0100, Henry Bremridge wrote:
> On Tue, Aug 10, 2010 at 04:13:40PM +0100, tom wrote:
> > On 10/08/10 15:12, kevin wrote:
> > >Hi all
> > >is there a oo Spreadsheet guru around?
> > >I would love to know if you can get Spreadsheet to accept a number
> > >(currency)  in a cell and add the Decimal point ( to 2 places ) without
> > >me having to type it at all?
> > >
> > >I think in Excel this is possible but cannot find it in OO
> > >
> > >if not OO the is is possible in javascript as I can do this in a web
> > >form
> > >
> > >Its VAT return time and I have to break down each line on the  invoices
> > >to one of 12 groups
> > >Thanks in advance
> > >
> > >
> > >Regards
> > >
> > >Kevin Lucas
> > >Minions Post Master(Sub)
> > >Ten Years in the Making!
> > >www.minionsbandb.co.uk
> > >www.tearooms.minionsbandb.co.uk
> > >Po House, Minions,
> > >Liskeard Cornwall
> > >PL14 5LE
> > >01579363386
> > >
> > >
> > In OO you can set the cell format to a currenc( Ânnnnn.xx) and it
> > will put the  in but you have to put the . in to tell it the
> > pennies
> > In JS you could use a form <input type=text
> > onchange=formatfunction(this)>....
> > 
> > Now if we had a decent open standard simple business xml data
> > exchange format there would probably be a simple to do this....
> > 
> One of nicest things about oOo, particularly when entering data into
> spreadsheets is the F11 key.
> 
> - Press F11
> - Select a cell or a range of cells and double click the entry in the
>   styles and formatting dialogue: cells formatted
> - Change the formatting instructions (select a style, right click and
>   modify) and all cells with that formatting are changed
> - If you create your own format instructions then you can attach that to a
>   key stroke combination (Tools | Customize) and then save that as a
>   default spreadsheet template (File | Template | save). For example on my
>   spreadsheet if I press CTRL-N then then cell is formatted to
>     - ,000
>     - 2 decimal places
>     - negative in red in brackets
> 
> Similarly if I am working in multiple currencies then I tend to create
> formats for eg INR, USD and EUR and use the F11 key to format accordingly.
> 
> YMMV but it saves me considerable time: and irritates me when I use excel
> 
> Anyway one way to solve your problem:
> -   Set the format instructions to percentages
> -   Enter the data as a percentage
> -   Once all entries done, Change the format instructions on F11 to the
>     appropriate currency
> 
> 
Regards

Kevin Lucas
Minions Post Master(Sub) 
Ten Years in the Making!
www.minionsbandb.co.uk
www.tearooms.minionsbandb.co.uk
Po House, Minions,
Liskeard Cornwall 
PL14 5LE
01579363386


-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq