Patent ID: 7590575

Claim:
A method for converting values and functions contained in a user-selected range of source cells and represented in an at least one source currency to an at least one destination currency using a conversion wizard provided by a spreadsheet application program executing on a computer, comprising: determining, by the computer whether the user selected range of cells contains one of the following: values and functions, wherein the functions comprise at least one formula; (a) providing, by the computer, in the spreadsheet application program, a conversion function for converting the values contained in the user-selected range of source cells to the at least one destination currency; (b) receiving, by the computer, in the spreadsheet application program, a request for converting the values contained in the user-selected range of source cells to the at least one destination currency; (c) receiving, by the computer, in the spreadsheet application program in conjunction with the request, a plurality of arguments in the conversion function wherein the arguments comprise: a value in the at least one source currency to be converted; the identity of the at least one source currency to be converted; the identity of the at least one destination currency; a full precision flag, wherein when the full precision flag is set, the conversion function ignores currency-specific rounding rules; and a triangulation value; (d) applying, by the computer, in the spreadsheet application program, a predefined set of conversion rules to convert the value from the at least one source currency to the destination currency based upon the plurality of arguments received in the conversion; (e) saving, by the computer, the converted value in a destination cell corresponding to a source cell in the user-selected range of source cells containing the value; (f) in response to determining that the user selected range contains functions, determining, by the computer, whether a function comprising a formula in a destination location is to a source location by converting the function and copying the function to the destination cell without modifying the source location; (g) in response to determining that the formula in the destination location is to the source location, converting, by the computer, the formula from the at least one source currency to the at least one destination currency to create a converted function, the converted function comprising a variable identifying the at least one source currency and a variable identifying the at least one destination currency; (h) saving, by the computer, the converted function in the destination location; and (i) repeating, by the computer, steps (d) through (h) for each of the user-selected source cells.