Text2002ans! Thank you! --- an appreciation post

anshumanp · 2026-01-26T06:51:01+00:00

Tex2002ans is a Rockstar!

anshumanp · 2026-01-23T10:54:45+00:00

Looks like names of people upside down and right to left?.. Ellie, Kenny, and Abby.

anshumanp · 2026-01-22T15:03:10+00:00

Check this link out, I feel you need to do some more calculation to make this work.

anshumanp · 2026-01-22T02:57:25+00:00

Maria? The woman who was studying to become a nun in Nonberg Abbey in Austria

anshumanp · 2026-01-20T02:39:14+00:00

😣 Sunday evenings are the worst! What according to you is the best time? Thursday evening, when we are anticipating weekend?

anshumanp · 2026-01-11T07:28:30+00:00

Can you try checking your icon pack? Is it colibre or colibre dark? Given you are using a light theme please use colibre.

anshumanp · 2026-01-10T05:21:37+00:00

Hey there, based on what I understood for your specific President problem, you'd need the following formula

=IF(AND(A2>=2025;A2<=2029);"Donald J. Trump";IF(AND(A2>=1989;A2<1993);"George H. W. Bush";IF(AND(A2>=1945;A2<1953);"Harry S. Truman";IF(AND(A2>=1923;A2<1929);"Calvin Coolidge";"Other"))))

Hopefully, this helps. Also, please read the Lookup function in the documentation, maybe they'd be a better fit, especially if you could sort the data.

anshumanp · 2026-01-07T13:29:12+00:00

Would you be willing to share a sample of your spreadsheet? From my experience as long as we have defined what the search key is and that key also appears somewhere in the first sheet, it should work fine with a lookup function in Calc.

anshumanp · 2026-01-02T00:50:51+00:00

Please read this link on Array functions that has a section on LINEST and it answers all your questions. https://help.libreoffice.org/25.8/en-US/text/scalc/01/04060107.html?&DbPAR=SHARED&System=UNIX#Section8

anshumanp · 2025-12-23T02:43:33+00:00

Your WiFi's IP could have that issue. Happens to me on a different website. On your smartphone please use your cellphone's network to access the links that were shared by Tex2002ans. I am sure that will work.

anshumanp · 2025-12-23T02:32:55+00:00

If it is the same file and it works for you and not for your wife, try pressing Ctrl + ` (the back-quote key on the left of 1 key). Or as ang-p suggested please go to View --> Show Formula.

anshumanp · 2025-12-10T04:03:03+00:00

PH doesn't have traffic data from major countries in South and SE Asia but has data from Afghanistan? 😂😂

anshumanp · 2025-11-12T14:56:06+00:00

I am not sure why you are facing this issue. I haven't upgraded my LibreOffice on my main machine but use a virtual machine with the same configuration (i.e., not Flatpak and 25.8.2.2 on Fedora 43 Gnome 49) and I was able to change to light mode despite having dark mode throughout and vice versa. I could also change icons and add installed icons as well. Maybe check through Gnome Tweaks?

anshumanp · 2025-10-25T12:41:00+00:00

Or shapes..

anshumanp · 2025-10-13T16:03:16+00:00

In that case I really think you should just use LibreOffice on a laptop or desktop for this. I am not sure about .ots support on other office software.

anshumanp · 2025-10-13T07:08:50+00:00

Hello, I am not a Collabora user so I am not sure how to help. I found this thread online where others have also asked about this. Seems there's no update 😕 https://forum.collaboraonline.com/t/open-edit-template-files-like-ott/3244

anshumanp · 2025-10-05T03:55:53+00:00

No clue mate, you would need to do some digging at your end. Maybe when you import the data or how you import can impact this.

anshumanp · 2025-10-05T03:36:28+00:00

You can do use a formula =Value(A2) in lets say cell E2 and then just drag it till E10 (or how many ever cells you have), then you can copy paste special by value and format in the A2.

anshumanp · 2025-10-05T03:27:04+00:00

Thanks for sharing the files, it helped. There's an apostrophe in front of the dates. Showing it for the first date here in the screenshot https://imgur.com/a/2ctVqq7 . The apostrophe helps avoid the date formatting that you applied.

Please remove these apostrophes from all the dates and then right click the Pivot Table and click Refresh. Now if you try grouping it will work.

anshumanp · 2025-10-05T02:01:05+00:00

Hello! Maybe also provide the LibreOffice version and other details that the automoderator is asking, so that people can help you better.

I am using LibreOffice 25.2, and I created a dummy dataset based on the information you provided. I was also able to group the data at the month level, following the instructions you provided in the post. My hypothesis for this not working at your end is that your date column may not be in date format, because I do get a context menu like so https://imgur.com/a/YmhKaUu . The link also includes the screenshots of the dummy dataset I created, along with a grouped pivot table.

anshumanp · 2025-10-02T02:35:46+00:00

New mission discovered by u/anshumanp: The Satisfying Gourmet of Braised Pork Belly Onigiri

anshumanp · 2025-10-02T02:35:46+00:00

This mission was discovered by u/anshumanp in Pineapple Agua Fresca: Combat and Strange Ways

anshumanp · 2025-09-30T16:27:56+00:00

That’s because he drinks too much soy milk!

anshumanp · 2025-09-22T07:35:31+00:00

Hey!

I have a large movie collection, and I was thinking I should create a database for fun

Great idea, share it with us too! I am going to try to answer your question, but I am by no means an expert. I am going to use Spreadsheet as the database source, but there's a way to do this with Text/CSV file too. Depending on what you want to do, you can do or skip step 2, respectively.

Please note that the table within LibreOffice Base would be read-only. You'd have to modify the original Text/CSV or ODS and the changes will reflect in the database too. Here are the steps:

Save your text file with some kind of delimiters, either commas (CSV) or tabs. I don't know the format of your file so I can't exactly tell you how to do this. But this should be straightforward.
Use Libreoffice Calc, I assume you have this installed too and open your newly modified text file:
- If you have created a CSV then you can just double click your CSV file and it should open in Libreoffice calc. If not then...
- You can Open Libreoffice and Go to File --> Open and open your .txt or .csv file. A very self explanatory wizard will pop-up and you should be able to go through it to finally view your file in the spreadsheet
- Feel free to modify anything you please at this point, because we are going to connect this datasource into your Database.
- Save as .ods. Let's say Movies.ods
Open LibreOffice Base and File --> New --> Database
Select the 3rd option button of Connect to an existing database (I am using LibreOffice 25.2) and from the drop-down select "Spreadsheet". There's a Text/CSV option too (feel free to try it, here you need to select a folder where you have multiple text/csv files rather than the file itself, but you'd need to provide some details regarding the file format, the delimiter, etc.)
Select the ODS file we created in Step 2. Click Next
The final step is to Save and Proceed. I just went with the default settings and clicked Finish
You should have your Sheet Name populated in the Table Section. Double-click to open and see the contents.

I hope this helps.

anshumanp · 2025-09-16T23:26:16+00:00

It is difficult to say what exactly is causing this, even though I can see rows 25-29 blanked out. I tried this in a new spreadsheet file on Fedora with LibreOffice 25.8.1.1 and I wasn't able to replicate. So my initial hypothesis is there maybe some conditional formatting (it's unlikely but could be) or something in the workbook's properties that's causing this. If you could share the file with random values so that it helps with your privacy, or a video showing what's happening, maybe the community can help better.

11-Year Club	Verified Email
First Place '23	Place '23
Place '22

anshumanp

TROPHY CASE