Hello!
I use a LibreOffice Calc sheet as my daily calendar and want to stick with that..
https://preview.redd.it/stx9hi08is881.png?width=1627&format=png&auto=webp&s=e45677694d9af69793c2262637ad7d03aa9dcf2e
Now I want to define a few functions, but am not sure what to look for and how to do it.
I want to use the blue column for regular stuff like Birthday Reminders, repetitive maintenance work, that has to be done at a certain date in a certain frequency.
Something like:
- when the date at the beginn of the row is e.g. 30.08.2021 (a friends birthday), then how can I reach that the first column (A), is checked by something like a "if/else" thing...
- how can I define things like the following, in functions that can be pulled down?
I will try to make my goals clear by describing a few examples:
- when the day and month of a date in the A-column (e.g. A10) is "01.05." (1stMay), then put the Text "Joey's Birthday" in the D-cell of the same row. (e.g. D10)
- always when the date in the A-column includes the day "10", then put the Text "monthly appointment with Daniel" in the respective E-cell in the same row.
- always when the weekday in column B is "Mo" (Monday), then put the Text "Pull-Workout" in the respective F-cell in the same row.
I think my goal is quite simple but my head makes it so complicated, that I can't accomplish that...
I appreciate any help of you experienced Office-Users out there :-)
Hope u all enjoy new years eve! All the best and good health to all of u!
Just a heads up.
I've been using Calc for a bit now, and had this issue pop up frequently to the point where it became insufferable. I decided to check around the net only to see this problem popping up here and there with no real solution. Finally, I decided to check and see if the problem was due to me using a clipboard manager--I'm using CopyQ, and lo and behold! It was!
Switched to another clipboard manager and the issue was solved mostly.
If you come across a similar issue, consider checking out what other software you have running along your LibreOffice instance. It might be the source of the problem.
Hi,
I'm using Pomotroid on Linux and while it's good, I don't see an option on checking how much time I spent on one subject or activity in a graph. I had the idea of using Libreoffice Calc to login my time, but I'm not sure how to do this.
So the format would be something like:
Activity|TIme|Date
Is there a template for this or specific formulas I can use?
I am aware that in a previous version of calc, one can use Format > Page > Tab:sheet > Category: Scale > Dropdown: Fit print ranges on number of pages, and set option number to pages: 1. But on version 7.2.4.1, there is no Format > page option. There are "page style" and "print ranges", but neither of them lead to a "fit to page: 1". Any advice? My details as to build and version are below. Thanks for any advice!
Version: 7.2.4.1 (x64) / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
This is really random, and I've only noticed it in the past few months. I record and keep all my checking and credit card receipt totals in a tracking spreadsheet.
Strangely enough, my mobile phone bill is exactly $123.00. Like an auto-fill number - 1,2,3. So when I'm using AutoSum on the current month's bill amounts, the AutoSum will NOT include the value of $123. I first learned of it when my calculations looked correct, but the bank took more out of the auto-pay. I was truly stumped and thought I was going crazy.
Once I figured out the calculation vs payment difference was $123, I got suspicious and pinned it on my phone bill. If I sum each cell individually (I2+I3+I4...), it's all good, but if I use the Auto Sum function, the $123 is excluded!!?!?
It's been 3 months now and it happens without fail. I have deleted the cells, deleted the cell formats, deleted the rows, deleted the columns, tried a different sheet, and I cannot get it to include the $123 in the total.
I'd be happy to share the spreadsheet if anyone can figure it out behind the scenes.
Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
Can anyone tell me how to define a variable and print it out in a cell?
The Design Team of LibreOffice, a free, open-source office productivity software suite, is conducting a survey to learn more about the users of LibreOffice Calc and to understand where the team should focus the efforts to improve the software. The survey consists of questions related to your usage of Calc and its features. It also contains the System Usability Scale (SUS) questionnaire, which we will use to evaluate the usability of Calc. You can access the survey by using the following link: https://survey.documentfoundation.org/773422?lang=en
This is an official post on our blog, advertising the survey: https://design.blog.documentfoundation.org/2021/07/09/help-us-to-improve-libreoffice-calc-by-completing-our-survey/
Thank you for you help.
I really hate coming just to complain. I would willingly pay for a libreoffice calc that actually worked properly. I'm not a coder, I'm not a dev, so I'm sorry, I can't fix this; but it needs to be stated somewhere so that maybe someone who has the ability to do something will ...
Libreoffice is garbage. There I said it. Is it better than having no free spreadsheet software? Yes, of course. But I have a never ending stream of frustration when trying to use it for anything beyond basic stuff.
It's just broken, in so many ways. Any amount of reasonably sized data is going to lag. Simple functions like "=frequency" are just broken, yes fkn broken, as in it doesn't work, not even when I dump the example from help into some cells. And now it decided for some reason to just delete a few tabs when I closed it. EDIT: Okay freq funct isn't exactly broken, I realize that you have to use the function wizard. No hand-coding allowed in cells for that one. Still seems not ideal.
There's so so SO many other things that are just bad. Let's see, when I want to add/remove zeros after the decimal, it doesn't work if I select a column with a header, because it's confused about the fact that the header is not numerical data, and so I have to select JUST the numbers and not the header. Okay this extra step only costs me a few seconds. But it's the evidence of bad design, that the people who maintain it don't even use it. Else something simple like that would be obvious.
Umm, okay deleting columns can mess up calculations because the damn thing doesn't realize that it needs to adjust equations when empty columns are deleted or inserted (YES, even equations where static references using the $ sign are present, because deleting a column is not the same as copy/paste an equation cell).
And there's dozens of other little stuff like that, that's just grrr. It makes using it from annoying to anger, when a simple function like frequency, that should work, just straight up doesn't.
I would absolutely contribute / pay to have a reasonably not crappy spreadsheet software. Again, I'm sorry to come here just to complain, but it's legit criticism, and it needs to be stated somewhere.
Python noob looking for example code to read the numerical values listed in this source text file and populate the corresponding cells in the spreadsheet. I'm guessing I need an array to load the values and then assign each of them to their spreadsheet location?
https://imgur.com/a/jhLyE70 Thanks..
I learned bits & pieces of Excel over the years based on need by asking around & googling.
Now I just discovered ExcelIsFun channel and I just starting from the basics. I am starting off learning data analysis. But I don't have a copy of Excel, so I just using LibreOffice Calc. I have used that app for about 3 yrs at work and found it functionally very similar to Excel. Not sure where it differs. How is calc compared to Excel?
Any other tool to look at?
I did try Jupyter Notebook, but that was just confusing & really drained my system.
I'm slowing moving away from Microsoft and Google, started using LibreOffice regularly like a month, but I'm not familiar with everything on Calc Spreadsheet. I'm wanting some kind of "course" to help LibreOffice first time users get use to Calc that are already familiarized with Microsoft Excel (I would say I'm intermediate to advanced user of Excel).
Hi, I'm having trouble figuring out what I want to do in Calc.
I have a sheet that has a column for dates. There, I used to write "7-7" and the column would automatically change it to say "07/07/2021". I'm unsure what I did that stopped doing this, as I was used to this function in Excel (the sheet in question is an imported version of that program to LibreOffice Calc).
Is there a way to format this so it keeps fixing the dates with only date and month?I have used "Data -> Text to Columns... -> Date (DMY)" but it only formats the dates correctly if it has the year set as well (so 7-7-21). I have a lot of dates to fill so having to write the 21 every time is consuming.
Thank you!
Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: es-AR (es_AR); UI: en-US
Calc: CL
Format: .xlsx
Hi, I have a problem and I hope someone here could help me .I have imported a long single column of data from .txt now I want it to be three shorter columns.Basically like that:
x1 -------------- x1 | y1 | z1
y1 ------------->x2 | y2 | z2
z1
x2
y2
z2
" | " represents a column boundary
I know that there is probably a simple anwser in google but I can't phrase my problem corectly becouse english is not my native language. So any help would be greatly aprecieated
The Design Team of LibreOffice, a free, open-source office productivity software suite, is conducting a survey to learn more about the users of LibreOffice Calc and to understand where the team should focus the efforts to improve the software. The survey consists of questions related to your usage of Calc and its features. It also contains the System Usability Scale (SUS) questionnaire, which we will use to evaluate the usability of Calc. You can access the survey by using the following link: https://survey.documentfoundation.org/773422?lang=en
This is an official post on our blog, advertising the survey: https://design.blog.documentfoundation.org/2021/07/09/help-us-to-improve-libreoffice-calc-by-completing-our-survey/
Thank you for you help.
The Design Team of LibreOffice, a free, open-source office productivity software suite, is conducting a survey to learn more about the users of LibreOffice Calc and to understand where the team should focus the efforts to improve the software. The survey consists of questions related to your usage of Calc and its features. It also contains the System Usability Scale (SUS) questionnaire, which we will use to evaluate the usability of Calc. You can access the survey by using the following link: https://survey.documentfoundation.org/773422?lang=en
This is an official post on our blog, advertising the survey: https://design.blog.documentfoundation.org/2021/07/09/help-us-to-improve-libreoffice-calc-by-completing-our-survey/
Thank you for you help.
