The Document Foundation Planet

 

July 14, 2020

Official TDF Blog

Announcing elections for the next TDF Membership Committee

Franklin Weng from The Document Foundation’s Board of Directors writes:

Dear Community,

we hereby officially announce the upcoming elections for the next Membership Committee of The Document Foundation.

As per § 12 II of our statutes (binding version in German and non-binding translation), the Membership Committee’s term lasts two years. The current Membership Committee started its duty on September 19, 2018. Therefore, the old Membership Committee remains in charge until the end of September 18, 2020, so the new MC will be in charge the day after that, which is September 19, 2020.

That upcoming term will then (regularly) end on September 18, 2022, so the next election of the Membership Committee will take place before.

As per § 6 III, only members of the Board of Trustees of The Document Foundation, as well as current members of any of its bodies, are eligible to be elected into the Membership Committee, and the election is overseen by the Board of Directors (§ 12 II).

The active electoral right is reserved to those who have been members of the Board of Trustees before this announcement (§ 12 II).

§ 6 III also states that members of the Board of Directors or their substitute members may not be members of the Membership Committee and vice versa.

There is one more notable limitation: Per § 8 IV of the statutes, a maximum of 1/3 members of the Membership Committee is allowed to work on an employment basis for the same company, organization, entities, affiliates or subdivisions.

Nomination of candidates fulfilling the above requirements, as well as self nomination is welcome. In total, at least five members of the Membership Committee are required, and given there are enough candidates, up to four substitute members can be elected based on the last board decision on this matter.

Re-election of current members of the Membership Committee is explicitly permitted (§ 12 II).

Please send nominations and self-nominations via e-mail to elections@documentfoundation.org (which reaches the Board of Directors in private) and also (!) to board-discuss@documentfoundation.org (which is a public mailing list).

We kindly ask nominees who would like to stand for elections to provide a statement of up to 75 words – longer statements will be cut off at the maximum – on their candidacy as continuous text (so no bullet lists or multiple paragraphs). In addition, you have to provide your full name, e-mail address and your corporate affiliation, if any, and please announce that you will provide information on all future changes as soon as possible. Specifically, it is necessary to indicate all information regarding § 8 IV of the statutes.

Discussions with the candidates and questions to them as well as questions about the elections should take place on the public board-discuss@documentfoundation.org mailing list. For details on how to use the mailing list, see https://www.libreoffice.org/get-help/mailing-lists/

Eligible voters will receive further details via e-mail prior to the start of elections, including a summary of the candidates, details on how to access the voting system, and instructions on how to independently verify the vote count. Please ensure we have your recent and correct e-mail address on file. For questions, you can reach the Board of Directors in private at elections@documentfoundation.org

Following the time line set forth in § 12 II, requiring a 45 day advance notice, we hereby announce the following time line for the elections:

(00:00 is beginning of the day, 24:00 is end of the day)

  1. (no later than) Friday, 2020-07-17: announcement of the election; and start of the nomination phase
  2. Thursday, 2020-08-27, 24:00 CEST/UTC+2: end of the nomination phase (one week before the election starts, as per § 12 II)
  3. Friday, 2020-09-04, 00:00 CEST/UTC+2: official start of the elections (at least 45 days after announcement of the election, as per § 12 II)
  4. Thursday, 2020-09-10, 24:00 CEST/UTC+2: end of the election
  5. Friday, 2020-09-11: announcement of the preliminary results and acknowledgement of role
  6. Saturday, 2020-09-12, 00:00 CEST/UTC+2: start of the challenging phase
  7. Tuesday, 2020-09-15, 24:00 CEST/UTC+2: end of the challenging phase
  8. afterwards: official announcement of the final results
  9. Saturday, 2020-09-19: new Membership Committee officially in charge, and election of a Chairperson from among its members

Be advised that the newly elected Membership Committee will only be in charge beginning from September 19, 2020.

Challenges to this election announcement with respect to the deadlines outlined have to happen no later than seven (7) days after this announcement, via e-mail to elections@documentfoundation.org (which reaches the Board of Directors in private).

Challenges to the preliminary results of the election have to happen until the deadline set forth above, via e-mail to elections@documentfoundation.org (which reaches the Board of Directors in private).

On behalf of the Board of Directors,
Franklin Weng

by Mike Saunders at July 14, 2020 08:18 AM

July 13, 2020

Official TDF Blog

Community Member Monday: Khairul Aizat Kamarudzzaman

Today we’re talking to Khairul Aizat Kamarudzzaman from our Malaysian community. He’s a long-time fan of free and open source software, and is helping with LibreOffice advocacy and marketing…

To start off, tell us a bit about yourself!

I’m from Kuala Lumpur, Malaysia. I started exploring and using FOSS way back in 2004 (Debian, Red Hat, the BSD family and sticking with Ubuntu till today) when I was studying at the university. From there I started exploring and contributing to Ubuntu, which you can find here, and I was accepted to be an Ubuntu Member, Kubuntu Membes (merits as Ubuntu contributor). Finally I was appointed to be part of the Asia Oceania Membership Board.

A a FOSS community member, I work in a few IT companies in Malaysia and was one of the engineers working at Open Source Competency Centre (OSCC) under Malaysian Administrative Modernisation and Management Planning Unit (MAMPU). Now I own my own IT company, namely Informology Sdn Bhd. Not stopping there, I continue actively being a FOSS enthusiast in Malaysia. When the cloud computing era came, I was involved by leading Malaysia OpenStack User Group, and I’ve recently been exploring and leading the Endless OS user group for Malaysia.

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

I started the LibreOffice Malaysia Group on Facebook, and I’m planning with the group to finish the LibreOffice Malay translation as soon as possible, with guidance from the Indonesian LibreOffice translation team – so that we can have Malay language support in LibreOffice and Collabora Office.

Why did you decide to become a member of The Document Foundation?

It’s in line with what I’ve done since I started using FOSS: open source advocacy targeted at students, teachers, government staff and the open Source community members in Malaysia. I especially focused on Linux, and office automation like LibreOffice and Collabora Office as an alternative to Microsoft Office. Then, last year in 2019, I managed to participate in the Gnome Asia Summit 2019 in Surabaya, Indonesia where I met a lot of FOSS enthusiasts who are advocating and spreading open source in Indonesia, along with a few awesome TDF members (Ahmad Haris), TDF Board member (Franklin Weng) and GNOME Foundation Staff.

So I asked myself… since I already pitching the Open Document Format (ODF) since I was in OSCC, why not start contributing more to LibreOffice by doing translations? So I challenged myself by applying to become a TDF member, with advice from Ahmad Haris and Franklin Weng.

Anything else you plan to do in the future?

Keep spreading and marketing LibreOffice in Malaysia – especially in the government and educational sectors. Give these sectors LibreOffice as an alternative, by not using piracy and a cracked version of Microsoft Office.

Maybe the LibreOffice Malaysia group can suggest to TDF to host the LibreOffice Conference in Malaysia one day in the future!

Thanks Khairul! And indeed to everyone in the Malaysian LibreOffice community. Your work is essential to help spread awareness of LibreOffice across the globe.

Join the LibreOffice community today! Have fun and build up your skillset…

by Mike Saunders at July 13, 2020 10:05 AM

Ahmed ElShreif

Week 6 Report

Hello all,

The last week was the 6th week of coding weeks in GSoC program. I continued adding support for the non supported items.

 Report in points:
  • Finalize the 5 patches that still under review by solving any comments .
  • Add support for "ToolBox" Objects for example" "bottom find bar" .
  • Add demo for "bottom find bar" using ToolBox support .
  • extend the ComboBox UIObject .
  • patches status.
=====================================

1) The last week I left 5 patches without merging. They are mainly the patches that add support for Calc-comments and Vertical Tab Control. Also the patches of the Calc-comment demo , Writer-comment demo and insert hyperlink demo. The five patches now are merged after working on solving all the comments. The patches can be found in patches status section in the report .
=====================================

2) I also This week worked on the "bottom find bar" item from the list of unsupported items. After working with this bar I found that it wasn't work because of 2 reasons. First Reason was that the FindBar has no id when it's defined. Which can be solved by this change. The second was that we don't have support for toolbox objects which added in this patch.

this patch will help us in testing any ToolBox Objects by this lines :
>> variable_name = MainWindow.getChild(Bar_name)
>> variable_name.executeAction("CLICK", mkPropertyValues({"POS": poition_x }))
For position_x you just put the id of which entry in the ToolBox do you want to press on it . Also This patch set the ID of the bottom find bar to be "FindBar" to be able to select it in UITests .

The video here show how the find bar can be used now:


=====================================
3) I worked also in adding  test case for "bottom find bar" using ToolBox support . The test case tests the Find Bar in searching for all matched words the navigate between the matched words. the test case can be found here in this patch.

=====================================
4) I worked also in extend the ComboBox UIObject. As ComboBox UIObject can be treated as Edit UIObject so this minor change will let us do all Edit UIObject actions on the ComboBox UIObject if needed . So now you will not only be able to select or type from the ComboBox But also you will be able to SET Text and CLEAR the text. the work will be found in this patch .

=====================================
5) patches status:
=====================================

Next week Tasks:
  • Finalize the 3 patches that still under review by solving any comments.
  • Work on another unsupported item.

Thanks for reading. And I am really interested to hear all your feedback and comments.

by Ahmed ElShreif (noreply@blogger.com) at July 13, 2020 04:10 AM

July 12, 2020

July 09, 2020

Michael Meeks

2020-07-08 Thursday

  • Mail chew; interested to see Open Usage announced for holding and managing FLOSS trademarks in a light-weight way. If it can reduce the galloping bureaucracy and the risk of in-fighting that can come with formal governance structures, as well as avoiding the extraordinarily overheads of formal entities, that sounds rather positive. Just having the pleasant, collegial engineering relationships in a project without the overhead would be great. Then again, I guess SFC, SPI, Public Software and others already provide nice containers for projects with varying degress of flexibility, lets see what happens.

July 09, 2020 10:56 AM

Official TDF Blog

Marketing plan draft: Discussion about options available, and timetable

Lothar Becker, Chairman of The Document Foundation’s Board of Directors, writes:

Dear community,

thanks for the feedback on the marketing plan draft via different channels so far. We want to let you know and have you take part, as the board is discussing the options now available with that draft.

In the meantime, some more feedback will be integrated in the document already and will be published on next Monday. This is still not the last chance for a change for version 7.0.0, but we will reach that point soon.

The last change for all strings and tags would be possible the latest by Monday, July 20. With some preliminary phase for decision making of the board the public feedback phase on all this will end by the time of the next public board call, i.e. Friday, July 17, 1300 Berlin time.

What are the realistic options so far:

  • Variant 1: Implementation of a marketing plan would be postponed to V7.1, as no UI changes can be made in minor releases. This would imply a longer discussion period.

OR

  • Variant 2: Implementation of the marketing plan draft with V7.0.0 with flavour tags.

At the moment it looks like, this would be called “Community Edition” (in change to the RC1) and with the introduction of the umbrella brand “Enterprise Edition” with explanations and pointer to ecosystem partner offerings.

The feedback here we still need until the mentioned Friday, July 17, 1300 Berlin time is about all strings and tags (e.g. “Community Edition”), you can give that on the board-discuss mailing list, or on Bugzilla.

OR

  • Variant 3: As variant 2 above and further tweak all strings and tags for V7.1, after gaining experience and more feedback with it from V7.0.

We encourage all the community to bring in your opinions further, also on the public board call (Friday, July 17, 1300 Berlin time), and all the other channels. Please be aware, that any sort of decision of the board must be made the latest at the dates stated above.

Thanks so much for your input so far! All the best, and keep healthy!

Lothar,
Chairman of the Board

by Mike Saunders at July 09, 2020 10:14 AM

Quick video tutorial: Starting LibreOffice and its modules on Windows 10

Videos created by our community are a great way to spread the word about LibreOffice, and help new users to get the most out of the software. This video, from Harald Berger, summarises the different ways to start LibreOffice 6.4 – and its various modules – under Windows 10:

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.

by Mike Saunders at July 09, 2020 09:06 AM

July 08, 2020

Michael Meeks

2020-07-08 Wednesday

  • A morning of marketing bits; catch up with Paolo, admin and community mail reading.

July 08, 2020 09:00 PM

LibreOffice QA Blog

QA/Dev Report: June 2020

General Activities

  1. Adolfo Jayme Barrientos, Steve Fanning, Gábor Kelemen, Olivier Hallot (TDF) and Johnny_M made many Help improvements and cleanups
  2. Jan-Marek Glogowski improved the Writer comments ruler UI control and fixed a few Qt-related issues
  3. Tomaž Vajngerl (Collabora) implemented searching inside PDFs inserted as a graphic and added support for reading annotations in PDFs
  4. Chris Sherlock did graphics-related refactoring work
  5. Mike Kaganski (Collabora) improved the look of soft edges and shadows in slideshows
  6. Martin van Zijl added the ability to reset standard filter in Calc
  7. Luboš Luňák (Collabora) continued with the Skia graphics engine integration and improved the performance of undo operations in Calc
  8. Xisco Faulí (TDF) made over 40 additions and fixes to unit and UI tests
  9. Vasily Melenchuk (CIB) fixed many issues with DOCX lists and fixed a DOCX paragraph spacing issue
  10. Noel Grandin (Collabora) made many code cleanups and made performance improvements in Calc in the areas of autofilling, loading of spreadsheets with huge autofilters and sorting data
  11. Caolán McNamara (Red Hat) continued the crucial user interface backend work and did many cleanups and crash fixes
  12. Rizal Muttaqin made many improvements in the icon themes and refreshed the Presenter Screen
  13. Balázs Varga (NISZ) fixed some OOXML chart issues
  14. Miklos Vajna (Collabora) improved the digital signing of PDFs and added signature line support for Draw. He also added support in Writer for anchoring shapes relative to the bottom of the page content frame
  15. Michael Stahl (CIB) fixed many issues with change tracking and anchoring in Writer
  16. László Németh (NISZ) fixed issues with DOCX table borders, bullet indenting, chapter numbers. He also improved AutoCorrect for several languages.
  17. Stephan Bergmann (Red Hat) made many cleanups and build fixes. He also fixed a nasty deadlock in a UI test while improving how the continuous integration handles jobs
  18. Julien Nabet fixed some crashes and made many cleanups
  19. Heiko Tietze (TDF) helped with the gallery rework
  20. Srijan Bhatia added time pause/resume and exit buttons to Impress Presenter console
  21. Tor Lillqvist (Collabora) worked on the iOS app and did code cleanups
  22. Serge Krot (CIB) worked on implementing a conditional in mailmerge for expanding/collapsing bookmarks and fixed an interoperability issue related to DOCX not supporting dropdown text fields
  23. Andreas Kainz continued to improve the galleries, dialog layouts and Notebookbar UIs
  24. Samuel Mehrbrodt (CIB) added a DOCX compatibility option for keeping spacing below last paragraph in header
  25. Attila Bakos (NISZ) fixed frames misbehaving in connection with shapes and mispositioned shapes in table cells
  26. Tibor Nagy (NISZ) fixed a bunch of DOCX frame text wrapping issues
  27. Gábor Kelemen (NISZ) fixed dropdown list form fields having an incorrect font at the beginning of a line in DOCX files
  28. Tünde Tóth (NISZ) fixed some issues with OOXML chart legends and titles
  29. Szabolcs Tóth (NISZ) fixed shape width relative to margins in DOCX file import
  30. Julian Kalinowski (Dataport) fixed a couple of webdav lock refresh issues
  31. Maxim Monastirsky fixed the importing of fields with user defined number formats
  32. David Tardon (Red Hat) made paragraph formatting in Lotus Word Pro documents work again and made LWP-related cleanups
  33. Eike Rathke (Red Hat) fixed XLSX table references being broken, if a table header name contained a comma and harmonised the behaviour of OFFSET() with Excel in case of invalid arguments
  34. Gülşah Köse (Collabora) added support for importing data label fill patterns in OOXML charts and an option for sending encrypted PDF files via mailmerge
  35. Christian Lohmaier (TDF) improved the macOS language package installer
  36. Igor Poboiko fixed the detection of system icon theme with qt5/kf5
  37. Dante Doménech added support for custom colours in Math and added a symbol for Laplace Transforms
  38. Szymon Kłos (Collabora) added a styles preview widget for the Tabbed Notebookbar user interface
  39. René Engelhard (Debian) changed the page size of default Writer/Calc/Draw templates to A4
  40. Sarper Akdemir worked on his GSoC project “Add Impress shape animations that use a real physics engine”
  41. Ahmed ElShreif worked on his GSoC project “Extending the UITest framework”
  42. Ahmad Ganzouri worked on his GSoC project “Blurry Shadows”
  43. Shivam Kumar Singh worked on his GSoC project “Styles Inspector”
  44. Aditya Sahu worked on his GSoC project “Move the gallery code to use ZIP files”
  45. Yusuf Keten worked on his GSoC project “Additions – Tight integration of extensions!”

Kudos to Ilmari Lauhakangas for helping to elaborate the list above.

Reported Bugs

826 bugs, 88 of which are enhancements, have been reported by 367 people.

Top 10 Reporters

  1. Telesto ( 174 )
  2. NISZ LibreOffice Team ( 37 )
  3. Xisco Faulí ( 26 )
  4. NSO LibreOffice Team ( 19 )
  5. Gerald Pfeifer ( 15 )
  6. libre officer ( 12 )
  7. Timur ( 12 )
  8. Regina Henschel ( 10 )
  9. Rizal Muttaqin ( 10 )
  10. Mike Kaganski ( 10 )

Triaged Bugs

858 bugs have been triaged by 100 people.

Top 10 Triagers

  1. Xisco Faulí ( 158 )
  2. Buovjaga ( 130 )
  3. Dieter ( 61 )
  4. Heiko Tietze ( 56 )
  5. Timur ( 50 )
  6. Julien Nabet ( 46 )
  7. Telesto ( 43 )
  8. V Stuart Foote ( 35 )
  9. BogdanB ( 28 )
  10. Roman Kuznetsov ( 16 )

Resolution of resolved bugs

729 bugs have been set to RESOLVED.

Check the following sections for more information about bugs resolved as FIXED, WORKSFORME and DUPLICATE.

Fixed Bugs

238 bugs have been fixed by 42 people.

Top 10 Fixers

  1. Caolán McNamara ( 36 )
  2. Michael Stahl ( 20 )
  3. Luboš Luňák ( 14 )
  4. László Németh ( 10 )
  5. Rizal Muttaqin ( 10 )
  6. Olivier Hallot ( 8 )
  7. Miklos Vajna ( 6 )
  8. Noel Grandin ( 6 )
  9. Vasily Melenchuk ( 5 )
  10. Stephan Bergmann ( 5 )

List of critical bugs fixed

  1. tdf#133527 Beta 7.0.0.0 crashes upon dragging a document into its window ( Thanks to Mike Kaganski )
  2. tdf#133822 Toolbar and sidebar items positioning messed up with RTL-language UI ( Thanks to Caolán McNamara )
  3. tdf#134106 Binary URP bridge disposed during call to ServiceManager.createInstanceWithContext ( Thanks to Stephan Bergmann )
  4. tdf#134291 Names of new hatch patterns in 7.0 not localizable ( Thanks to Julien Nabet )

List of high severity bugs fixed

  1. tdf#125428 Huge ram amount used not freed ( Thanks to Luboš Luňák )
  2. tdf#130354 Cannot sign existing PDF, ‘ .tmp does not exist’ from 6.4 ( Thanks to Miklos Vajna )
  3. tdf#132431 Crash: “vector::_M_fill_insert” with large sumifs ( Thanks to Luboš Luňák )
  4. tdf#132451 Wrong calculation after copy/paste of a formula ( Thanks to Luboš Luňák )
  5. tdf#132725 Crash in: BigPtrArray::Index2Block(unsigned __int64) anchor to paragraph ( Thanks to Michael Stahl )
  6. tdf#132822 Crash in undo in spell checking dialog when previous paragraph had undo information when the new paragraph replaced it ( Thanks to Caolán McNamara )
  7. tdf#133145 FILEOPEN DOC: Endnotes not at end of document ( Thanks to Miklos Vajna )
  8. tdf#133302 Redo from instantaneous to 3 minutes waiting time ( Thanks to Luboš Luňák )
  9. tdf#133326 Crash after redo (steps in comment 5) ( Thanks to Noel Grandin )
  10. tdf#133459 FILEOPEN: User defined number format not applied to fields inside header or footer ( Thanks to Maxim Monastirsky )
  11. tdf#133582 Tools > Options has no check boxes ( Thanks to Rizal Muttaqin )
  12. tdf#133629 FORMATTING: Calc crashes on setting borders to all cells on more than one sheet simultaneously ( Thanks to Noel Grandin )
  13. tdf#133641 CRASH: after clicking on a drop-down form ( Thanks to Michael Stahl )
  14. tdf#133744 EDITING: Crashes when pressing enter in “Paste special” dialog ( Thanks to Caolán McNamara )
  15. tdf#133753 “Base point” image in “Position and Size” dialog is missing ( Thanks to Rizal Muttaqin )
  16. tdf#133855 CALC crashed when choosing item from a dropdown list with condition formating ( Thanks to Caolán McNamara )
  17. tdf#134234 FILEOPEN: SUMPRODUCT formulas are broken ( Thanks to Noel Grandin )
  18. tdf#76817 Outline Numbering for DOCX not working when new headings inserted in between (to reproduce, see comment 15/17/19) ( Thanks to László Németh )

List of crashes fixed

  1. tdf#121384 Crash of Writer opening any document with “invalid” python file in home directory (linux) ( Thanks to Caolán McNamara )
  2. tdf#130272 QR-Code Generator crashes when text too long ( Thanks to Adolfo Jayme Barrientos )
  3. tdf#130436 Writer crash while going Tools>Redaction, if Draw not installed ( Thanks to Muhammet Kara )
  4. tdf#132326 CRASH: undoing paste of frames ( Thanks to Michael Stahl )
  5. tdf#132431 Crash: “vector::_M_fill_insert” with large sumifs ( Thanks to Luboš Luňák )
  6. tdf#132596 Crash in: SwPosition::SwPosition(SwPosition const &) ( Thanks to Michael Stahl )
  7. tdf#132597 Crash in: swlo.dll ( Thanks to Michael Stahl )
  8. tdf#132681 SKIA crash when launching LO after having renamed LO profile ( Thanks to Luboš Luňák )
  9. tdf#132725 Crash in: BigPtrArray::Index2Block(unsigned __int64) anchor to paragraph ( Thanks to Michael Stahl )
  10. tdf#132822 Crash in undo in spell checking dialog when previous paragraph had undo information when the new paragraph replaced it ( Thanks to Caolán McNamara )
  11. tdf#133326 Crash after redo (steps in comment 5) ( Thanks to Noel Grandin )
  12. tdf#133527 Beta 7.0.0.0 crashes upon dragging a document into its window ( Thanks to Mike Kaganski )
  13. tdf#133629 FORMATTING: Calc crashes on setting borders to all cells on more than one sheet simultaneously ( Thanks to Noel Grandin )
  14. tdf#133633 LO crashes with SuperNova Magnifier & ScreenReader ( Thanks to Michael Weghorn )
  15. tdf#133641 CRASH: after clicking on a drop-down form ( Thanks to Michael Stahl )
  16. tdf#133744 EDITING: Crashes when pressing enter in “Paste special” dialog ( Thanks to Caolán McNamara )
  17. tdf#133785 autofilter with dates crashes when search entry is used and then cleared ( Thanks to Caolán McNamara )
  18. tdf#133855 CALC crashed when choosing item from a dropdown list with condition formating ( Thanks to Caolán McNamara )
  19. tdf#133862 Crash when trying to customize toolbar during embedded Equation editing ( Thanks to Caolán McNamara )
  20. tdf#133898 Call to loadCalendarTZ crashes LibreOffice ( Thanks to Julien Nabet )
  21. tdf#133971 Crash in validity list + conditional formatting ( Thanks to Caolán McNamara )
  22. tdf#133981 CRASH: Undoing deletion of selection ( Thanks to Michael Stahl )
  23. tdf#133982 CRASH: copying content in nested table ( Thanks to Michael Stahl )
  24. tdf#133987 CRASH opening Options ( Thanks to Mike Kaganski )
  25. tdf#133990 CRASH: Undoing table deletion ( Thanks to Michael Stahl )
  26. tdf#134019 Calc FILEOPEN Crash in: sclo.dll ( Thanks to Caolán McNamara )
  27. tdf#134021 Crash swlo!SwFrame::CheckPageDescs+0x12d6: ( Thanks to Michael Stahl )
  28. tdf#134099 BigPtrArray::Index2Block undo crash ( Thanks to Miklos Vajna )

List of performance issues fixed

  1. tdf#125428 Huge ram amount used not freed ( Thanks to Luboš Luňák )
  2. tdf#132165 Copying a large dataset by drag a a corner slow ( Thanks to Luboš Luňák )
  3. tdf#132454 Lots of time spend in SfxBroadcaster after Undo of a deleted sheet ( Thanks to Luboš Luňák )
  4. tdf#133267 Undo inserting a row above extremely slow ( Thanks to Luboš Luňák )
  5. tdf#133302 Redo from instantaneous to 3 minutes waiting time ( Thanks to Luboš Luňák )
  6. tdf#133699 Slow sorting of a column ( Thanks to Noel Grandin )
  7. tdf#88109 PERF: Calc autofill is very slow ( Thanks to Noel Grandin )

List of old bugs ( more than 4 years old ) fixed

  1. tdf#40436 Custom colours in Math ( Thanks to dante )
  2. tdf#43452 Long Password fails for file saving LibreOffice CALC file ( Thanks to Caolán McNamara )
  3. tdf#47914 Enhancement Request: Please add Laplace symbol ( Thanks to dante )
  4. tdf#76817 Outline Numbering for DOCX not working when new headings inserted in between (to reproduce, see comment 15/17/19) ( Thanks to László Németh )
  5. tdf#83309 FILEOPEN: NUMBERING: text paragraph indentation/tab stops in .DOCX displayed incorrectly with tab ( Thanks to Vasily Melenchuk )
  6. tdf#88109 PERF: Calc autofill is very slow ( Thanks to Noel Grandin )
  7. tdf#90978 Add Exit to Impress Presentation console ( Thanks to Srijan Bhatia )
  8. tdf#91250 FILEOPEN: Decimal Place Formatting issue with imported OOXML charts ( Thanks to Balazs Varga )

WORKSFORME bugs

112 bugs have been retested by 39 people.

Top 10 testers

  1. Buovjaga ( 21 )
  2. Xisco Faulí ( 11 )
  3. Michael Weghorn ( 10 )
  4. Telesto ( 8 )
  5. Timur ( 6 )
  6. Julien Nabet ( 6 )
  7. Roman Kuznetsov

by x1sc0 at July 08, 2020 12:04 PM

July 07, 2020

Sarper Akdemir

Simulated Animation Effects Week#5

I’ve started past week by going over my implementation of simulated animation effects and getting rid of the rough parts, so it would be somewhat ready to be merged into LO master. While doing so, realized I’ve forgot to add support for other types of ongoing animations in parallel with a simulated animation.

So to implement this, I thought all animation instances would have a reference to box2DWorld, if box2DWorld is initiated (as in there’s a simulated animation going on), these animations would supply box2DWorld with required information on how to update shape corresponding to this animation instance. The information supplied would have the uno shape reference of that animation effect, type of the update box2DWorld will perform (change position, appear/disappear, change size etc.), and if required any additional info (for instance, if it is an path motion animation, it would supply the updated position of the shape).

box2DWorld would hold all incoming information in a queue so that it can process this information before stepping through the simulation.

So far I’ve only implemented this for path motion animation effects – since my finals have started last week, and they are slowing down my progress :/ –

For the instance of path motion animations, when there’s an position update it doesn’t make sense to just change the position of the shape (teleport) in box2DWorld, even though this would make it push shapes out of it’s way, the end product wouldn’t seem “simulated” since the body didn’t have any velocity. To fix this problem, positions of the shapes are updated by calculating linear velocity required to make the shape travel to the desired position in the delta time box2DWorld will step through. And then assigning this linear velocity to corresponding body. This results in convincing simulations that have a higher degree of realism.

Here’s a small demo illustrating this in action:

Please accept YouTube cookies to play this 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.

check out the source on the private experimental branch: gsoc-box2d-experimental

by quwex at July 07, 2020 11:29 PM

Michael Meeks

2020-07-07 Tuesday

  • Spent lots of time reading, and writing up (again) some of the problems with TDF / LibreOffice - none of which are very new.

July 07, 2020 09:00 PM

July 06, 2020

Michael Meeks

2020-07-06 Monday

  • Mail chew; read through a slew of E-mail, telegram, bugzilla and other feedback on LibreOffice Personal. Tech. planning call with Andras - much of the mgmt team on vacation. Lots of E-mail.

July 06, 2020 09:00 PM

LibreOffice QA Blog

LibreOffice 7.0 RC1 is available for testing

The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 7.0 RC1 is available for testing!

LibreOffice 7.0 will be released as final at the beginning of August, 2020 ( Check the Release Plan for more information ) being LibreOffice 7.0 RC1 the forth pre-release since the development of version 7.0 started in the beginning of June, 2019. Since the previous release, LibreOffice 7.0 Beta2, 174 commits have been submitted to the code repository and 116 bugs have been fixed. Check the release notes to find the new features included in LibreOffice 7.0.

LibreOffice 7.0 RC1 can be downloaded from here for Linux, MacOS and Windows.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

For help, you can contact the QA Team directly in the QA IRC channel or via Telegram.

LibreOffice is a volunteer-driven community project and your help is much appreciated.

Happy testing!!

Download it now!

by x1sc0 at July 06, 2020 12:13 PM

Ahmed ElShreif

Week 5 Report

Hello all,

The last week was the 5th week of coding weeks in GSoC program. I continued adding support for the non supported items.

 Report in points:
  • Finalize support for Calc-comment .
  • Fix some DSL grammar errors .
  • Add support for "Hyperlink dialog. Insert ->Hyperlink".
  • Add test cases that test "Hyperlink dialog. Insert ->Hyperlink" .
  • Finalize the unfinished patches .
=====================================

1) The last week I left the Calc Comments support in this patch not merged waiting the final review. the patch added a function in FuDraw class to help in closing the Comment window. So the work this week done was to move this function from the FuDraw class to the UI testing code. This approach is done in the last patch and tested on the test case in this patch. So the patch waiting for the final review.
=====================================

2) I worked this week also in fixing the issue in the DSL grammar that related to "EditUIObject". It was simple modification in the string of the grammar rule but without it any selection of text inside any EditUIObject will make the automatic generation of the test case fail. The patch is now merged .
=====================================

3) I also This week worked on the "Hyperlink dialog. Insert ->Hyperlink" item from the list of unsupported items. After working with this dialog I found that it wasn't work because the tabcontrol of the dialog is vertical tabcontrol not the normal tabcontrol. So I worked on adding support for vertical TabControl Object. This patch has the support.

We need support for this Object as some dialogs use it like Hyperlink Dialog. So now we can navigate in the dialog in the same way we navigate with the normal TabControl Objects.

You can use this lines in your test case that test a dialog that has vertical TabControl Object:
xtab=HyperlinkDialog.getChild("tabcontrol")
xtab.executeAction("SELECT", mkPropertyValues({"POS": "0"}))

The video here show how the vertical tab control can be used now for this navigation:

=====================================
4) I worked also in adding  test case for Hyperlink Dialog. The test case tests the Hyperlink Dialog in inserting a Hyperlink . Also it tests the Vertical TabControl Support that added in this patch. the test case can be found here in this patch.

=====================================

5) From the last week this is the status of the patches:
=====================================

Next week Tasks:
  • Finalize the 5 patches that still under review by solving any comments.
  • Work on another unsupported item.

Thanks for reading. And I am really interested to hear all your feedback and comments.

by Ahmed ElShreif (noreply@blogger.com) at July 06, 2020 06:54 AM

LibreOffice Design Blog

Results from the survey about LibreOffice’s web presence

LibreOffice’s basic conception is to be not just a product, the office suite, but a community around it. So we do not only provide downloads and support for the development but also make it easy to join the project. As a consequence, the ecosystem and web presence has grown to a point where we think renovation and consolidation might be necessary.…

by Heiko Tietze at July 06, 2020 06:40 AM

July 05, 2020

Michael Meeks

2020-07-05 Sunday

  • Relaxed, music with the babes, sermon on Noah's flood with the babes from Gordon: interestingly I still have notes around on it from 2007.
  • Pizza lunch, out for a walk together, watched Hustle.

July 05, 2020 09:00 PM

July 04, 2020

Ahmed ElShreif

Week 4 Report

Hello all,

The last week was the 4th week of coding weeks in GSoC program. So this report is final report before phase 1 evaluation . I continued adding support for the non supported items.

 Report in points:
  • Finalize the demo of Writer comments.
  • Add the support for Calc-comment.
  • Add test case for Calc-comments .
  • Add support for Writer Format-Bullets and numbering dialog Selection.
  • Add demo for Writer Format-Bullets and numbering dialog Selection.
=====================================

1) The last week I left the Writer Comments test case in this patch not merged because of some failures but now it's ready to be merged but waiting the final review.
=====================================

2) I added the support for Calc-comments here in this patch. We can now use this support in writing test cases that handle Calc's comments using the lines as descriped in the last report.

In this video I just want to show the results of this support:
Note that the patch still under review.
=====================================

3) I also added a test case for Calc-comments that can be found here in the patch. It test all the functionalities that added for comments. The patch still under review.
=====================================

4) I also worked this week in Adding support for Writer Format-Bullets and numbering dialog Selection. I found that the selecter is a object from class SvxNumValueSet so I added support for it.

The support of SvxNumValueSet can be found in this patch which also will help us to add support for test cases that test  Writer Format-Bullets and numbering dialog Selection.

You can choose any item from the selector by this line for example:
obj_name.executeAction("CHOOSE", mkPropertyValues({"POS": "pos_num"}))

You can also check the selector by these lines:
get_state_as_dict(obj_name)["ItemsCount"]
get_state_as_dict(obj_name)["SelectedItemPos"]
get_state_as_dict(obj_name)["SelectedItemId"]
get_state_as_dict(obj_name)["ItemText"]
In this video I just want to show the results of this support:


Note that the patch still under review.
=====================================

5) Finnaly, I created a test case to test the selectors of the 4 tabs of the Writer Format-Bullets and numbering dialog and added them to this file as it test the dialog.

The test case can be found here in this patch. and the patch still under review .
=====================================

Phase (1) Achievements :
  • Solving some issues in the logger DSL .
  • Add support for Calc-Zoom .
  • Add support for Calc / Format cell / background color selector .
  • Extend the ability of ComboBoxUIObject to be able to select with text .
  • Add support for Writer-comments .
  • Add support for Dropdown items in grid window .
  • Add support to Calc - comments .
  • Add Support for SvxNumValueSet .
  • Add test cases for each added support.
=====================================

Next week Tasks:
  • Finalize the 5 patches that still under review by solving any comments.
  • Start working on adding support for "Hyperlink dialog. Insert ->Hyperlink".
  • Adding test cases that test "Hyperlink dialog. Insert ->Hyperlink" .
  • Work on another future unsupported item.

Thanks for reading. And I am really interested to hear all your feedback and comments.

by Ahmed ElShreif (noreply@blogger.com) at July 04, 2020 09:24 PM

Roman Kuznetsov

Will LibreOffice 7.0 be only Personal Edition for individual use???

So... I was very surprised when I saw this in About dialog in LibreOffice (that screenshot was made in current master 7.1, but you can see the same in 7.0 RC1 version):
Look at LibreOffice logo with "Personal Edition" phrase, look at sidebar in Start Center with the same phrase and note to "The Personal edition is supported by volunteers and intended for individual use."
And what is mean? Where is any public announcement? They say it was in marketing mail list. How many people read that mail list? Five?
It means that I can't install LibreOffice 7.0 in any organization in Russia, because our controlling people will be see very simple to legality in this case: open the About dialog -> read that "intended for individual use" and LibreOffice logo with "Personal Edition" -> you can't use LibreOffice here! Nobody will check what say MPL 2.0 license about it or why TDF made it, they just point a finger at it and they will be right!
It will close for LibreOffice any education organizations like schools or colleges or universities.
I wont popularize LibreOffice for young people because they will never see LibreOffice in them schools.
I against these changes. Please revoke it!
ps: I had a suggestion about add into About dialog phrase like "You can use/install LibreOffice to any number of computers in any place (at home, organizations, etc.)" but they were against! See the bug report. And now they make own changes in to opposite side from free.

by Roman Kuznetsov (noreply@blogger.com) at July 04, 2020 12:01 PM

July 01, 2020

Sarper Akdemir

Simulated Animation Effects Week#4

After getting simulated animation effects somewhat a presentable state in week 3 on my experimental branch, this week my goal was to make them saveable.

Since I wanted them to be saveable on SMIL hierarchies, like the rest of the animations, I’ve started by creating new xml tokens that’ll be used and named them “motion-simulated” and “animateSimulation”.

Made required connections for importing/exporting these animation effects mimicking how path motion is imported/exported.

Later created a new animation preset on Effects.xcu for testing purposes and called it arbitarily “Simulated Basic”.
And lastly, connected stuff with animation effects panel creating a new category there for simulated animations.

You can check out the whole implementation on my experimental branch: gsoc-box2d-experimental

Also, this is how it looks when saved: (inside content.xml on an ODP file)

<anim:par smil:begin="0s">
  <anim:par smil:begin="0s" smil:fill="hold" presentation:node-type="on-click" presentation:preset-class="motion-simulated" presentation:preset-id="ooo-motionsimulated-basic">
    <anim:animateSimulation smil:dur="5s" smil:fill="hold" smil:targetElement="id1"/>
  </anim:par>
  <anim:par smil:begin="0s" smil:fill="hold" presentation:node-type="with-previous" presentation:preset-class="motion-simulated" presentation:preset-id="ooo-motionsimulated-basic">
    <anim:animateSimulation smil:dur="5s" smil:fill="hold" smil:targetElement="id2"/>
  </anim:par>
</anim:par>

by quwex at July 01, 2020 07:41 PM

June 30, 2020

Marius Popa Adrian

Firebird Project is happy to announce general availability of Firebird 3.0.6

Firebird Project is happy to announce general availability of Firebird 3.0.6 — the 6th point release in the Firebird 3.0 series. This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes.Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS packages will follow shortly.

by Popa Adrian Marius (noreply@blogger.com) at June 30, 2020 09:16 AM

June 29, 2020

Yusuf Keten

LibreOffice GSoC Week 5 Report

Hello, Last week I finished this academic year. Finally, I don’t have any exam that I have to study. So, I can spare more time to my project. Unfortunately, I just sent a little patch. For now, this patch has some parts that need to be fixed. I will finish the solving problems on this patch. Last Week As I said above, I added a new class to use threads.

by Yusuf Keten (ketenyusuf@gmail.com) at June 29, 2020 12:00 AM

LibreOffice GSoC Week 4 Report

Finally, the patch I worked on is merged thanks to my mentors(Muhammet Kara & Heiko Tietze). You can easily access the patch, from here Last Week I marked this feature as an experimental feature. Hamburger button(gear button) is added. Some arrangements have been made for translation in UI elements. There was an error with iOS and Android build. But this problem is solved thanks to Tor Lillqvist and Miklos Vajna.

by Yusuf Keten (ketenyusuf@gmail.com) at June 29, 2020 12:00 AM

June 27, 2020

Roman Kuznetsov

LanguageTool 5.0 is released

LanguageTool is a style and grammar checker for 25+ languages. It's available as an extension for LibreOffice and as online version. Here is a change list for 5.0 version.

by Roman Kuznetsov (noreply@blogger.com) at June 27, 2020 12:16 PM

June 25, 2020

Roman Kuznetsov

User defined color for symbols in LibreOffice Math formulas

LibreOffice Math allows you to define one from 16 color for symbols in your Math formula. You can write something like color red {formula} in Formula editor and get formula! But you couldn't define your own color there.
Now in future LibreOffice Math 7.0 you'll can do it!
 
Dante Doménech added that feature. Now you can write color rgb 240 130 12 {formula} and get formula. That "color" was added in Attributes on Element pane too.
Thanks Dante!

by Roman Kuznetsov (noreply@blogger.com) at June 25, 2020 08:48 PM

June 22, 2020

Ahmed ElShreif

Week 3 Report

Hello all,

The last week was the Third week of coding weeks in GSoC program. I continued adding support for the non supported items.

 Report in points:
  • Merging Writer Comments support .
  • Add demo to Writer Comment .
  • Add support for Dropdown items in grid window .
  • Add support for Calc comments .

1) The last week I left the Writer Comments item in this patch not merged. But now it's merged.

=====================================

2) I also created 2 test cases here in this patch. They test the Writer comment using the UITest framework. But the test cases appear to randomly fail. So the test cases was reverted here in this patch. The commit message has the details of the failure.

I worked in investigation of why this test cases fail randomly. By trying to run the old test case multiple times locally. The problem was when you execute Command to add new comment . Sometimes the comment doesn't have enough time to be created and added as a child in the MainWindow Object So test case fails.

I tried to add "time.sleep(1)" line to make sure that the comment created and added to the MainWindow as a child. But it wasn't a good solution.

So the fix in this patch was recommended by to use this function:
"ui_test.wait_until_child_is_available(parent, childName)" 
This will make sure that that the comment was created successfully and added as a child in the MainWindow to be selected in next lines. I also tried to run the test case again multiple times in my laptop and it never fails. The patch still under review.

=====================================

3) I also worked this week in Adding support for Dropdown items in grid window as we need to make test cases for issues similar to tdf#133855.

The support can be found in this patch add support for test cases that test Dropdown list of cells in Calc that can be created using:
Data -> Validity -> List
You can launch the list by this line for example:
gridwin.executeAction("LAUNCH", mkPropertyValues({"SELECTMENU": "", "COL": "2", "ROW": "9"})
Then you can select items from the list by it's id or it's text by these lines after launching the list:
xWin = self.xUITest.getTopFocusWindow()
xlist = xWin.getChild("list")
xListItem = xlist.getChild('0')
xListItem.executeAction("DOUBLECLICK" , mkPropertyValues({}) )
Also I added a test case that can be found here .

In this video I just want to show the results of this support:

=====================================

4) Finnaly, last week I worked on another item which was "Calc - comments" the work is here in this patch.

Now you can use these lines to use comments in calc test cases:
  1. Open Comment Window : 
    gridwin.executeAction("COMMENT",mkPropertyValues({"OPEN":""})) 
  2. Then Type text as normal :
    gridwin.executeAction("TYPE",mkPropertyValues({"TEXT":"any"})) 
  3. Close Comment Window :
    gridwin.executeAction("COMMENT",mkPropertyValues({"CLOSE":""}))
  4. Write Comment without opening comment window:
    gridwin.executeAction("COMMENT",mkPropertyValues({"SETTEXT":"any"})) 

You can also check the comment text by this line:
get_state_as_dict(gridwind)["CurrentCellCommentText"]

=====================================

Next week Tasks:
  • Finalize the demo of Writer comments and megre it .
  • Finalize the support Calc-comment patch and megre it .
  • Add test case for Calc-comments .
  • start working in Writer Format-Bullets and numbering dialog Selection.

Thanks for reading. And I am really interested to hear all your feedback and comments.

by Ahmed ElShreif (noreply@blogger.com) at June 22, 2020 08:11 PM

Sarper Akdemir

Simulated Animation Effects Week#3

This week, my main goal was instead of using PathAnimation classes, make the required connections in the animation engine so that simulated animations are part of the animation engine, and make it possible to have more than one simulated shape in a slide. I did this by mostly cloning PathAnimation classes and doing some changes to the SlideImpl.

Here’s a video demonstarting the status of the project at the end of Week 3 (PathAnimation is overriden by SimulatedAnimation for the demo):

Please accept YouTube cookies to play this 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.

check it out on my experimental branch: https://git.libreoffice.org/core/+/refs/heads/private/quwex/gsoc-box2d-experimental
First animation was an on-click animation and the rest was with-previous with delays.
Set up of the slideshow

i use arch btw.

Box2DWorld was meant to be shared by the all simulated animations so it is now constructed in SlideImpl classes and passed down to the animations with maContext by reference.


Changed a little the way the world is constructed, first the current state of the slide is constructed by Box2DWorld class, creating all the shapes in the world as static bodies. Then when a simulated animation starts it changes the body that belongs to the animation’s shape to a dynamic one, and a static one when animation ends.


Since there were a lot of animations sharing the same Box2DWorld, old approach of having the simulated animations just step through the box2d simulation wouldn’t work (SimulatedAnimation class would just step the box2d world without having knowledge about other animations, meaning the animation would take place twice as fast for two parallel animations) , so I’ve added a flag to create a lock mechanism on whether an animation is the “stepper” for a given Box2DWorld or not. If an simulated animation is the “stepper” (holds the lock) only that animation is able to step through the box2d world.
Simulated animations become the stepper if there isn’t any other one at their call operator (which is called on every update). End stop being the at their end() function.
This makes it possible to have animations with different durations, going in parallel without any problems.

Starting Week 4 by researching how will I make these animations saveable through SMIL hierarchies, if you have any pointers, please contact me on irc or by e-mail!

by quwex at June 22, 2020 01:22 PM

LibreOffice QA Blog

LibreOffice 7.0 Beta2 is available for testing

The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 7.0 Beta2 is available for testing!

LibreOffice 7.0 will be released as final at the beginning of August, 2020 ( Check the Release Plan for more information ) being LibreOffice 7.0 Beta2 the third pre-release since the development of version 7.0 started in the beginning of June, 2019. Since the previous release, LibreOffice 7.0 Beta1, 257 commits have been submitted to the code repository and 142 bugs have been fixed. Check the release notes to find the new features included in LibreOffice 7.0.

LibreOffice 7.0 Beta2 can be downloaded from here for Linux, MacOS and Windows, and it can be installed alongside the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

For help, you can contact the QA Team directly in the QA IRC channel or via Telegram.

LibreOffice is a volunteer-driven community project and your help is much appreciated.

Happy testing!!

Download it now!

by x1sc0 at June 22, 2020 11:29 AM

Yusuf Keten

LibreOffice GSoC Week 3 Report

After a long time(work), I proudly present you the first prototype of the Additions dialog. For 3 weeks I have been dealing with both the extension manager’s code and the connection of UI components to the project. In addition, I worked for the API, which will serve as a bridge between the site where the extensions are hosted and the project. For example, I prepared a sample API response and define parameters which is essential part to call GET request.

by Yusuf Keten (ketenyusuf@gmail.com) at June 22, 2020 12:00 AM

June 21, 2020

Roman Kuznetsov

LibreOffice 7.0 Beta 2 is available for testing

LibreOffice 7.0 Beta 2 is available for downloading and testing. You can download it by follow links for your OS:
If you'll find any bug in LibreOffice Beta 2, then please create a bug report in our Bugzilla.

by Roman Kuznetsov (noreply@blogger.com) at June 21, 2020 07:59 PM

June 19, 2020

Collabora Community

Collabora Office for Android & iOS Credits

About Collabora Office for Android & iOS

Thank you for your interest in Collabora Office for Android & iOS. These mobile apps are based on the core engine of LibreOffice and developped by Collabora Productivity with the help of other partners. In combination with a new front-end based on Collabora Online, it reads and saves documents similarly to LibreOffice on the desktop. Collabora engineers have been developing the Android support since 2012. Collabora Office has been the first free and open source office app available for iOS. For more details on the evolution of the software, we strongly recommend you to read Michael Meeks’ article about the evolution of Collabora Office for phones. On this page we would like to credit many of those who contributed to making this open source office suite for phones and tablets possible by giving a chronological overview over this huge effort that extended over several years.

2012 – Android Prototype

FOSDEM 2012 presentation by Michael Meeks

Screenshot of prototype presented at FOSDEM 2012

 

2013  – LibreOffice based CloudOn app for iPads

  • Many of SUSE’s LibreOffice Core developers are spun out to form Collabora Productivity
  • VC funded CloudOn makes a key investment to work with Collabora on a native iOS app for iPads
  • Matus Kukan (Collabora) builds the foundations to link the entirety of LibreOffice into a single shared library image
  • Jan Holešovský (Collabora) and Tor Lillqvist (Collabora) implement tiled rendering inside Writer

2014 – LibreOffice Viewer (Beta)

  • Funding from Smoose and Collabora makes the first development of a ‘real’ Android viewer possible
  • Andrzej Hunt improved and extend tiled rendering to Calc and Impress during Google Summer of Code 2014
  • Kohei Yoshida (Collabora) reviews, re-works and merges the Calc tiled-rendering code to master.
  • Tomaž Vajngerl re-target the Fennec tiled-rendering code from Mozilla’s android browser to target the LibreOffice core

Writer screenshot of 2014 LibreOffice Viewer (Beta)

Impress screenshot of 2014 LibreOffice Viewer (Beta)

2015 – LibreOffice Android Editor prototype

  • Collabora wins a TDF tender to “develop the base framework for an Android version of LibreOffice with basic editing capabilities”
  • Igalia won the part of the tender to implement an ownCloud integration.
  • Collabora released an LibreOffice for Android: prototype editor preview that implements tiled editing in the LibreOffice core, as well as the input handling work in Java based on the Fennec code.
  • Collabora creates Online – a new codebase for collaborative web editing

2015 Writer editor preview

2015 Calc editor preview

2016 – Hoping for a LibreOffice Android Community

  • LibreOffice for Android it is hoped, will be completed by community volunteers; the basic editing is kept as an experimental / advanced feature
  • Christian Lohmaier does important work in keeping the viewer compiling and fighting bit-rot for TDF

2017 – Summer of Code Initiatives

  • Collabora helps out by mentoring several students on top of the Fennec / Java framework
  • Gautam Prajapati, mentored by Collabora Developers Tomaž Vajngerl and Miklos Vajna, worked on improving the LibreOffice Viewer for Android during the Google Summer of Code 2017
  • Ximeng Zu, also mentored Tomaž Vajngerl and Miklos Vajna from Collabora, worked on solving bugs in the LibreOffice Android Viewer during GSoC 2017

2018 – Stagnant Development

  • Muammer Mert Tümer, mentored by Collabora Developers Tomaž Vajngerl and Miklos Vajna, worked on the Google Summer of Code 2018
  • TDF continues calling for more voluntary development support. The (unlisted) video below is a beautifully done example, that – unfortunately – this fails to attract significant support for the app.
  • Mert working for ULAKBIM / Pardus fixes a number of issues with the Fennec code

Dec 2018 – 2019 – Collabora Office re-writes to use Online for iOS + Beta version for Android

Spell checking in Collabora Office on iOS
Writer spell checking in Collabora Office on iOS

Collabora Office on iOS for editing spreadsheets.
Collabora Office on iOS for editing spreadsheets.

Creating presentations in Collabora Office iOS
Creating presentations in Collabora Office iOS

2020 – Collabora Office available for Android

  • The Mobile phone UX is completely re-written, with a new expandable bottom palette of simple, frequently used tools created by Szymon Klos
  • Native platform storage provider interface added on Android integrating with ownCloud, Nextcloud, Seafile, OneDrive or DropBox (this obsoleted Igalia’s TDF funded native Java integration from 2015 mentioned above, and allowed accessing all system content integrations)
  • Collabora Office for Android is released with full editing capabilities, a focus on privacy and free of charge

File picking on start-up of Android app

Copy/paste available through convenient gestures on Android

Easy to use pop up menus for Calc on Android

More contributions from the Collabora Team

Throughout the initial first prototypes, the LibreOffice Android Viewer to the fully functional Collabora Office for Android & iOS apps, many other not yet mentioned Collaborans have been contributing a lot of important work into this project. Here is an alphabetical overview of some of their key contributions. Again, this information is taken from Michael Meeks’ Collabora Office for Phones article.

  • Andras Timar took care of various l10n peculiarities
  • Aron Budea has spent a lot of time testing, reporting bugs and fixing regressions
  • Ashod Nakashian was heads-down improving the focusing and showing / hiding the keyboard, fixed crashes, exposed sidebar (reused for the Szymon’s work) & lots of related fixing
  • Dennis Francis has done many fixes all over the place in the UI – crashes, panning, context menus additions, zooming
  • Florin Ciornei has ported most of the shell functionality from the old app (as mentioned above), and created a separate notice and licence activity
  • Gülşah Köse has implemented the initial WebView app and improved the files association
  • Grzegorz Araminowicz has fixed zoom and reworked the hyperlink dialog
  • Henry Castro has implemented the image or shape preview when dragging or rotating, read-only mode handling, context menus improvements, scrolling, toolbars, and many more.
  • Marco Cecchetti has reworked the formula input bar in Calc work via dialog tunneling and list of formulas
  • Mert Tumer has added features even to the old, fennec-based app, and later decreased the size of the APK, improved the usability by adding progress bars to some events that take a lot of time.
  • Muhammet Kara added text box insertion, page setup menu, various chart-related work, and line formatting.
  • Pedro Pinto Silva has done huge amount of work to make the app beautiful.
  • Pranam Lashkari has implemented the inertia and smooth scrolling, row/columns improvements in Calc, sheet renaming, and various smaller things
  • Szymon Kłos has repurposed the sidebar as a single-finger-controllable menu representation; more on that below
  • Tamás Zolnai has prototyped a new unit testing framework via Cypress
  • Tomaž Vajngerl has co-mentored the Android GSoC, improved language setting, implemented export / save as functionality, hugely improved the clipboard handling
  • Yunusemre Şentürk: Fixed build errors & implemented the CI

Contribution by affiliation

So how does the project to date until May 2020 look ? this is based on code changes to Online:

Almost all of the original Smoose / TDF funded code doesn’t survive in Online, but it built a bridge to a bright future, and naturally all of the LibreOffice Core code is still shared with the core community. You can find an infographic and credits for all the other awesome community members who help to develop the LibreOffice core too. In the core core the contribution is more evenly spread:

Licence, Source Code, and Download

Collabora Office for Android & iOS is open source and released under the Mozilla Public License v2 and others. The source code is available here. You can download Collabora Online for Android & iOS via the app stores. The latest .apk of Collabora Office for Android can also be found here!

The post Collabora Office for Android & iOS Credits appeared first on Collabora Productivity.

by Marc Rodrigues at June 19, 2020 02:23 PM

June 18, 2020

Rizal Muttaqin

New Presenter Screen/Presenter Console User Interface


Long time no updates, here I would show you a little improvement over the UI of Impress Presenter Screen/ Presenter Console. The UI itself has no major change since first inception in 2008/2009 so I try to make it more modern.

The extra white border pixel in the box has been removed as well as the blurred shadow. The background also a little bit darker now and of course the icons in the bottom toolbar now looked sharped and harmonized.

Slide Transition (Before):
Slide Transition (After):


Slides List (Before):


Slides List (After): 



Zoom icons and scrollbar also got love.

Slide Notes (Before):

Slide Notes (After):




This will available for 7.0 release version.



by rizmut (noreply@blogger.com) at June 18, 2020 07:34 AM

June 15, 2020

Sarper Akdemir

Simulated Animation Effects Week#2

Last week my implementation lacked creating the current slide environment in the box2d world, meaning for the demo in the last blog post I had to hard code the environment.

So this week I wanted to get rid of this big flaw and start creating the environment from the slide on the fly. To achieve this goal, I needed current shapes in the slide. Therefore, to get shapes in the current slide I’ve implemented a new getter for ShapeManager and LayerManager classes. You can check out the patch at: https://gerrit.libreoffice.org/c/core/+/95967


Shapes from the master slide, and shapes that are part of the background needed to be classified and ignored, so I’ve added a flag called mbIsForeground in the Shape classes and corresponding setters and getters for this flag.

mbIsForeground flag is set to false, if it should be, while shapes are being imported for the slide show. Patch for it can be found at: https://gerrit.libreoffice.org/c/core/+/95968

To finish up I’ve added a new function to Box2DWorld class that will create static bodies in the box2d world from given Shapes. It is part of the still not merged box2d tools patch: https://gerrit.libreoffice.org/c/core/+/95614


And while tinkering with these, I was hacking on PathAnimation class to test and figure out how they are behaving. You can check out that if you want to on my experimental private branch: https://git.libreoffice.org/core/+/refs/heads/private/quwex/gsoc-box2d-experimental

Following video demonstrates the current situation at the end of week 2 of development on the said private experimental branch: (please excuse my “demonstrative” mouse movements)

Please accept YouTube cookies to play this 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.

by quwex at June 15, 2020 11:32 AM

June 14, 2020

Ahmed ElShreif

Week 2 Report

Hello all,

The last week was the second week of coding weeks in GSoC program. I continued adding support for the non supported items.

The last week I left the cell background color item in this patch not merged. But now it's merged.

I worked this week on adding support to Comments option in Writer You can find the work in this patch. And Also extending the ability of ComboBoxUIObject selection modes in this patch.

=====================================

For The selection of ComboBoxUIObject the old way you can select by this line:
xObj_name.executeAction("SELECT", mkPropertyValues({"POS": "3"}))
Now if you have the correct text of the option in the position you want to select you can select with this line:
xObj_name.executeAction("SELECT", mkPropertyValues({"TEXT": "Position_text"}))
This option is used in this test case.

=====================================

For Comments in Writer:

This was done by adding support for the SwAnnotationWin class that inheret from vcl::Window. I just added a static integer to give each added comment a new unique ID.

You can now select your comment with this line:
variable name = xMainWindow.getChild("Comment"+"comment number")
Also you can do all this tasks with the comment:
  1. SELECT : to select text inside the comment
  2. TYPE : to write text inside the comment
  3. LEAVE : to return cursor back to the writer window
  4. HIDE : to hide your commet
  5. SHOW : to show your comment again
  6. RESOLVE : to mark your comment as a resolved one
  7. DELETE : Delete your comment
All this work can be found here. The patch is under review.

In this video I just want to show the results when you deal with comments using test case that handle multiple comments:

I also added a test case that can be found here in this patch. It's also still under review. It consist of 2 test cases the first one try to test all the features that can be used with comments. The second one make sure that we could handle multiple comments together.

Next week I hope to finish Comments in Calc and start with new items also.

Thanks for reading. And I am really interested to hear all your feedback and comments.



by Ahmed ElShreif (noreply@blogger.com) at June 14, 2020 07:53 PM

June 10, 2020

LibreOffice Design Blog

Please participate in a survey on our web presence

Screenshot of the WebsiteSince LibreOffice will become 10 years old in September, we believe it’s time to rethink our web presence. That’s primarily the home page https://www.libreoffice.org – but also all the various services that we established in the past for an effective and convenient ecosystem.…

by Heiko Tietze at June 10, 2020 09:12 AM

Miklos Vajna

Page-content-bottom vertical relation in Writer

Writer now has support for anchoring shapes relative to the bottom of the page content frame.

First, thanks to our partner SUSE for working with Collabora to make this possible.

Motivation

Users sometimes want to specify the vertical position of their shapes in text documents in a way that is relative from the bottom of the page content area. Also, this improves consistency, specifying a position that is relative from the top of the page content area is already possible.

Alternatively, it is possible to have the same calculated position when positioning from the top of the page content area. The downside of this approach is that the position changes when the page height changes. So if the user intention is to position a shape 2 cm above the bottom of the page content area and the page height changes, the shape has to be manually re-positioned. This manual re-positioning is not needed with the new page-content-bottom vertical relation.

For example, if a shape has a height of 10 cm and a 2 cm spacing is wanted between the bottom of the shape and the bottom of the page content area, the position can be set to -12 cm, and then the 2 cm spacing will be maintained, even after the page height changes.

Results so far

Here is how this works in practice:

Figure 1. Demo of a stable vertical position (relative to the bottom of the page content frame), during a page height change

You can see how the distance of the shape from the bottom is 2 cm, even if the page height changes.

How is this implemented?

If you would like to know a bit more about how this works, continue reading… :-)

  • the UNO API now supports a new PAGE_PRINT_AREA_BOTTOM relative orientation

  • the have the expected layout, SwToContentAnchoredObjectPosition::CalcPosition() now considers this from-bottom anchoring when handling the vertical relative orientation

  • the DOCX format already had a markup for this:

<wp:positionV relativeFrom="bottomMargin">
  <wp:posOffset>...</wp:posOffset>
</wp:positionV>

now the import/export code maps this markup to the new feature.

  • The UI allows setting a new "Page text area bottom" frame position. It turns out that the UI is quite nice here, it tries to prevent you from setting positions which would be outside the limits of the current page. This logic in SwFEShell::CalcBoundRect() now handles the new relative orientation.

  • The ODF filter now has a markup to represent the new vertical relation:

<style:graphic-properties ... loext:vertical-rel="page-content-bottom" .../>

There is a proposal to promote this from our extension namespace to normal ODF (thanks to Regina for the help there!).

Want to start using this?

You can get a snapshot / demo of Collabora Office and try it out yourself right now: try unstable snapshot. Collabora is a major contributor to LibreOffice and all of this work will be available in TDF’s next release too (7.1).

by Miklos Vajna at June 10, 2020 07:12 AM

June 08, 2020

Roman Kuznetsov

Why I hate LibreOffice Help changing

Did you try to change LibreOffice Help? No? Just try it. You'll get many pleasure (no). 
And then try to edit any article in Wikipedia. You can change it directly on site! And you'll really can make it EASY and you'll have a simple editor for heading or list creating. Also you'll can easy add links to another article by keywords.