formulas

Write SQL In A Cell With The Google Sheets QUERY Function Filter, group, sort and total a Google Sheet from inside a single cell, using the same select and where clauses you would write against a database. This article… August 13, 2026 · Google Sheets Formulas Clear The Formula Calculation Cache In PHP Using PHPSpreadSheet PhpSpreadsheet memoises every formula result it works out, so changing a cell and reading the formula again hands back the previous answer with no error at all. This… August 13, 2026 · PhpSpreadsheet Use VLOOKUP In Excel Files In PHP Using PHPSpreadSheet VLOOKUP searches the first column of a table and returns a value from the same row. Write one across a lookup table with PhpSpreadsheet, get the absolute-versus-relative references… August 6, 2026 · PhpSpreadsheet Use Named Ranges In Excel Files In PHP Using PHPSpreadSheet A named range lets a formula say =SUM(Amounts) instead of =SUM($B$2:$B$5), so it reads like a sentence and the reference lives in one place. This defines a range… August 3, 2026 · PhpSpreadsheet Read Formula Results In Excel Files In PHP Using PHPSpreadSheet This article shows how to read what a formula in an Excel file actually works out to, rather than the formula itself. Reading a cell with getValue() returns… July 21, 2026 · PhpSpreadsheet