<div dir="ltr">2013/8/5 Sebastian Sauer <span dir="ltr"><<a href="mailto:mail@dipe.org" target="_blank">mail@dipe.org</a>></span><br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On 08/05/2013 07:25 PM, Elvis Stansvik wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
2013/8/5 Elvis Stansvik <<a href="mailto:elvstone@gmail.com" target="_blank">elvstone@gmail.com</a>><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
2013/8/5 Jos van den Oever <<a href="mailto:jos.van.den.oever@kogmbh.com" target="_blank">jos.van.den.oever@kogmbh.com</a>><br>
<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Look what I found in libs/odf/KoOdfNumberStyles.**<u></u>cpp:<div class="im"><br>
<br>
===<br>
//This is an extension of numeric style. For the moment we used namespace<br>
of<br>
//oasis format for specific calligra extension. Change it for the future.<br></div>
void addCalligraNumericStyleExtensi<u></u>**on(KoXmlWriter &elementWriter,<div class="im"><br>
const QString &_suffix, const QString &_prefix)<br>
===<br>
<br>
This function write tags <number:suffix> and <number:prefix> in the<br>
<number:number-style> elements and the <number:text-style> elements.<br>
<br>
It was introduced in 2005:<br>
===<br></div>
commit 9964ed1963bbf629d0f6d54d83ab9f<u></u>**1d423db3fc<div class="im"><br>
Author: Laurent Montel <<a href="mailto:montel@kde.org" target="_blank">montel@kde.org</a>><br>
Date: Sun Feb 27 12:21:40 2005 +0000<br>
<br>
Allow to store prefix/suffix into numeric style<br>
(koffice extension)<br>
===<br>
<br>
This feature is used in Sheets:<br>
- create empty spreadsheet<br>
- choose 'Cell Format ..." from the context menu of a cell<br>
- write 'PREFIX' in the 'Prefix:' field<br>
- write 'SUFFIX' in the 'Postfix:' field<br>
- close the dialog<br>
- The cell now contains this text: "PREFIX 0 SUFFIX"<br>
- save the file<br>
<br>
Saving gives this ODF fragment:<br>
<number:number-style style:name="N1"><br></div>
<number:text>PREFIX</number:**<u></u>text><br>
<number:number number:min-integer-digits="1"/<u></u>**><br>
<number:text>SUFFIX</number:**<u></u>text><br>
<number:suffix>SUFFIX</number:<u></u>**suffix><br>
<number:prefix>PREFIX</number:<u></u>**prefix><div class="im"><br>
</number:number-style><br>
<br>
Opening it in LibreOffice shows: "PREFIX0SUFFIX" which is correct<br>
interpretation of the XML. Looking at the cell format dialog shows this<br>
formatting string:<br>
"PREFIX"General"SUFFIX"<br>
<br>
Saving the spreadsheet again, gives this:<br>
<number:number-style style:name="N120"><br></div>
<number:text>PREFIX</number:**<u></u>text><br>
<number:number number:min-integer-digits="1"/<u></u>**><br>
<number:text>SUFFIX</number:**<u></u>text><div class="im"><br>
</number:number-style><br>
<br>
As expected, the non-standard, prefix and suffix are removed.<br>
<br>
Gnumeric can load the file too but does not show the prefix and suffix.<br>
<br>
Since the prefix and postfix behavior can be obtained with the<br>
<number:text/> element, I propose that Calligra removes the code for<br>
writing <text:suffix> and <text:prefix>.<br>
</div></blockquote></blockquote></blockquote>
+2<div class="im"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Sounds right to me (if you mean not remove, but replace it with writing of<br>
<number:text>), if they really are functionally equivalent.<br>
</blockquote></blockquote></div>
In Jos example above they are already written. its just that we write them two times cause somebody forgot to remove the prefix/suffix tag-writing when adding the ODF code :)<div class="im"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Though thinking a bit more; when loading <number:text/> back in, how do we<br>
know that this was specified as a prefix/suffix by the user (and this<br>
should be placed in the Prefix:/Suffix fields), and not as a general text<br>
component of the format? (just assuming you can do that as well).<br>
</blockquote>
<br></div>
That prefix/suffix thing is complete our own invention. I think its legacy from the old KSpread file format where KSpread didn't use formatting-masks like ODF uses and we just forgot to remove that code (and proper adjust the UI imho, but that's unrelated to the topic on hand).</blockquote>
<div><br></div><div>Ah. I see. I didn't have a Calligra build at hand to check.</div><div><br></div><div>Elvis</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br>
<br>
______________________________<u></u>_________________<br>
calligra-devel mailing list<br>
<a href="mailto:calligra-devel@kde.org" target="_blank">calligra-devel@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/calligra-devel" target="_blank">https://mail.kde.org/mailman/<u></u>listinfo/calligra-devel</a><br>
</div></div></blockquote></div><br></div></div>