Excel doesn’t have to be the default.
With robust performance, excellent compatibility, and an ever-growing list of powerful features, Collabora Online Calc is a true open-source alternative.
🔗 Find out more about your next favourite spreadsheet solution: https://www.collaboraonline.com/blog/why-collabora-online-calc-is-the-excel-replacement-for-you/?utm_campaign=Blog&utm_medium=Social&utm_source=Mastodon&utm_content=Calc
Seeking #recommendations for #alternatives to #Microsoft #Excel. Ideally #FOSS but not a hard requirement. I tried #LibreOffice #Calc and #CryptPad but found their capabilities lacking. E.g., I need something comparable to Excel's tables that allows me to refer to table and column names in my formulas instead of just cell locations. It looks like #SoftMaker can, but they also integrate #ChatGPT, and I'd like to avoid my money helping destroy the #environment and oppress the #GlobalSouth.
Dokumentační tým #LibreOffice vydal příručku #Calc Guide 25.2. Tuto a další příručky si můžete stáhnout ze stránek dokumentace https://cs.libreoffice.org/get-help/documentation/. Český LibreOffice tým pracuje na překladu příručky do češtiny. Hledáme překladatele 🇬🇧, přidejte se k nám!
📊 Desmistificando o LibreOffice Calc 🖥️
O LibreOffice Calc é uma alternativa poderosa e gratuita para criar e gerenciar planilhas. Mas você sabe tudo o que ele pode oferecer? Descubra dicas, truques e recursos que vão mudar sua experiência com planilhas!
👉 Confira no blog: https://nova.escolalinux.com.br/blog/desmistificando-o-libreoffice-calc?utm_source=dlvr.it&utm_medium=mastodon
Ich möchte in Calc ausrechnen: e^A1+e^B1+e^C1, also =exp(A1)+exp(B1)+exp(C1) und so weiter, das aber für viele Zellen A1 bis ABB1 etwa.
Leider habe ich keinen Weg gefunden, das anders als über eine derart lange Formel zu lösen. Klar geht: Kopie jeder Zelle anlegen in Zeile darunter, und das dann summieren, dann muss man nicht tippen, nur kopieren. Gibt es wirklich keine Formel, mit der das einfacher geht?
#Calc #Tabellenkalkulation #Softmax #normalisierteExponentialfunktion
Gelöst, siehe unten!
Any #LibreOffice #Calc wizards out there? I have an Excel sheet converted to ODS. It contained a macro to copy stuff from the selected row to another sheet, then some other sheets would refer to those columns. Was able to convert that just fine.
The pages referring to them have some simple markup as they're used to print a PDF. However, once I open that sheet LibreOffice just freezes and it takes maybe 8 seconds before it responds again. Page has already been rendered correctly.
What gives?
Et alors, comme je trouvais que ça pouvait être un superbe terrain créatif et qu'on n'était pas obligé de se cantonner au manchot , la version 2 du modèle contient les explication pour une variante avec un logo, deux grilles le chaudron de #mageia et le A de la distribution #archlinux plus une grille vierge pour que vous vous amusiez.
La grille vierge, au format ODS est téléchargeable aussi, vous pourrez la modifier dans #calc : il suffit de remplir les cellules de la couleur voulue.
Le logo d'archlinux c'est pour répondre à un troll :
https://linuxfr.org/users/ysabeau/journaux/affichez-fierement-la-mascotte-de-votre-systeme-d-exploitation-favori-dans-les-soirees-mondaines
ok so I'm gathering some steam deck sales data to a LibreOffice Calc sheet with many tabs...
Global Sale and country specific, let's see for how long I'll keep this up...
📊 Desmistificando o LibreOffice Calc 🖥️
O LibreOffice Calc é uma alternativa poderosa e gratuita para criar e gerenciar planilhas. Mas você sabe tudo o que ele pode oferecer? Descubra dicas, truques e recursos que vão mudar sua experiência com planilhas!
👉 Confira no blog: https://nova.escolalinux.com.br/blog/desmistificando-o-libreoffice-calc?utm_source=dlvr.it&utm_medium=mastodon
Se copiate (CTRL-C) un blocco di celle di #LibreOffice #Calc e lo incollate (CTRL-V) dentro #Inkscape questo viene incollato come immagine.
ich habe es befürchtet: Es wurde verschlimmbessert. Die Option findet man nicht mehr in den Einstellungen, sondern als separater Menüpunkt mit neuen extra Einstellungen.
Every time I need to sort some data within #LibreOffice #Calc I notice the missing Table formatting again. That is such a nice convenience feature within Microsoft office.
But also when writing formulas it is kinda annoying because instead of being able to just write "=SUM(A:A)" or better "=SUM(Table1[Column])" you've to write something like "=SUM(A2:A10000)" and hope you remember to extend it once that limit is reached.
How do you write Headers over your data in LibreOffice Calc without this??
LibreOffice calc qui plante avec les formules matricielles, j'suis la seule ou j'fais un ticket ?
Comme je me suis battue comme une diablesse pour que ce soit une formation LOo plutôt que M$Office, si ça plante comme ça, j'vais passer pour une branque.
Je sais éviter le plantage mais mes diants risquent de planter à de nombreuses reprises
📊 Desmistificando o LibreOffice Calc 🖥️
O LibreOffice Calc é uma alternativa poderosa e gratuita para criar e gerenciar planilhas. Mas você sabe tudo o que ele pode oferecer? Descubra dicas, truques e recursos que vão mudar sua experiência com planilhas!
👉 Confira no blog: https://nova.escolalinux.com.br/blog/desmistificando-o-libreoffice-calc?utm_source=dlvr.it&utm_medium=mastodon
Edit: gelöst, siehe https://social.tchncs.de/@ubo/114613805125275262
Ich danke Euch allen!
-----------------------------------------
#followerpowewr zu #LibreOffice #calc
Ich benutze es für einige Dinge, aber meine Kenntnisse und Fähigkeiten liegen nicht wesentlich über "stehts bemüht".
Kann mir jemand sagen, wie es zu dem Dreieck kommt bzw. was LO mir damit sagen will? Änderungen in der Breite der Zellen oder des Zahlenformats bewirken nichts.
📊 Desmistificando o LibreOffice Calc 🖥️
O LibreOffice Calc é uma alternativa poderosa e gratuita para criar e gerenciar planilhas. Mas você sabe tudo o que ele pode oferecer? Descubra dicas, truques e recursos que vão mudar sua experiência com planilhas!
👉 Confira no blog: https://nova.escolalinux.com.br/blog/desmistificando-o-libreoffice-calc?utm_source=dlvr.it&utm_medium=mastodon
Attention #digipres hive mind - I came across quite an intriguing compatibility issue between an old #QuattroPro for #DOS file that uses the VLOOKUP function and #LibreOffice #Calc.
Details + a demo file here:
https://github.com/openpreserve/format-corpus/tree/master/office/spreadsheet/wq2/vlookup-compat-demo
I'm using a fairly old version of LibreOffice (6.4.7.2), so I was wondering if anyone can reproduce this in a more recent version? If so, please let me know, so I can report this as an issue with the LibreOffice devs.
(Also paging @euanc)
#silicium donation
Connaissez-vous Electro Calcul ?
Distributeur méconnu marseillais de nombreuses calculatrices du sud-est asiatique.
La 12PD est de fabrication japonaise du milieu des années 70.
🧮
#retrogaming #retrocomputing #remaking #calc #computer #heritage #toulouse
