Welcome to NeoOffice Forums
NeoOffice
 
Official online support site for NeoOffice

Trinity
· Home
· Private Messages
· Your Account


RSS Feeds
· NeoOffice Releases
· Forum Posts
· Beta Releases
· Headlines


Twitter Feeds
· @NeoOffice


Download NeoOffice
· Get NeoOffice
· Get the Latest Patch
· Language Packs
· User Guide
· User Guide Volume 2


Other Websites
· NeoOffice.org
· NeoWiki


Languages
Select Interface Language:



  
trinity.neooffice.org :: View topic - Equivalent to Excel CONVERT function
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Private MessagesPrivate Messages   Log inLog in 

Equivalent to Excel CONVERT function
Users who have purchased direct support within the last year can post

 
Post new topic   Reply to topic    trinity.neooffice.org Forum Index -> NeoOffice Support
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 Reply with quote

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: Reply with quote

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
View user's profile Send private message Visit poster's website
JKT
The Anomaly
(earlier version)


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

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

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
View user's profile Send private message Visit poster's website
jjmckenzie51
The Anomaly


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

PostPosted: Fri Dec 16, 2005 7:16 pm    Post subject: Reply with quote

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
View user's profile Send private message
JKT
The Anomaly
(earlier version)


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

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

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
View user's profile Send private message Visit poster's website
jjmckenzie51
The Anomaly


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

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

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    trinity.neooffice.org Forum Index -> NeoOffice Support 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.
Page Generation: 0.05 Seconds