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

Commentaire pour demander un OnClose() ou OnExit()

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

Rechercher des sujets similaires à "effacement feuille fermeture"