Advertisement
Guest User

sds

a guest
Apr 23rd, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. function myFunction() {
  2. Browser.msgBox("Hello World!");
  3. }
  4.  
  5. function helloWorld(){
  6. var greeting = 'Hello world!',
  7. ui=SpreadsheetApp.getUi();
  8. ui.alert(greeting);
  9. }
  10. function onOpen(){
  11. var ui = SpreadsheetApp.getUi();
  12. ui.createMenu('Moje menu')
  13. .addItem('Hello WOrld', 'helloWorld')
  14. .addItem('Dlugopis tlumaczenie', 'helloSpreadsheet')
  15. .addItem('Tlumacz', 'showPrompt')
  16. .addToUi();
  17.  
  18. }
  19. function helloSpreadsheet() {
  20. var a = 'długopis', sheet = SpreadsheetApp.getActiveSheet();
  21. sheet.getRange('A1').setValue(a);
  22. sheet.getRange('A2').setValue(LanguageApp.translate(a, 'pl','es'));
  23. sheet.getRange('A3').setValue(LanguageApp.translate(a, 'pl','de'));
  24. sheet.getRange('A4').setValue(LanguageApp.translate(a, 'pl','en'));
  25. }
  26.  
  27. function showPrompt() {
  28. sheet = SpreadsheetApp.getActiveSheet();
  29. var ui = SpreadsheetApp.getUi();
  30. var result = ui.prompt('Słowo do tlumaczenia',
  31. ui.ButtonSet.OK_CANCEL);
  32.  
  33. var button = result.getSelectedButton();
  34. var text = result.getResponseText()
  35. if (button == ui.Button.OK)
  36. {ui.alert('Słowo to ' + text+'.');
  37. } else if (button == ui.Button.CANCEL){
  38. ui.alert('Mozesz powtorzyc');
  39. } else if (button == ui.Button.CLOSE){
  40. ui.alert('Zamknales okno.');
  41. }
  42. sheet.getRange('A1').setValue(LanguageApp.translate(text, 'pl','en'));
  43. sheet.getRange('A2').setValue(LanguageApp.translate(text, 'pl','fr'));
  44. sheet.getRange('A3').setValue(LanguageApp.translate(text, 'pl','de'));
  45. sheet.getRange('A4').setValue(LanguageApp.translate(text, 'pl','es'));
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement