@cmconseils tell them to simply stop applying #spreadsheets for tasks it is NOT designed for:
:ReplyNo: database
:ReplyNo: data archive
:ReplyNo: number crunching
#excel #librecalc

#LibreOffice #LibreCalc #Calc Trošku nepříjemné je toto:

So, exporting 73Kb ODS document (several sheets with one small table on each one of them) into XML in #LibreCalc results in 439Mb file.
#Vim basically dies on this file. #Emacs opens it instantly. I can even navigate it freely and syntax highlighting works. Although it doesn't help much.
Here's a catch:

me@desktop:~/temp$ wc -l file.xml
1 file.xml

It's a 439 Mb long line.
I have no idea what's wrong with LibreCalc.

I use my #remarkable as a calendar. Therefor I build a #librecalc documents that exports a weekly calendar as PDF. It has links and stuff. It is currently only in German and works in school years (Summer to Summer). Version for the PRO. Version for the move in development?

Is somebody interessted in this stuff, so I should create a yearly version and add the possibility for localisation? Put it on Codeberg?

The move seems to be a good size for a calendar :)

It's funny that, in this seemingly golden age of GenAI, getting common spreadsheet applications to correctly recognise dates remains such a collosal pain in the ****. Argh!

#Excel #GoogleSheets #LibreCalc

I tried. I really, really tried. But #librecalc is bad. Especially using conditional formatting with multiple rules.

I'm sad because I really like #librewrite and hoped Calc would be of similar quality.

I think I have to go back to Google Sheets which is definitely better than Excel for anything other than really large spreadsheets.

When saving a text file spreadsheet in #LibreCalc / #LibreOffice or #FreeOffice / #PlanMaker, is there a way to coerce it into not quoting the text fields?

Ordinarily I would want the text fields quoted, but not in this case.

#askFedi

@jauzfaktnevim.cz Ano, setkal jsem se např. s tím, že v LibreCalc chybí některé sofistikovanější statistické funkce. Já ale nejsem vědec a pro moje každodenní použití mi funkčnost #LibreCalc bohatě stačí.

V Excellu mi přijde šílené, že se mění názvy funkcí podle toho, jestli jazykem prostředí je čeština nebo angličtina. Taková pitomost nemá v žádném programovacím jazyce obdoby. K dovršení zmatku některé funkce ani český název nemají (pokud jsem to dobře pochopil).

Microsoftí produkty ve všech podobách používám pouze pod (často nevybíravým a agresivním) tlakem svého okolí (nejsem ostrov, musím nějak spolupracovat s lidmi fungujícími v reálné ekonomice..).

Třeba na současném notebooku jsem si ponechal možnost dualboot do Windows (když už tam byly), ale nevyužil jsem jí ani jednom. Offline #Excell (mimo webovou verzi toho v rámci webového #Office365) naštěstí k ničemu nepotřebuju.

#libreoffice

Quick! Somebody uninvent VLOOKUP!

#vlookup #libreCalc #excel #spreadsheets

UPDATE: question answered! thank y'all.

can somebody who understands #spreadsheets and shit please #help me with a #librecalc question. #boosts appreciated.

I'm sorry but why is #LibreCalc still absolutely useless? One cannot even simply define the first 3 rows as header rows??

@popsci
Here to add #LibreCalc. In fact #LibreOffice. Better than both, runs on either Linux or Windows, and free. #FOSS

CSV mit #Excel öffnen: "Hier: Datenmatsch. Hättest Du Deinen Scheiß mal in .xlsx gespeichert, Depp!!"
CSV mit #LibreCalc öffnen: "Hier hast Du Deine wunderbaren Daten in einer Tabelle - so wie Du es sehr wahrscheinlich wolltest. Ich hoffe, es ist alles richtig."
#openSource

any #libreoffice #librecalc #excel #regex hero on here? I'm looking for a regex to add a space between smth like this test'blablah' I need the white space like test 'blahblah'

@egoebelbecker frustrating, isn't it? I find #LibreOffice and, of course, #databases like #SQLite do better here. Other spreadsheets (like #LibreCalc) certainly have the potential to munge things like this, but #Excel's defaults make it particularly likely to.

Hi #FOSS !

Is there a good foss tool to make simple checklists ?
Or should I just use #LibreCalc ?

@luke

"Spreadsheet calculator improved" (fork of the discontinued sc) also stores it's spreadsheet files in a plaintext format.

Plus, it runs in the terminal.

https://github.com/andmarti1424/sc-im

#tui #spreadsheets #foss #excel #librecalc

One thing that @libreoffice does definitely better than Microsoft Office is handling CSV files. When you open them in LibreCalc you get asked directly how the data should be displayed which is really cool.

#LibreCalc #LibreOffice #CSV