Effacement de cellules dans une feuille à la fermeture
Bonjour,
existe-t-il une fonction, ou à partir d'une macro, capable d'effacer certaines cellules dans une feuille lors de la fermeture svp?
Merci par avance
Bonjour,
hé bien non ! GSheets ne capte pas la fermeture de la feuille. Mais tu peux le faire lors de l'ouverture, ce qui in fine revient au même en utilisant onOpen()
Bonjour,
un petit commentaire pourrait peut-être faire avancer les choses mais ça fait déjà huit années que c'est demandé à l'équipe de chez GOOGLE
Merci pour vos réponses. Je ne maitrise pas Google Sheets mais voici ce que j'ai écrit: Est ce correct ou il y plus simple en écriture svp?
Merci par avance
function onOpen () {
Effacement ();
}
function Effacement() {
var ss = SpreadsheetApp.getActiveSpreadsheet ();
// var shMap = ss.getActiveSheet();
// var shMap = spreadsheet.getSheetByName('Calculateur')
var shMap = ss.getSheetByName('Calculateur');
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('B34:E36').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L34:P36').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B34:E36').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B56:E58').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L56:L58').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('D78:D80').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L78:L80').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B100:E102').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L100:N102').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B122:E124').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L122:O124').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B144:D146').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L144:L146').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B166:D168').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L166:P168').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B188:D190').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L188:O190').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B210:D212').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L210:N212').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B232:E234').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L232:N234').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B254:D256').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L254:L256').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B276:D278').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L276:L278').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B298:B300').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L298:L300').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B320:B322').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L320:P322').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B342:D344').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L342:P344').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B364:D366').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L364:N366').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B386:F388').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L386:N386').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('B408:D410').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('L408:O410').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
}
Cela risque d'être trop long ...
function Effacement(){
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var shMap = ss.getSheetByName('Calculateur')
shMap.getRangeList(['A1:B1','A4:B4']).clear({contentsOnly: true, skipFilteredRows: true})
}
change bien sûr
'A1:B1','A4:B4'
avec tes propres données
ce qui ferait sauf erreur de ma part
function Effacement(){
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var shMap = ss.getSheetByName('Calculateur')
shMap.getRangeList(['B34:E36','L34:P36','B34:E36','B56:E58','L56:L58','D78:D80','L78:L80','B100:E102','L100:N102','B122:E124','L122:O124','B144:D146','L144:L146','B166:D168','L166:P168','B188:D190','L188:O190','B210:D212','L210:N212','B232:E234','L232:N234','B254:D256','L254:L256','B276:D278','L276:L278','B298:B300','L298:L300','B320:B322','L320:P322','B342:D344','L342:P344','B364:D366','L364:N366','B386:F388','L386:N386','B408:D410','L408:O410']).clear({contentsOnly: true, skipFilteredRows: true})
}
Oui c'était plus long effectivement mais comme je l'ai écrit je découvre
Merci pour votre aide