[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
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
--
Henry
Photocopies or faxes of my signature are not binding.
This email has been signed with an electronic signature in accordance with
subsection 7(3) of the Electronic Communications Act 2000.
Digital Key Signature: GPG RSA 0xFB447AA1
Tue Aug 10 16:31:13 BST 2010
Attachment:
signature.asc
Description: Digital signature
-- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq