Graphic 3D

joi, 13 noiembrie 2025

Win $1,000 and get featured across our site, socials, and newsletter with a dedicated community article.

Join the Top 100 Logos Reanimated challenge!

Join our challenge and explore your creativity by giving iconic logos a fresh animation twist in your own style.

Submission open

Submit your work before 11:59 PM PST, 28th November 2025.

Important dates

AMA session

19th November 2025

Winner announcement

3rd December 2025

miercuri, 12 noiembrie 2025

News : Different Types of Rig Controllers and Posing | Mocap Cleanup Course in Cascadeur

News : Unreal Engine 5.7 Feature Highlights

News : Space Explorers Ultimate Edition | Launch Trailer | Meta Quest 3 + 3S

News : Sanatorium Official Launch Trailer

Google Apps Script : how to filter data by the value in a cell and reset the filter.

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}`);
}