Tag: LibreOfficeCalc
IP octet splitting in LibreOffice/Excel
To split an IP address into separate columns for each octet use: 1234A2:=LEFT(A1,FIND(".",A1)-1) A3:=MID(A1,FIND(".",A1)+1,FIND(".",A1,FIND(".",A1)+1)-FIND(".",A1)-1) A4:=MID(A1,FIND(".",A1,FIND(".",A1)+1)+1,FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)-(FIND(".",A1,FIND(".",A1)+1)+1)) A5:=MID(A1,FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)+1,LEN(A1)-FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)) Source: StackOverflow
LibreOfficeCalc / Excel – same file in multiple widows
Problem: Sometimes… one view pane is not enough. Working with larger data sets and many columns – there seems to be no place to put the graphs – save for, … Read More