SI GUI – Now with SDK + Naming

Hi all :)

So right before LibreOffice Conference I finished SI-GUI’s LibreOffice SDK support. You are now able to download the SDK and install it via the GUI.

Speaking of GUI, here it is:



Another thing where I need your help is the following:

Current icon
Current icon

The name was always bad and it is time to find a better one, although this will break some links…. And with a name, we need 1 icon (I attached the current). So if you have an idea and an icon, that would be perfect. [This icon is available in 256x256,128x128,48x48,32x32,16x16]

I am happily looking forward to hear your ideas. Enjoy SI-GUI :)

BTW: Tell me if you are using it and whether you like it or not :)

SI-GUI hotfix release

This is a hotfix release for the 4.3 has a problem saving your settings. What cannot be done in this version:

  • Abort downloads 
  • Guess the name for shortcuts [You have to enter/ copy paste it manually]

Please do NOT report those. I try to fix them tomorrow!

I am sorry for the inconveniences! But with this build you should be able to continue doing an awesome job!

PS: As you see in this build, SDK integration in SI-GUI is on its way ;)

Paypal donate button


I added a donate button today :). If you would like to give me a tip, feel free, but be sure this will never be a must. You do not get stuff done quicker by me of you donate. I will not push this to TDF-blog as those who search for the donate option will find it, and those who don’t should not be bothered :) [I do not push this on social media as well]



Assertion errors – not only for devs


So one difficult topic now. In his post I will throw around with things like precondition and code, but I really try to keep it simple.

So, let us first introduce the example. A “Linked-List”. What you need to know (just valid for this tiny example):

  • No element –> NULL
  • “->” is the link between elements
  • No element is an element
  • A list starts at “head”, so head is just the link to the first element

Let’s have an example. These are valid lists

  1. head->null
  2. head->1->2->3->null

The length of 1) is ZERO, of 2) THREE. That is most of the coding skills you need ;)

So, what are errors? You find them in LibreOffice as well as in all other software. It does not behave as expected, maybe resulting in a crash. That is quite obvious.  You can have invalid or simply unexpected input. As you can see in the above example, we do not expect to add the element “null” at position 1 [between 1 and 2] Would result in head->1->null->2->3->null (again sorry to all developers, I need easy examples).  So we are not allowed to add the element “null”, as this would result in changing the length of the list from 3 to 1, by adding one element. 3+1=1 okay, I guess that should not be like that…. So the code is a little bit inspired by Java, so sorry for the overhead ;)

public void addElement(int position /*A number from -2147483648 to +214483647*/, IntElement e /*Also a number like in our example, but it can have a link to a different IntElement*/){
assert e != null && LENGTH_OF_LIST >= 0;
if(head == null) //If we have an empty list
INSERTFRONT //We do not need to much detail here
assert LENGTH_OF_LIST == 1; //== means equals
return; //Exit the function here
int oLength = LENGTH_OF_LIST;
assert position >= 0 AND position <= LENGTH_OF_LIST;
INSERT_MIDDLE_LAST //Insert at the rest of the list
assert LENGTH_OF_LIST == oLength +1; // If adding succeeded the new length must be 1 greater than the old one

You can see some line start with “assert”. This are developer’s magic little helpers.

A function in mathematics and informatics has 3 conditions:

  1. Precondition –> How should the input should look like
  2. Post-condition –> How should the output / result of the function should look like
  3. Invariance–> What should be valid at the beginning and the end


What should be at the beginning and at the end?  The length must be >=0.


The inserted element must not be NULL and the length of the list must be positive (So this includes the invariance as well)


If the list is empty –> Length is 1 (this includes the invariance)
If the list is not empty the new length must be by one greater than the old length. (this includes the invariance as well)

So, did you get the need? You can assure yourself that the input and output of a function (and if you want steps inside) are correct. So you cannot get any unexpected result, if assertions are enabled. Assertions are disabled by default, because they slow down a bit, but in LibreOffice Daily build from tinderbox 39  (downloadable @ SI-GUI atm) assertions are enabled.

So finally, an example (I only realized they were enabled because of this message:44alpha


So at line 1291 of winlayout.cxx an assertion failed (while testing bug # 77248) That’s a starting point for devs. The error might be near there ;) So yes, it makes sence to have assertions enabled and more to write them. If you write down how the output and the input should look like, everyone knows. You are turning implicit to explicit knowledge. And you will save hours to search for the place, where the error did occur. So please, and this is not limited to LibreOffice, have assertions enabled during testing!

And if you see such a dialog and remember the steps you did to come there, check if such a bug exists and comment with the exact version, or create a new bug. The exact version is needed, because this is the only way, that devs know on which version of the file they can find the failing assertion.

SI-GUI stats


So right after the bug-hunting session (ok, I am a bit late ;) ) I pulled the statistics today, and I want to share with you 3 things :) [Statistic is available here]

Global bughunt
It was global

Well, as far as I can tell from the SI-GUIstats it was a global success – with France as top nation, congrats Sophie and all the french QA team.

4.3 a1 is #2

I do not know why you downloaded so often,  but as of today alpha 1 of our next release is one of the most downloaded versions since we make the statistic

Good testers!

So, what do tester test? It’s great to see so many of you testing master and the test builds. This helps us to bring out a good “Fresh” branch (lb => latest branch). It is great to see you on the “Stable” branch as well (“ob” => Older branch) to catch anything there as well.

Pie cake where you can see all versions downloaded
Yes, we do release some versions ;)

Thanks for testing so many versions and helppacks :). You know, we always tell QA is not difficult so if you are on Windows, feel free to use SI-GUI, and please share your stats. It’s nice to see your product is used :D

DOCX is not pure XML


So one more bashing post against OOXML from a TDF member? I see it more as a reflection as I had to create a non-binary (do not say anything about binary formats to save important data) for a homework from my university. And I realized that I made the very same mistake, it is just easier to explain…..

Anyway I start with bashing ;) The example I took is from here.

<!--?xml version="1.0" encoding="UTF-8" standalone="yes"?-->

<xml xmlns:v="urn:schemas-microsoft-com:vml"
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe">
<v:stroke joinstyle="miter"/>
<v:path gradientshapeok="t" o:connecttype="rect"/>
<v:shape id="_x0000_s1025" type="#_x0000_t202" style="position:absolute;
visibility:hidden" fillcolor="#ffffe1" o:insetmode="auto">
<v:fill color2="#ffffe1"/>
<v:shadow on="t" color="black" obscured="t"/>
<v:path o:connecttype="none"/>
<v:textbox style="mso-direction-alt:auto">
<div style="text-align:left"/>
<x:ClientData ObjectType="Note">
4, 15, 2, 10, 6, 15, 6, 4</x:Anchor>

So, do you find the mistake? What is not XML? It’s this line:

<x:Anchor>4, 15, 2, 10, 6, 15, 6, 4</x:Anchor>

So please keep that code fragment in mind…. I will continue with the story of my program. It is a sudoku program. (Wikipedia for Sudoku). What I want to achieve: A sudoku (for me, you can skip this it is not necessary) consists out of x boxes, where x is the total # of numbers. Each box of a sudoku has a height h and a width w.  x = w*h. w and h naturally have to be natural numbers starting from inclusive 2. This also means you have to store the width and height, as you will need them (A box can have 12 numbers and a height of either 3 ,4 or 6). The following shows the final XML file for a sudoku,

 <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<row>6 0 0 0 1 0 5 0 0 </row>
<row>8 0 3 0 0 0 0 0 0 </row>
<row>0 0 0 0 6 0 0 2 0 </row>
<row>0 3 0 1 0 8 0 9 0 </row>
<row>1 0 0 0 9 0 0 0 4 </row>
<row>0 5 0 2 0 3 0 1 0 </row>
<row>0 7 0 0 3 0 0 0 0 </row>
<row>0 0 0 0 0 0 3 0 6 </row>
<row>0 0 4 0 5 0 0 0 9 </row>

So, do you see the parallel between this file (or a row-element of it) and the docx file? Although it should not be too difficult to get a sudoku out of this, it is no real XML…. Why? Because a row in fact is application encoded.  So

<row>1 0 0 0 9 0 0 0 4 </row>

should in a perfect world be


I am quite sure, that you realized it in the sudoku context, that it should not be a big problem, but

 <x:Anchor>4, 15, 2, 10, 6, 15, 6, 4</x:Anchor> 

And this could be 4 points x1,y1,x2,y2,x3,y3,x4,y4, but this would be a rect but no anchor. (As I really do not know what it is, but just want to give you an idea how tricky it could be ( means a “Test” property…):   ,  ,  ,  .

Just before the end please have a look at this line


coordsize=”21600,21600″: Ok, let us just hope it is pixel or distance from some corner of the page….

But you cannot tell me, that this is not application encoded….. Do you have a clue what it should be? I guess it is a curve (You see the coordsize here again)


I have written two articles about Microsoft office, you may find the first here. As always your thoughts are very much appreciated :D

About the business of Microsoft Office and why TDF’s projects are so important II – Strategy

As so many read the first part (you may find it here)

As the first part described the Office Open XML format, the history, we get a step back. Why is Microsoft Office so important still? It’s simple, because Microsoft knows what is best for their users (personally I like the ribbon-UI, but many don’t) and, this is from major importance, you are used to use it. You have been using it forever.

So yes, a reason why so many people are using it, is the laziness of many. Others might call that “never change a running system…

So let’s get young people used to office, so that they will pay forever. As long as you are a student, you can get MS Office for 20$ a year (You have to pay 80$ for 4 years), or if your university relies on MS Office, you can even get it for free. Good choice for Microsoft.

There is one thing I learned in strategy, it is a formula, but it is not quite Mathematics.

First Steps x Vision x Discontent > Resistance [This is not my idea]. If this is true, you are ready for a change. Okay first steps are easy, download LibreOffice ;). So what’s about the vision? Access your content, although the subscription ended? Seems like a good choice… Discontent: Do you dislike the current situation? Is the discontent high enough in order to learn something new (adapt the new software).There is one thing what have this very formula and mathematics in common. If you have no vision, no first steps or no discontent you won’t change anything. I tried to help you to get the first steps and a vision, but is the discontent high enough before it is too late. Now you can export all your documents to ODF and seamlessly switch to LibreOffice. I guess for many people, which bought a licence for Microsoft Office are soon shocked, as they are forced to pay to continue using them [Yes, I believe not everyone did get that licence model]. The bad thing the average end user, who does not know of this blog or LibreOffice or any other office software will be extremely annoyed, but the formula will look like this: 0 [What can I do to change this] x 100 [I can use this software for a lifetime and it is not my antivirus [I do understand why those need a subscription] x 100 [I am very angry at Microsoft] > 1000  [A magic number, which represents if a change happens. To cut it short: 0 > 1000 -> false –> no change is going to happen.


So the strategy is like that [AFAIK] : In young years free courses should be offered to the children, which should learn how to use office [“Informatics lessons” at school with “How to format a Word document”. Later they want a cheap or free office. You can use the formula from above again. You can use the software you have learned and worked with at a relative low price, you are very productive using it and you love all the features it has. Are you discontent? No, so you won’t change  your office suite. You might have third-party tools (Addins), which are only compatible with Microsoft Office, so why should you change. At the end of the university, (In Europe getting from 0 -> Master takes at least 10 semesters, 5 years), you paid 160$ (or 0$) to Microsoft, used the latest feature richest version and received as well as created a huge amount of documents. Now you have no discount any more, office costs 69$ per year. The price increased by 250%. Would you stick to MS Office [which they believe you would do] or would you change your office suite? The strategy is very good, will you play along? Looking foerward to hear your comments :)

LibreOffice & more


Get every new post delivered to your Inbox.

Join 130 other followers

%d bloggers like this: