Community Member Monday: Ritobroto Mukherjee

Ritobroto Mukherjee

Tell us a bit about yourself!

I live in Delhi, India, where I’m working my way towards a bachelor’s degree in IT with a focus on network security at Netaji Subhas University of Technology.

My journey into programming began with QBASIC in school, sparking a love for coding. Since then, I’ve explored everything from game development to operating system internals, embedded systems to mobile apps – anything that catches my interest. My hobbies include learning random science-y things, binge-watching sitcoms, and working late nights only to fall asleep in the middle of the next day 😛

Before the Google Summer of Code (GSoC), my open-source experience was mostly limited to personal projects. Now, I’m much more comfortable filing bug reports, submitting patches, and engaging in code reviews. I also feel more confident in discussing problems and solutions with people I consider far more knowledgeable than me.

What are you working on in the LibreOffice project right now?

I recently completed upgrading the .NET Bindings for UNO as part of GSoC 2024.

Currently, I’m on a short hiatus for exams and personal projects, but I’ve been chipping away at the next item on my future work checklist: adding support for in-process bridging, thus enabling LibreOffice extensions to be created with the new .NET Bindings.

Why did you choose to join the project, and how was the experience?

Since switching to Linux a while back, I’ve almost become dependent on the LibreOffice suite to get me through university, having used it for everything from assignments to presentations. The chance to give back to this amazing project, to gain the experience of participating in GSoC, and to tackle a complex .NET and C++ project all at once was too good to pass up.

My experience with the LibreOffice community has been nothing but positive, especially with my mentors, Mr. Hossein Nourikhah and Mr. Thorsten Behrens. Their guidance, paired with the freedom they gave me to make my own decisions on the bindings, was integral to the project’s success.

Anything else you plan to do in the future? What does LibreOffice really need?

I’m planning on continuing the .NET Bindings project. While the core of the bindings was completed in time for GSoC, there’s still more features, documentation, and examples to work on.

Additionally, I believe LibreOffice needs more documentation, especially for legacy code. Much of my GSoC time was spent understanding the existing bindings before I could start work on the new ones. Using what all I’ve figured out, I want to try and help the Docs team document the bindings better. I might also consider working on introducing more languages bindings in the future.

Big thanks to Ritobroto for all his contributions! Everyone is welcome to join our community, build new skills, and help to make LibreOffice even better for the whole world 😊

Interview with Phil Shapiro, an outstanding LibreOffice advocate

According to the Library Journal, who has recently awarded him with the Movers & Shakers 2024 Award (the people shaping the future of libraries), in the Educators category, Phil Shapiro

Is an enthusiastic champion of digital inclusion and outside-of-school learning, assisting youth and adults with public Linux computers at the Takoma Park Maryland Library (TPML) and singing the praises of open-source software through his YouTube channel. His advocacy goes beyond library walls, however; he and a group of friends have delivered hundreds of computers donated by community members to families in need. One recipient, then a third grader, learned to touch type 50 words per minute before reaching middle school—and recently graduated from Yale. Shapiro also created Pairs, a paper-based math game, using LibreOffice Calc, and freely distributes it worldwide, with versions for preschool through middle school.

We have asked Phil a few questions, about his experience with LibreOffice, the math game he developed using LibreOffice Calc, and his passion for open source software.

Hi Phil, you received an award from Library Journal magazine for the mathematical game you developed with LibreOffice Calc. Can you tell us why you decided to create this game, and why you decided to do it with LibreOffice Calc?

I decided to create this free, paper-based math game to help families enjoy some recreational math activities around the dining room table. The web site for this game is at http://pairsmathgame.com I use Google Sites, the free web tool, to build this web site.

Over the years, I’ve noticed that 50 percent of the students who visit the public library where I work do not like math. If you’re going to spend hundreds of hours learning math in school, then it’s unfortunate if you do not like math. This game is intended to make math more recreational, spontaneous, fun. It might be particularly useful to grandparents raising grandchildren, where the family can have some fun number related conversations around the dining room table.

In playing this game, I also encourage students to invent their own math questions. This gives them a greater sense of agency. There is no greater thrill for a youth (or adults) than to watch someone enjoy thinking about a question you yourself invented.

My goal is to reduce the percent of students who dislike math. If we, as a society, and reduce that percentage from 50 percent to 20 percent, then the world will be a better place for everyone. We all have a role to play in reaching for that goal. I’ve done my part and I challenge others to do their part – whatever they choose their part to be.

Can you describe the math game to us? Why is it called the Pairs Math Game?

The game is shown as a grid of random numbers. The object of the game is to find two numbers that add up to 100. In the original game, these two numbers needed to live in the same column. While that could be fun for some middle school students, a more open-ended question – more accessible to younger students – is to find two numbers anywhere in the grid that add up to 100. For example, 95 + 5, or 80 + 20, or 50 + 50, or even 98 + 2. I planted more than 20 pairs of such numbers within the random grid, so students have many chances to find a pair.

This grid can be printed on legal size paper (8.5 inches by 14 inches), tabloid size paper (11 inches by 17 inches), in mini banner size – 2 feet by 3 feet, and large banner size (3 feet by 8 feet). All sizes are free for anyone to print and use for any purpose. The banner sizes can also be purchased in a very durable vinyl form from Zazzle.com There is a link from the Pairs Math game web site for people to order the vinyl banner. I receive a small amount of money anytime someone buys a vinyl banner. The vinyl banners can be used outdoors, in the rain, at a picnic. The mini banner fits quite nicely on most dining room tables.

On the Pairs Math game web site, I include a screencast video, made with my Android phone, explaining more about this game. For those wanting to design their own math games using LibreOffice Calc, I explain my methods in this article I recently wrote for Computers in Libraries magazine. https://tinyurl.com/pairsmathgamearticle

You are an educator, and have been working for some 20 years in a library where you help users to use Linux personal computers. In the past, you have written for several technology magazines. How did your passion for open source software start?

I became interested in open source because of my volunteer work as a digital inclusion activist. I’ve been taking donated computers to people’s homes for the past 30 years. I deliver Macs, Windows, and Linux computers. Linux computers are my favorite to deliver because Linux runs well on older hardware. Believe it or not, I got an earlier version of Linux Mint running nicely on a 2002 Dell laptop. People can view this laptop surfing the web in my YouTube video titled: My $20 eBay laptop.

A long time ago, between 1990 and 1994, I ran my own Apple II educational software company. At that time, I benefited a lot from studying the code of other programmers. I sold some of the software I developed to school around the nation. I also designed free educational games, which can now be played in the browser, via an Apple II emulator, on the Internet Archive web site. See https://archive.org/details/Number_Games_1_Phil_Shapiro_1992 and my (previously) commercial Number Squares logic puzzles at https://archive.org/details/NumberSquares and explanatory screencast at https://archive.org/details/NumberGames1

Do you plan to develop other mathematical games, or other educational tools?

Designing games is a fun hobby of mine. Yes, I continue designing variations of the Pairs Math game. I do not ask for anything in return, but if people help spread the word about this game, that is plenty reward for me. I’d love to see this game used in hospitals, prisons, homeless shelters, refugee camps – anywhere that people might benefit from “cognitive solace.” Cognitive solace is when the brain is engaged in something enjoyable – in a way that provides solace for other things happening in their lives.

I have some other free games in development, including one with colorful ping pong balls inside of plastic tubes – and another game with colorful round stickers.

Have you used LibreOffice in any ways that creators of this software might find surprising?

Yes, I love using LibreOffice Draw to do 8K digital storytelling on YouTube. I started experimenting with this before the pandemic, back in 2019. See https://www.youtube.com/watch?v=gsgg4hgjdoY which is a sample video that might be helpful to others looking to do something similar. I’d love to see a creative contest for this kind of thing.

Of the 8 billion residents of planet Earth, I’m probably the only person using LibreOffice to create 8K videos. Being an innovator in that way is just plain fun.

What is your opinion, as an experienced user but somewhat external to the projects, of open source software?

I love open source methods because you bypass the suffocating restrictions encountered with proprietary software. If you can imagine an improvement to an open source software program, you can either code that improvement yourself, or hire someone to do the coding for you. No permission required. For a creative person, such as myself, this lifting of proprietary restrictions is liberating. It literally lets me breathe more freely. For more on how I first came to open source, search the web for my article: “The Day my Mind Became Open Sourced.”

I also believe open source software is a path to building a more inclusive world. A more inclusive world has less violence. One of my inspirations is Bogdan Tancic, from Serbia Wireless. Along with his geek friends in Bosnia, they have built a wireless community network that spans across national boundaries. Step by step, their group is slowly blurring the national boundaries in this strife affected area of the world. Everyone involved in this projects embraces open source software and open hardware. They maintain autonomy and control of their network. This is truly inspiring. About 15 years ago, I shot this short video interview with Bogdan Tancic, at an international wireless community network conference in Columbia, Maryland – not far from where I live. https://www.youtube.com/watch?v=rCVtPcFp14E

I’m also interested in the ways that open source can boost mental health. I share some of my ideas about that in this article I wrote for Opensource.com https://opensource.com/life/14/8/does-open-source-boost-mental-health It’s useful to note that Opensource.com, a project previously funded by Red Hat, has a new home at OpenSource.net, backed by the Open Source Initiative.

As a final note – I’ve composed a few songs that encapsulate my feelings about open source. You can find these on YouTube at https://www.youtube.com/watch?v=0UYGA6ek_nA and https://www.youtube.com/watch?v=WCSQorBmO58 and https://www.youtube.com/watch?v=q_QjA7PgWZs

LibreOffice joined Software Freedom Day celebrations in Nepal 😊

LibreOffice at Software Freedom Day celebrations in Nepal

On September 21, free and open source software (FOSS) enthusiasts celebrated the 21st worldwide Software Freedom Day. Our community members in Nepal were not behind with the celebrations either: they were active supporting small open source communities and connecting them for the greater good in the LibreOffice community. Here’s their report:


Suraj Bhattarai, LibreOffice liaison in Nepal, was available at the LibreOffice booth at the Software Freedom Day celebration by Open Source Klub (NOSK) at Nepal College of Information and Technology (NCIT), Lalitpur.

He described how the LibreOffice booth was so busy and engaging. In particular, the LibreOffice community supported the event with fun games, swag, candies, and engagement – all while advocating for the best free and open source office suite. The booth included amazing LibreOffice merchandise, such as T-shirts, tote-bags, water-bottles, round pin plastic badges, flyers, a variety of stickers, beer mats, candies, and so forth.

LibreOffice at Software Freedom Day celebrations in Nepal

The booth had a LibreOffice crossword game, and showed LibreOffice 24.8 on a display for hands-on testing. There was also a presentation deck for newbies, and some verbal support/assistance to improve the LibreOffice experience and customization for easier navigation within the user interface. Suraj also mentioned that around three quarters of the people who appeared at the booth for a quick “hello” mentioned hearing about or knowing and using LibreOffice in their home or workspace.

LibreOffice at Software Freedom Day celebrations in Nepal

The event was mainly joined by students across Kathmandu valley, open source contributors, club alumni, and veteran FOSS contributors/kickstarters in Nepal. Apart from the event itinerary and other activities, the LibreOffice “paper plane contest” received major attention and everyone seems to have enjoyed their paper plane flight to software freedom!

The winner was awarded a 750ML aluminum water bottle, with the LibreOffice logo printed on it. Suraj concluded the competition with the 3R principle and the analogy of releasing paperwork and transitioning to digital open source office suites for document-related work pieces. The college administration expressed some interest in replacing Microsoft Office and migrating the campus computers to LibreOffice suite.

LibreOffice at Software Freedom Day celebrations in Nepal

Similarly, Suraj also delivered a recorded talk named “Diversity, Inclusion and Community Model in Free Software Communities” at Birendra Multiple Campus, Chitwan. There, the Software Freedom Day celebration was hosted by the Birendra Open Source Club (BOSC) with support from the LibreOffice community.

The aim of the talk was to deepen and bridge the relationship of the club with the LibreOffice community and LibreOffice activities/contributions in the future. Previously, the club contributed greatly to the success of a local event: the LibreOffice Localization Sprint 2023. Achyut Koirala, the acting president of the on-campus club, represented the LibreOffice community there.

While Suraj himself couldn’t be present, Achyut Koirala together with Shreeram Lamichhane communicated the positive feedback from the recorded talk Suraj had shared. As a closing remark, Achyut thanked the LibreOffice community as a whole for the inclusive community model and for welcoming their community into the project.

LibreOffice at Software Freedom Day celebrations in Nepal

And finally, Nirjal Bhurtel, representing LibreOffice’s local community, did the same at Kathmandu University where the celebration was hosted by their own on-campus community. Kathmandu Open Source Community has been the veteran contributor when it comes to the history of contributions from Nepal in the LibreOffice project.

LibreOffice at Software Freedom Day celebrations in Nepal


TDF says: Many thanks to Suraj and the Nepalese community for the great work! And as a bonus, here’s a video from the aforementioned paper plane contest:

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

LibreOffice Community releases the Writer 7.6 Guide in Brazilian Portuguese.

Translated by Timothy Brennan Jr.

Rio de Janeiro, September 26, 2024 – The Brazilian LibreOffice community proudly presents its new edition of the Writer Guide 7.6 , based on LibreOffice 7.6 and with the innovations introduced in this version.

The guide meets the need for LibreOffice documentation in Brazilian Portuguese and the Writer Guide will help all LibreOffice users in editing texts, monographs, theses, reports, minutes and much more.

(more…)

The Document Foundation announces the LibreOffice and Open Source Conference 2024

Berlin, 25 September 2024 – The LibreOffice and Open Source Conference 2024 will take place in Luxembourg from the 10 to the 12 October 2024. It will be hosted by the Digital Learning Hub and the local campus of 42 Luxembourg at the Terres Rouges buildings in Belval, Esch-sur-Alzette.

This is a key event that brings together the LibreOffice community – supporting the leading FOSS office suite – with a large number of stakeholders: large open source projects, international organizations and representatives from EU institutions and European government departments.

Organized in partnership with the Luxembourg Media & Digital Design Centre (LMDDC), which will host the EdTech track, the event is sponsored by allotropia and Collabora, the two companies contributing more actively to the development of LibreOffice; Passbolt, the Luxembourg made open source password manager for teams; and the Interdisciplinary Centre for Security, Reliability and Trust (SnT) of the University of Luxembourg.

In addition, local partners such as Luxembourg Convention Bureau, LIST, LU-CIX and Luxembourg House of Cybersecurity are supporting the organization of various aspects of the conference.

After the opening session in the morning of the 10 October, which includes institutional presentations from the Minister for Digitalisation, the Ministry of the Economy and the European Commission’s OSPO, there will be tracks about LibreOffice covering development, quality, security, documentation, localization, marketing and enterprise deployments, and tracks about open source covering technologies in education, OSS applications and cybersecurity. Another session will focus on OSPOs (Open Source Programme Officers).

The LibreOffice and Open Source Conference Luxembourg 2024 provides a platform to discuss the latest technical developments, community contributions, and the challenges facing open source software and communities of which TDF, LibreOffice and its community are important components. Professionals, developers, volunteers and users from various fields will share their experiences and collaborate on the future direction of the leading office suite.

Policy and decision makers will find counterparts from all over Europe with which they will be able to exchange ideas and experiences that will help them to promote and implement open source software in public, education and private sector organizations.

On 11 and 12 October, there will also be workshops focusing on different aspects of LibreOffice development, targeted to undergraduate Computer Science students or anyone who knows programming, and wants to become familiar with a large scale real world open source software project. To be able to better support the participants we limited the number of seats to 20 so register for the workshops as soon as possible to reserve your place.

Everyone is encouraged to register and participate in the conference to engage with the open source community, learn from different experts and contribute to meaningful discussions. Please note that, to avoid waste, we will plan for food, drinks and other free items for registered attendees so help us to cater for your needs by registering in time.

LibreOffice project and community recap: August 2024

LibreOffice project and community recap banner

Here’s our summary of updates, events and activities in the LibreOffice project in the last four weeks – click the links to learn more…

  • The biggest news in August was the release of LibreOffice 24.8. This is our latest major stable branch – and the second to use the “year.month” version number scheme. It has a ton of new features, improvements and fixes, some of which are shown in this short video (PeerTube version here):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

LibreOffice Conference 2024 banner

  • In other conference news, we announced that the Luxembourg Media & Digital Design Centre is co-organising it. This is an Economic Interest Grouping gathering the Ministry of Education, Children and Youth (MENEJ), and the Ministry of Higher Education and Research (MESR), and the Luxembourg Institute of Science and Technology (LIST), created to support national activities related to digital learning and to operate service and innovation platforms.


Luxembourg Media & Digital Design Centre logo

  • Next, we spoke to Khushi Gautam who is currently working on fixing bugs in her LibreOffice Outreachy project, “Sidebar Deck for Quick Find”, alongside Google Summer of Code students to make further progress.

Khushi Gautam

LibreOffice in Microsoft Store

  • The Document Foundation (TDF) is the non-profit home of LibreOffice, and its Membership Committee (MC) administers membership applications and renewals following the criteria defined in the Foundation’s Statutes. An election for a new MC is coming up, and in August we ran three live “townhall” Q+A sessions with the candidates. Recordings from two of them are online (PeerTube versions here and here):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

LibreOffice stand at FrOSCon 2024

Gladys David

LibreOffice Getting Started Guide 24.8


LibreOffice Asia Conference 2024 in Taipei

Keep in touch – follow us on Mastodon, X (formerly Twitter), Bluesky, Reddit and Facebook. Like what we do? Support our community with a donation – or join our community and help to make LibreOffice even better!