I want copy comments (not notes!) from a spreadshhet to another. This is my question and pheraphs is possible to resolve it using jquery and creating tooltips for every cell and not use more comments.
I don't Know. Is terrible don't find a solution. Thanks Below you find all my my question from stackoverflow my question: i need to do copies and then protect of a lot of sheet (sheet1, sheet2, sheetn) of a Master spreadsheet called "pippo". I have found some routines in line and I have matched them. I want: to do to run my function when I open my master spreadsheet. delete spreadsheet (in my case "Avogadro") so that I'm sure to have updated file to copy comments (no notes!). Here is my spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0ApqK1rm3IrfzdE95M01yei1OZjdmaHlQLXRuMmJGN3c#gid=6 for now I do so (from my master): function copy() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var s = ss.getSheetByName("Avo"); // getComments takes NOTES!!!!! var source = s.getRange("A1:o14").getComments(); var newSS = SpreadsheetApp.create("Avogadro"); //before I would like destroy the old spreadsheet s.copyTo(newSS); // copy sheet newSS.setActiveSheet(newSS.getSheetByName("Sheet1")); var target = newSS.getRange("A1:o14").setComments(source); newSS.deleteActiveSheet(); var ssFile = DocsList.getFileById(newSS.getId()); var folder = DocsList.getFolder("prove"); ssFile.addToFolder(folder); } Thank for the help -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/77smNelmOfAJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
