Windy.GoogleTranslate

Example The following formula translates the text in cell A1 from English to German using the Google Translate API. =Windy.Google.Translate(A1,”de”,”en”) Parameters text – The text to translate. The text can either come from a cell reference or be entered manually (e.g. “Example sentence to translate”) targetLanguage – The code for the language to translate into. … Continued

Windy.ExchangeRates.HNB

Example The following formula converts an amount of Euros specified in cell A1 to Croatian kunas based on the buying rate defined from the Croatian National Bank. =Windy.ToHRK(A1,”EUR”,DATE(2021,4,1),1) Parameters amount/iznos – the amount of money to convert fromCurrency – the currency to convert from (e.g. “EUR”, “USD”, “GBP”) date – the date for which the … Continued

Windy.Searchlight

Usage When using Excel press CTRL + ALT + F to open Searchlight. You can close Searchlight at any time by pressing the Escape key. Now you can start searching for Excel objects by entering text into Searchlight. The search functionality currently uses names of the Excel objects to find matches. Searchlight will automatically try … Continued

Windy.Dates

Lorem ipsum dolor sit amet, consectetur Adipiscing elit. Nunc mollis odio quis purus convallis finibus. Etiam pellentesque, mauris a sagittis mollis, est nibh egestas est, eget tempor purus lacus vitae elit. Donec mattis, mauris nec dignissim suscipit, enim purus tempor ipsum, id commodo lorem augue ac neque. Proin id faucibus lorem, vitae ullamcorper dui. Curabitur … Continued

Windy.ExchangeRates.Fixer

Lorem ipsum dolor sit amet, consectetur Adipiscing elit. Nunc mollis odio quis purus convallis finibus. Etiam pellentesque, mauris a sagittis mollis, est nibh egestas est, eget tempor purus lacus vitae elit. Donec mattis, mauris nec dignissim suscipit, enim purus tempor ipsum, id commodo lorem augue ac neque. Proin id faucibus lorem, vitae ullamcorper dui. Curabitur … Continued

Windy.Text

Definitions and examples Windy.Format Replaces the format items in a given input string with the string representations of corresponding objects. Example: The following formula displays a sentence specifying the number of items sold for some price based on the value of the F12 and F13 cells. =Windy.Format(“The company sold {0,10} items for {1:C}”,F12,F13) When F12 … Continued

Windy.Query

Example: The following formula joins two tables and returns the result, including the headers. Whenever the person and department tables change, the results will also update automatically. =Windy.Query(“select * from department d inner join person p on d.ID = p.DptId”, true, true) Summary: The function accepts a string with a SQL query that can work … Continued