#librecalc — Public Fediverse posts

Sorted, Vlookup it is!

#Libreoffice #librecalc gurus, I need your help.
I've been out of the spreadsheet loop for nearly 2 decades (stay at home parenting)
I have 4 and a half years worth of data readings I want to play around with, sadly they're not taken at regular intervals.
Is there a quick way of padding out the dates in-between (preferably daily spacing) that doesn't involve having to manually insert new lines to do so?

I'm also dyslexic (yay!), so a video tutorial would be better

Then I completely changed the way I have students submit comments. Now I use Nextcloud forms, and instead of creating a new sheet for each class meeting, I have all the comments for the quarter in one sheet. It works fine, but I have no idea how to get an average length for the responses of each student. Does anyone know how to do such in thing in #LibreCalc ? There is a column for respondents to type in their student IDs and another column where they write comments. #Spreadsheet #LibreOffice

A few years ago, I was asking for help in counting the number of characters in responses so that I could get the average response length for each respondent, and some power user gave me a miracle formula that only had to be pasted in the top cell of a column. It started "=let" and included stuff like "wraprows" and "reduce" and "lambda" and "Σ." I never understood it, but it worked for me then and I used it for several years. (cont) #spreadsheet #LibreCalc #LibreOffice

Are there any #Nextcloud #Forms power users on here? There does not seem to be a dedicated support or community forum for Forms, just the GitHub page, and when a regular user asks a question on a GitHub page they tend to be immediately attacked basically for not being a programmer.
I have new questions about Forms on a regular basis, but what I want to know right now is if it's possible to reference data in a separate workbook. This is not hard in most #spreadsheet apps, including #LibreCalc.

@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

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 :)

@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

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

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

@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