Graphic 3D

miercuri, 12 noiembrie 2025

If you look at this blog, you will find examples of the results of running GAScript scripts in Excel. Today, I will show you how to filter the entire table based on a value from a cell and how to reset it to the original result without filtering.

function reseteazaFiltrarea() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const ultimaLinie = sheet.getLastRow();
  sheet.showRows(1, ultimaLinie);
  SpreadsheetApp.getUi().alert("Toate rândurile au fost afișate.");
}

function filtreazaRanduriDupaCelulaSelectata() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const cell = sheet.getActiveCell();
  const valoare = cell.getValue();
  const coloanaDeFiltrare = cell.getColumn();

  const ultimaLinie = sheet.getLastRow();

  for (let i = 1; i <= ultimaLinie; i++) {
    const valoareRand = sheet.getRange(i, coloanaDeFiltrare).getValue();
    sheet.showRows(i); // asigură-te că rândul e vizibil
    if (valoareRand !== valoare && i !== cell.getRow()) {
      sheet.hideRows(i);
    }
  }

  SpreadsheetApp.getUi().alert(`Filtrare aplicată pentru: ${valoare}`);
}