<div dir="ltr">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 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">
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>Sounds right to me (if you mean not remove, but replace it with writing of <number:text>), if they really are functionally equivalent.<br></div><div><br></div><div>Elvis</div><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><br></div></div>