Excel spoji tekst i formulu i oblikuj broj
Formula =CONCAT ( "Stupci P i Q – Stanje: " ; TEXT ( SUM (P105:P107) ; "[$$-en-US]#.##0,00") ; " … (" ; TEXT ( SUM…
webp2gif WebpToGif
magick convert -format gif ajde.webp ajde.gif webp xwebp gif xgif convert xconvert
Powershell pwsh7 intellisense autofill Windows Terminal
Zatvori sve powershellove, windows terminale, blabla i otvori pwsh kao Administrator. Install-Module PSReadLine -AllowPrerelease -Force Notepad $profile i dodaj na kraj: Import-Module PSReadLine Set-PSReadLineOption -PredictionSource…
KDE Plasma – Default desktop environment
sudo update-alternatives –config x-session-manager kde xkde plasma xplasma default xdefault
HTML tooltip
<td class="neštonešto" data-toggle="tooltip" title="Sehen sie diese text? Das ist tooltip">Ovdje sad ide neki pamflet pun nade da će netko povjerovati u nj</td> html tooltip xhtml…
Gdje MSEdge drži passworde?
U datoteci %localappdata%\Microsoft\Edge\User Data\Default\Login Data aka C:\Users\%USERNAME%\AppData\Local\Microsoft\Edge\User Data\Default\Login Data
Outlook desktop – View – Postavi view na folder i podfoldere
Umjesto ovoga.. ..stavi VBA Sub MojPogledView() Dim CurrentFolder As Outlook.Folder Dim i As Long Dim objViews As Views Dim objView As View Set CurrentFolder =…
ib_insync error ‘The API interface is currently in Read-Only mode’
Kôd ib.connect ( ‘127.0.0.1’ , 4002 , clientId = 1 ) Pogreška Error 321, reqId 2147483647: Error validating request.-‘cG’ : cause – The API interface…
Error: Cannot find module ‘semver’
sudo rm -rf /usr/local/lib/node_modules sudo rm -rf ~/.npm curl -0 -L https://npmjs.org/install.sh | sudo sh ili Odjavi se iz SSH i ponovno se prijavi. https://stackoverflow.com/questions/33870520/npm-install-cannot-find-module-semver…
Linkchecker / URLchecker / 404finder / Pronalazitelj ničega
Indijanac Džonz i Potraga za mrtvim linkovima wget –output-file=log.log –no-cache –spider –recursive –no-verbose –no-parent –reject=index.html* –accept=html –domains=domena.tld –no-check-certificate https://domena.tld 2>&1 | grep -B 2 ‘404…
Pretvori HTML tablicu iz datoteke u .CSV tablicu u datoteci
python.py # -*- coding: utf-8 -*- from bs4 import BeautifulSoup import pandas as pd with open("datoteka.html", "r", encoding="utf-8") as file: html_content = file.read() soup =…
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
..i / ili ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO) Rješenje sudo service apache2 stop sudo service mysql stop sudo service…
Pretvorba: HTML tablice u text (html2txt;table2txt)
from bs4 import BeautifulSoup with open("datoteka.html", "r", encoding="utf-8") as html_file: html_content = html_file.read() soup = BeautifulSoup(html_content, ‘html.parser’) tables = soup.find_all(‘table’) table_texts = [] for table…
Previše EventID 5156 za moj ukus
C:\> auditpol /set /subcategory:”Filtering Platform Packet Drop” /success:disable /failure:disable C:\> auditpol /set /subcategory:”Filtering Platform Connection” /success:disable /failure:disable C:\> gpupdate /force Iako.. ovaj “failure” možda nije…
Dizejblaj news feed u Windows 11
Powershell:> Get-appxpackage -allusers *WebExperience* | Remove-AppxPackage windows11 win11 w11 news feed newsfeed disable fakof xwindows11 xwin11 xw11 xnews xfeed xnewsfeed xdisable xfakof onemogući xonemogući
Certifikat – secret-to-public key p12-to-pem
openssl pkcs12 -in SECRET.p12 -clcerts -nokeys -out korak1-PUBLIC_certifikat.pem openssl x509 -pubkey -in korak1-PUBLIC_certifikat.pem -noout > korak2-PUBLIC_key.pem Sauce: https://stackoverflow.com/questions/18230558/export-public-key-from-an-p12-file openssl xopenssl secret2public p122pem secrettopublic p12topem xsecret2public…
Brzina hardvera se možda povećala 100 puta otkako sam zadnji puta mjerio, ali se glupost developera povećala 1000 puta, pa u stvari stalno nazadujemo.
—o—
Outlook – Credential required
Uvod Pišeš emaijlo i želiš ga potpisati ili šifrirati legitimnim certifikatom. Problem Outlook te u vrti u krug i ne prihvaća password koji je, sigurno…
gpg cli cmd tl;dr
gpg kreiranje ključa RSA 4096 sve funkcije, nema rok trajanja gpg –quick-gen-key <%ime.prezime@domena.tld%> rsa4096 cert,auth,sign,encr never gpg izvoz, privatni ključ gpg –armor –export-secret-key <%ime.prezime@domena.tld%> gpg…
Ubuntu jebeno ide u sleep svakih X minuta
..a /var/log/syslog ti se pojavljuje ovo govno “non-stop”: Oct 22 14:16:41 <%ComputerName%> systemd[1]: Reached target Sleep. Oct 22 14:16:41 <%ComputerName%> systemd[1]: Starting Record successful boot…