Pages

miercuri, 12 noiembrie 2025

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

News : Falconeer Remaster Release Trailer

News : BlizzCon 2026 | Ticket Sale Announcement Trailer

News : How religion, politics, and housing shape society - design by ChrWr.

... another good design on graphics ! one video from the Chris Were .

News : ... another programming youtube channel by rajcodes .

Let's see one video from this youtube channel named “How C Code Becomes a Binary: A Raspberry Pi Walkthrough”.

News : Blender with Stable Diffusion XL Tutorial - 2D abstract art

marți, 11 noiembrie 2025

News : Rue Valley Release Trailer | Rue Valley

News : A Look Inside: How Lowe’s Leveraged AI to Become an Agile Digital Retailer

News : Unreal Engine AECO Sizzle Reel 2025

News : GDevelop version 5.5.245 - new changes.

GDevelop can be used to build 2D, 3D, multiplayer games or even apps. It works anywhere: smartphones, tablets, laptops or desktop computers.
One free account and three with prices. New changes on the version 5.5.245.

News : itch.io website with godot shader example demo.

Itch.io (stylized in all lowercase) is a website for users to host, sell and download indie video games, indie role-playing games, game assets, comics, zines and music. Launched in March 2013 by Leaf Corcoran, the service hosts over 1,000,000 products as of November 2024. See the wikipedia article.
Example of godot xe1a - itch.io website.

News : Picsart Vibe Design: Introducing Picsart Assistant and Picsart Flows

With over a billion downloads, Picsart isn’t just the world’s largest creative platform; we’re also the fastest growing.