Paul's Latest Public Bookmarks
=(B3/B2)-1 Set 'result' format to Percentage and you're all set!
Saved by: Paul on 24 Jul 2020
Interesting looking, relatively small CMS. As recommended on the WAUK list
Saved by: Paul on 14 Jul 2020
How to get various entities / odd character encoding problems (e.g. ticks) to show when making a PDF with dompdf - main fix was to use the DejaVu Sans font.
Saved by: Paul on 9 Jul 2020
Select the cell Go to Home tab From Conditional Formatting choose Highlight Cell Rules > More Rules Select Use a formula to determine which cells to format Write =LEN($A1)>=15 as formula and select format (change colors etc.)
Saved by: Paul on 29 Jun 2020
This seems the most relevant bit... $arr = [1,2,3]; $in = str_repeat('?,', count($arr) - 1) . '?'; $sql = "SELECT * FROM table WHERE foo=? AND column IN ($in) AND bar=? AND baz=?"; $stm = $db->prepare($sql); $params = array_merge([$foo], $arr, [$bar, $baz]); $stm->execute($params); $data = $stm->fetchAll(); ... although I ended up doing the IN with a straight list as I could be sure the items in the list were clean.
Saved by: Paul on 19 Jun 2020
Highlight the column with the data in that needs de-duplicating. Data > Filter > Standard Filter > Choose column, Value: - not empty - Open "More Options" Choose "No duplication" Click "OK" Highlight all data and copy to another spreadsheet
Saved by: Paul on 11 Jun 2020