Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myFunction() {
- Browser.msgBox("Hello World!");
- }
- function helloWorld(){
- var greeting = 'Hello world!',
- ui=SpreadsheetApp.getUi();
- ui.alert(greeting);
- }
- function onOpen(){
- var ui = SpreadsheetApp.getUi();
- ui.createMenu('Moje menu')
- .addItem('Hello WOrld', 'helloWorld')
- .addItem('Dlugopis tlumaczenie', 'helloSpreadsheet')
- .addItem('Tlumacz', 'showPrompt')
- .addToUi();
- }
- function helloSpreadsheet() {
- var a = 'długopis', sheet = SpreadsheetApp.getActiveSheet();
- sheet.getRange('A1').setValue(a);
- sheet.getRange('A2').setValue(LanguageApp.translate(a, 'pl','es'));
- sheet.getRange('A3').setValue(LanguageApp.translate(a, 'pl','de'));
- sheet.getRange('A4').setValue(LanguageApp.translate(a, 'pl','en'));
- }
- function showPrompt() {
- sheet = SpreadsheetApp.getActiveSheet();
- var ui = SpreadsheetApp.getUi();
- var result = ui.prompt('Słowo do tlumaczenia',
- ui.ButtonSet.OK_CANCEL);
- var button = result.getSelectedButton();
- var text = result.getResponseText()
- if (button == ui.Button.OK)
- {ui.alert('Słowo to ' + text+'.');
- } else if (button == ui.Button.CANCEL){
- ui.alert('Mozesz powtorzyc');
- } else if (button == ui.Button.CLOSE){
- ui.alert('Zamknales okno.');
- }
- sheet.getRange('A1').setValue(LanguageApp.translate(text, 'pl','en'));
- sheet.getRange('A2').setValue(LanguageApp.translate(text, 'pl','fr'));
- sheet.getRange('A3').setValue(LanguageApp.translate(text, 'pl','de'));
- sheet.getRange('A4').setValue(LanguageApp.translate(text, 'pl','es'));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement