Posted in Excel

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…

Posted in šđčćž

webp2gif WebpToGif

magick convert -format gif ajde.webp ajde.gif webp xwebp gif xgif convert xconvert

Posted in Powershell Windows

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…

Posted in Linux

KDE Plasma – Default desktop environment

sudo update-alternatives –config x-session-manager kde xkde plasma xplasma default xdefault

Posted in HTML

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…

Posted in Privatnost Windows

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    

Posted in Outlook

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 =…

Posted in Python

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…

Posted in CLI Error Linux

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…

Posted in CLI HTML

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…

Posted in Python

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 =…

Posted in Apache

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…

Posted in Python

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…

Posted in CLI CMD Windows

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…

Posted in CLI Windows

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

Posted in CLI

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…

Posted in UltraPametno

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—

Posted in Privatnost Sigurnost

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…

Posted in Bash CLI CMD Linux Privatnost Sigurnost Windows

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…

Posted in Linux

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…