#LibreOffice Calc

[netscapenavigator-official]

Currently trying to figure out how to make a calculator in LibreOffice that can take the "yes or no" answers of four questions and turn them into values for this horrendous formula I've mustered up:

(B1+G1(D1*C1)/P)+(B2+G2(D2*C2))=F

But I've never used spreadsheet formulas outside of basic adding, subtracting, multiplying, dividing, etc., so using IF/ELSE statements in a LibreOffice Calc document terrifies me. I barely know any Swift from Apple's Swift Playgrounds, but I feel like I could write a better script in Swift than the monstrosity I'm about to make in LibreCalc.

[berf-a-smurf]

Doing some data analysis for funsies and found out I surpassed the $1000-spent-on-Steam milestone on Christmas!

[wavdsteen]

LibreOffice nader bekeken

Veelal wordt er gebruik gemaakt door het Office pakket van Microsoft, echter LibreOffice is net zo goed, zo niet beter, maar wat heeft het allemaal, we gaan een kijkje nemen in het pakket. LibreOffice het pakket wat je moet hebben Laten we eerlijk wezen, het pakket heeft één voordeel ten opzichte van het populaire Microsoft Office pakket, en dat is dat het gratis is.En alleen dat al zou een…

[kinhagamer]

[Tutoriais/Dicas] Como realçar células duplicadas (Excel/Google Sheets/LibreOffice Calc)

Acredito que o Excel traz a forma mais fácil de realçar as células duplicadas (e também a forma mais fácil ee removê-las) enquanto o Google Sheets traz a forma mais complicada ou trabalhosa, vamos a elas. Google Sheets / Google Planilhas Selecione a coluna que deseja realçar as células duplicadas. Clique no menu Formatar Clique em Formatação condicional Quando você clica em Formatação…

[naomithegiraffe]

the keyboard on my laptop just randomly stopped working last night and i was worrying really hard that id end up having to replace it if it wasn't something simple to fix, but just now i was using it with a usb keyboard and i fired up my spreadsheet program and the keyboard just suddenly started working again??? idk what the fuck happened but ill take it, this laptop isn't even 4 years old

[brassaikao]

解決 Excel, Calc 無法用上下左右方向鍵切換儲存格的問題

鍵盤上有一個很少人使用的 [ScrLk] 或 [Screen Lock] 按鍵，透過它可以切換是否鎖定游標所在的位置，並透過方向鍵移動整個畫面。當然，若是不知情的狀況下按到，就會變成無法巡覽切換儲存格的問題…😅

[pulipuli]

看看網頁版全文 ⇨ 在LibreOffice Calc直接貼上 / Paste without Import Option Dialog in LibreOffice Calc https://blog.pulipuli.info/2023/04/blog-post_456.html 忽然想起來自己為什麼很少用LibreOffice Calc的原因orz。 ---- # 輸入選項 / Inport Options。 要將剪貼簿的資料貼上到LibreOffice Calc的時候，大多情況下都會跳出Import Options對話視窗，詢問你要將資料視為什麼類型。 一般情況下我們都會保持預設值Automatic，按下「OK」即可。 如果將「Keep asking during this session」取消打勾，那下次貼上的時候就不會跳出這個對話視窗了。 但這也太麻煩了吧。 我自己習慣在貼上之後調整資料類型。 這種每次貼上都要詢問的操作，其實還蠻令人困擾的。 https://askubuntu.com/a/1133466。 跟我有類似困擾的人似乎還不少。 有人的做法是按F2進入編輯模式，然後再貼上，這樣就可以略過Import Options的對話視窗。 但是，有沒有更簡單的做法呢？ # 修改Ctrl + V的操作 / Modify Ctrl + V。 後來我找到比較理想的做法是在Customize中修改鍵盤快捷鍵所執行的指令。 原本Ctrl + V預設執行的指令是Paste，我將它改為了Paste Unformatted Text。 要注意選擇好後還要按下「Modify」，才能儲存快捷鍵跟指令的配對。 這樣就能直接貼上了喔。 ---- 文章最後要問的是：你在操作LibreOffice Calc的時候，還有遇到其它問題嗎？。 歡迎在下面留言喔！ ---- 看看網頁版全文 ⇨ 在LibreOffice Calc直接貼上 / Paste without Import Option Dialog in LibreOffice Calc https://blog.pulipuli.info/2023/04/blog-post_456.html

[kesbeacon]

Shoutout to this one rando internet poster's rando Grandma; I read a post where this person was setting up a computer for their grandmother, explained how it worked, and so on, and then got a call a week later from their indignant gran saying, "Why didn't you tell me about the knitting program?!?!"

Poster says, what knitting program? And she says, it's got lots of little boxes and you can colour them and put things in them. And when they go over to look - it's Excel. She's shrunk the Excel cells and is making knitting patterns in Excel.

Anyway. I now (for the last several years) make all my knitting patterns in Excel*, because if you use conditional formatting then it's extremely powerful. Type 'a' in a cell and it turns a colour; 'b', a different one.

Behold, a simple example.

Can't show you what I'm working on but it's EnormousTM.

And you can just arrow key up and across, row by row; hit save before closing and it'll even save your place.

Also, you can calculate your knitting maths with it.

Random grandma, if you're out there, I owe you one. Call me. We can swap tips and tricks.

*LibreOffice Calc also works but is a little more annoying to use.

[sigmaleph]

today i was deeply annoyed i couldn't find a fill down button in gsheets so i'm cranky about it

[trax99c]

how to leave spotify for good

it takes a bit of time and is less convenient than using spotify. this guide is for people with some computer knowledge and strong anti spotify ideology.

step 1: go to chosic.com and select tools > spotify playlist explorer

step 2: link your playlist or log in to get all of your liked songs. export as CSV

step 3: open the file in a program like excel or libreoffice calc. now you can sort by each column to easily see your frequent artists, albums, etc. not required but its fun

step 4: if you have a low number of songs or want to curate them more, you can manually find the ones you want to download. OR

search "csv to youtube"; for fewer songs you can use a site that comes up, for more songs use a github script (i'll update this when i try some, maybe make a guide if a lot of people want it)

step 5: remember to use ublock origin on firefox browser or newpipe app on android - newpipe allows downloads also. i don;t know any ways for iphone sorry

step 6: prepare yourself for minor inconveniences and missing out on the spotify wrapped craze at the end of the year... use last.fm if you want to track your listening stats

step 7: support artists you like by buying their stuff on bandcamp, buying merch, going to concerts (if affordable for you and not run by Big Concert). even just giving them $5 is more than they would see if you listened to their song over 1600 times on spotify

notes: - you can substitute "youtube" for other music providers like deezer. or other things. wink - you may have to do some editing in excel depending on the script you use if there are too many fields - if chosic stops being free let me know and i'll look for another site or search "spotify playlist/likes to csv" (there might be better tools for public playlists but if you want to export all your likes you'll need a tool like this that you login to)

[wardensantoineandevka]

god, I just want an offline spreadsheets program that works just as well as Excel does, and no, LibreOffice Calc does not work as well

[radfem-polls]

Polls List

Finally it is done.

Here is a spreadsheet with all the polls on it. Why did I do this?

Tumblr's search function is shit

some questions have been asked many times and this may be an easier way for people to get that info instead of asking again (repeat questions don't bother me but some may genuinely not know they have already been asked)

Spreadsheet autism

I'm thinking about maybe updating this every month or so. You may notice the last entries are missing some info such as number of votes and winning answer, these are because they are still running. Open ended question answer responses were recorded as the total number of reblogs and replies on the post.

Please be aware there may be sensitive topics, sexually explicit questions, talking about violence and rape, and questions surrounding drug use on this spreadsheet (posts are behind "mature" community label, but the questions are in plaintext on the spreadsheet), use your discretion

Link to the spreadsheet (google sheets)

How to make a copy of the spreadsheet to your google account:

A link to a webpage on how to download the spreadsheet to your computer

Libreoffice calc, a free open source alternative to microsoft excel if you want to run it on your computer and not google

[eslamdahab-dhb]

Look at open-source software.

Here are some examples:

Ableton Live ➔ Reaper, LMMS, Ardour

Adobe After Effects ➔ Natron

Adobe Animate ➔ OpenToonz, Tahoma2D, Pencil2D

Adobe Audition ➔ Audacity

Adobe Dreamweaver ➔ Blue Fish

Adobe Illustrator ➔ Inkscape

Adobe InDesign ➔ Scribus

Adobe Lightroom ➔ Darktable

Adobe Photoshop ➔ GIMP, Krita

Adobe Premier ➔ Olive, Lightworks, Kdenlive, Shotcut

AutoCAD ➔ OpenSCAD, LibreCAD, FreeCAD

Corel Draw ➔ Inkscape

Corel Painter ➔ Krita, MyPaint

Matlab, Mathematica, Maple ➔ GNU Octave, Scilab, FreeMath, wxMaxima, Sage Math, GeoGebra Classic

Maya, 3dsMax ➔ Blender

Microsoft Excel ➔ LibreOffice Calc

Microsoft Office ➔ LibreOffice, OnlyOffice Desktop Editors

Microsoft Powerpoint ➔ LibreOffice Impress

Microsoft Visio ➔ Dia, LibreOffice Draw

Microsoft Windows ➔ Linux Mint, Pop!_OS, and any other Linux distribution

Microsoft Word ➔ LibreOffice Writer

OneNote ➔ Joplin, XJournal++, Zim

Outlook ➔ Thunderbird

Pinnacle Studio or any Video Editing Software ➔ Kdenlive, Shotcut

Unity, Unreal, GameMaker ➔ Godot, Love2D