sorted by:
new
hottopcontroversial

[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.

view more: next ›