<div dir="ltr">2013/8/5 Elvis Stansvik <span dir="ltr"><<a href="mailto:elvstone@gmail.com" target="_blank">elvstone@gmail.com</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 dir="ltr"><div><div class="h5">2013/8/5 Jos van den Oever <span dir="ltr"><<a href="mailto:jos.van.den.oever@kogmbh.com" target="_blank">jos.van.den.oever@kogmbh.com</a>></span><br></div></div><div class="gmail_extra">
<div class="gmail_quote"><div><div class="h5"><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:<br>
<br>
===<br>
//This is an extension of numeric style. For the moment we used namespace of<br>
//oasis format for specific calligra extension. Change it for the future.<br>
void addCalligraNumericStyleExtensi<u></u>on(KoXmlWriter &elementWriter, const QString &_suffix, const QString &_prefix)<br>
===<br>
<br>
This function write tags <number:suffix> and <number:prefix> in the <number:number-style> elements and the <number:text-style> elements.<br>
<br>
It was introduced in 2005:<br>
===<br>
commit 9964ed1963bbf629d0f6d54d83ab9f<u></u>1d423db3fc<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>
<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><br>
</number:number-style><br>
<br>
Opening it in LibreOffice shows: "PREFIX0SUFFIX" which is correct interpretation of the XML. Looking at the cell format dialog shows this formatting string:<br>
"PREFIX"General"SUFFIX"<br>
<br>
Saving the spreadsheet again, gives this:<br>
<number:number-style style:name="N120"><br>
<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: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 <number:text/> element, I propose that Calligra removes the code for writing <text:suffix> and <text:prefix>.<br></blockquote><div><br></div>
</div></div><div>Sounds right to me (if you mean not remove, but replace it with writing of <number:text>), if they really are functionally equivalent.</div></div></div></div></blockquote><div><br></div><div>Though thinking a bit more; when loading <number:text/> back in, how do we know that this was specified as a prefix/suffix by the user (and this should be placed in the Prefix:/Suffix fields), and not as a general text component of the format? (just assuming you can do that as well).</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 dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div><span class="HOEnZb"><font color="#888888"><br>
</font></span></div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Elvis</div></font></span><div class="im"><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Cheers,<br>
Jos<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>
</blockquote></div></div><br></div></div>
</blockquote></div><br></div></div>