Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Equivalent to Excel CONVERT function
Equivalent to Excel CONVERT function
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
mgottli
Guest





PostPosted: Fri Dec 16, 2005 6:39 am    Post subject: Equivalent to Excel CONVERT function

Is there an equivalent in the NeoOffice spreadsheet to Excel's CONVERT function that can convert between different units?

Thanks!
Back to top
JKT
The Anomaly
(earlier version)


Joined: Sep 18, 2003
Posts: 434
Location: London, UK

PostPosted: Fri Dec 16, 2005 1:16 pm    Post subject:

From Help>Contents>Contents>Spreadsheets>Function Types and Operators>Mathematical Functions

Code:
CONVERT
This function allows you to convert a currency value of a European currency into Euros. The conversion factors are stored in the calc.xml file, which is located in the {installpath}/share/config/registry/instance/org/openoffice/Office/ directory.
Syntax:
CONVERT(value;"Text"; "Text")
Value is the amount in the currency to be converted.
Text is the official abbreviation for the currency in question (for example, "EUR"). The first Text parameter gives the source value to be converted, the second Text parameter gives the destination value.
Example:
=CONVERT(100;"ATS";"EUR") converts 100 Austrian Schilling into Euro.
=CONVERT(100;"EUR";"DEM")converts 100 Euro into German Mark.
The table shows you the names of the currencies and the rates of exchange with the Euro set by the European Commission. The basis of calculation is 1 Euro. For more information on this go to http://europa.eu.int/eurobirth/rates.html.


Does that help?

_________________
PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5

Please visit The Land Gallery at http://www.thelandgallery.com for nature-inspired British Fine Art
Back to top
JKT
The Anomaly
(earlier version)


Joined: Sep 18, 2003
Posts: 434
Location: London, UK

PostPosted: Fri Dec 16, 2005 1:21 pm    Post subject:

Furthermore there is CONVERT_ADD which does the equivalent for measurements in place of currencies.

In Calc, click the Autopilot: Functions button (or select Insert>Function... from the menubar) and scroll down the list of functions to the CONVERT options:


_________________
PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5

Please visit The Land Gallery at http://www.thelandgallery.com for nature-inspired British Fine Art
Back to top
jjmckenzie51
The Anomaly


Joined: Apr 01, 2005
Posts: 1055
Location: Southeastern Arizona

PostPosted: Fri Dec 16, 2005 7:16 pm    Post subject:

JKT wrote:
Furthermore there is CONVERT_ADD...


I think I know what the OP wants and I will further expand on it.

I have a requirement to switch from Decimal to Hexidecimal and back.

The CONVERT function in Excel will allow me to specify the cell, type in that cell and the type I want to convert to.

Does NeoOffice/OpenOffice provide for this?

James
Back to top
JKT
The Anomaly
(earlier version)


Joined: Sep 18, 2003
Posts: 434
Location: London, UK

PostPosted: Sat Dec 17, 2005 2:45 am    Post subject:

Hi James,

it appears that NeoOffice probably can do this, but it is spread out over a number of different functions depending on the conversion required. Those are BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, etc:


_________________
PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5

Please visit The Land Gallery at http://www.thelandgallery.com for nature-inspired British Fine Art
Back to top
jjmckenzie51
The Anomaly


Joined: Apr 01, 2005
Posts: 1055
Location: Southeastern Arizona

PostPosted: Sat Dec 17, 2005 9:51 am    Post subject:

JKT wrote:
Hi James,

it appears that NeoOffice probably can do this, but it is spread out over a number of different functions depending on the conversion required. Those are BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, etc:


Thanks, JKT.

I'm looking for something like this. I have a requirement to do this for a project that I'm working on for my 'real' job.

James
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.