Ich möchte bei LibreOffice Calc ein benutzerdefinierte Zahlenformat anlegen, nämlich m³.
Die passende Anleitung habe ich auch gefunden. Dort steht: "Wählen Sie Format – Zelle… – Register: Zahlen"
Aber "Register: Zahlen" gibt es bei mir nicht.
Hat jemand einen Tipp, wie ich mein Zahlenformat anlegen kann?
@storybead @PeteKirkham @geomannie @kityates
Using BASE and DECIMAL functions in LibreOffice for hexadecimal (before overflow). Took longer to do than I thought it would…
#mathematics #number #pattern #arithmetic #LibreOffice #LibreOfficeCalc
I'm trying LibreOffice in my office workflow, and today did some stuff with log files and date/time operations. LibreOffice Calc is more intuitive and seems to understand context far better than Excel. I'm so used to converting unusual datetime formats with a formula of nested LEFTs and RIGHTs in Excel just to prepare it for an operation. Calc just did the operation.
LibreOffice 1 MS Office 0
#LibreOffice #libreofficecalc #excel #MicrosoftExcel #opensource #bigtechdetox
5/13
Cuarto paso:
Abrimos #LibreOffice (¿Os preguntabai s cuándo lo abriríamos?). Por ejemplo, #LibreOfficeCalc
En el menú archivo elegimos "Abrir archivo remoto"
Habt ihr eine einfache Möglichkeit gefunden, in LibreOffice Calc Zebrastreifen“ unter den Reihen anzuwenden?
Also immer diese abwechselnden Farben pro Reihe?
Da würde ich mich mal langfristig über einen einfachen Knopf freuen.
Aktuell mache ich das über die Bedingte Formatierung und eine Formel.
One feature in LibreOffice that I find SO useful, is the "Export Directly as PDF".
Literally one click and a save window pops up. And the PDF includes ALL unhidden tabs! Nice! Certainly easier than in Excel.
Today I Learned that the `=COUNTIF` function in Excel can use "?" as a placeholder for a single character… I had written `=COUNTIF(named_range,"x")+COUNTIF(named_range,"?")` because some of the cells could be an "x" or a question mark, and getting double counting… changed it to `=COUNTIF(named_range,"?")` and worked like a charm… If one of the cells in the range is empty, or has more than one character, it does not count it! And it is also case insensitive.
Just checked in LibreOffice Calc, and Apple Numbers, and it also works there!
#TIL #TodayILearned #Excel #MicrosoftExcel #LibreOfficeCalc #AppleNumbers #COUNTIF #Spreadsheets #SpreadsheetFormulas
Finally! I figured out some LibreOffice Calc conditional formatting. This makes my spreadsheet much easier to interpret the status of my job applications submissions.
Learning is nice feeling where everything starts clicking together.
Fischfabrikant
foldworks
Dwev
Microblog Castellano
Linux Guides
Marcel SIneM(S)US
AdventureTense
Dr. Juande Santander-Vela
Scooter 
Andrew Woods