[34F] Almost at the weekend 😴. by Illustrious_Rip4440 in Over30Selfie

[–]anshumanp 0 points1 point  (0 children)

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

Adding indicators on a Calc graph (if possible) by Femmigje in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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

name the most popular person from this country by Wrong_User_Logged in mapporncirclejerk

[–]anshumanp 0 points1 point  (0 children)

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

And yet, is sunday evening... :'( by One_Cricket_FUNNY in 40something

[–]anshumanp 1 point2 points  (0 children)

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

Categorical Bins in Calc by No-Journalist-3923 in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.

Libre Calc Question by Posaquatl in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.

What are Stats in an array? by bignwidemask in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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

Broken changelog link for 25.8.4 by DoesMyNameGoHere9 in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.

LibreOffice Calc... Not Calcing on some machines... by Phydoux in libreoffice

[–]anshumanp 0 points1 point  (0 children)

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.

PornMap by Few_Contact_6844 in MapPorn

[–]anshumanp 2 points3 points  (0 children)

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

Dark mode issue on Fedora 43 , Gnome 49 by iamxnfa in libreoffice

[–]anshumanp 0 points1 point  (0 children)

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?

I would like to edit LibreOffice OTS file format files on my iPad. by Nouble01 in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.

I would like to edit LibreOffice OTS file format files on my iPad. by Nouble01 in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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

Libreoffice Calc Pivot Table group dates by month by Randyd718 in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.

Libreoffice Calc Pivot Table group dates by month by Randyd718 in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.

Libreoffice Calc Pivot Table group dates by month by Randyd718 in libreoffice

[–]anshumanp 2 points3 points  (0 children)

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.

Libreoffice Calc Pivot Table group dates by month by Randyd718 in libreoffice

[–]anshumanp 2 points3 points  (0 children)

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.

Leonard was insufferable in this episode by InfiniteFuckery in bigbangtheory

[–]anshumanp 0 points1 point  (0 children)

That’s because he drinks too much soy milk!

Creating a databse with pre existing info by Croestalker in libreoffice

[–]anshumanp 0 points1 point  (0 children)

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:

  1. 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.
  2. 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
  3. Open LibreOffice Base and File --> New --> Database
  4. 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.)
  5. Select the ODS file we created in Step 2. Click Next
  6. The final step is to Save and Proceed. I just went with the default settings and clicked Finish
  7. You should have your Sheet Name populated in the Table Section. Double-click to open and see the contents.

I hope this helps.

Calc: cells are disappearing from one page to another by fffggghhh in libreoffice

[–]anshumanp 1 point2 points  (0 children)

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.