<div dir="ltr">Hey Rick,<br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 28, 2016 at 7:28 PM, Rick C. Hodgin <span dir="ltr"><<a href="mailto:rick.c.hodgin@gmail.com" target="_blank">rick.c.hodgin@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Since I haven't heard back, I'll go ahead and develop this using the syntax I propose. It's easily changed later.<br><br></div><div>Also two more additions:<br></div><div>(1) Adding a separator symbol for decimals, as in 1234.4321 being "1,234.432,1"<br></div><div>(2) Adding a feature to Writer which allows an export of every word using a page-based (page,X,Y) coordinate syntax for importing into other tools. It would be a type of XML layout, something like this:<br><br></div><div><coordinates document="filename..."><br></div><div> <page p="1"><br></div><div> <word x="3.212" y="2.187" text="Hi"/><br></div><div> <line x1=".." y1=".." x2=".." y2=".." thickness=".."/><br></div><div> </page><br></div><div></coordinates><br><br></div><div>And so on, and I would probably abbreviate things to <w> and <l> for word and line, and t=".." for text, etc...<br><br>I had a need for this yesterday, but I couldn't find an easy format which would allow me to replicate literal page,X,Y coordinates without extended parsing. A simple file layout like that would allow export, and potentially import.<br></div><div><br></div>Best regards,<br></div>Rick C. Hodgin<br></div></blockquote><div><br><br><br></div><div>So as Eike and I already mentioned this is actually part of what should be developed as part of the unit feature branch with a different syntax. Your proposed syntax does not fit into the existing number format code and does conflict a lot with the ideas behind the unit feature. Please try to read some of the existing code before working on something that has in its current form only a limited chance of being merged upstream.<br><br></div><div>If you want to talk about how to fit your ideas into the general calc concepts please come to IRC during EU working hours.<br><br></div><div>Regards,<br></div><div>Markus<br></div><div><br></div><div> <br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 26, 2016 at 8:22 AM, Rick C. Hodgin <span dir="ltr"><<a href="mailto:rick.c.hodgin@gmail.com" target="_blank">rick.c.hodgin@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Tue, Jan 26, 2016 at 5:50 AM, Eike Rathke <span dir="ltr"><<a href="mailto:erack@redhat.com" target="_blank">erack@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Rick,<br>
<span><br>
On Monday, 2016-01-25 16:26:53 -0500, Rick C. Hodgin wrote:<br>
<br>
> On Mon, Jan 25, 2016 at 3:21 PM, Rick C. Hodgin <<a href="mailto:rick.c.hodgin@gmail.com" target="_blank">rick.c.hodgin@gmail.com</a>><br>
</span><span>> > On Tue, Jan 12, 2016 at 8:00 AM, Eike Rathke <<a href="mailto:erack@redhat.com" target="_blank">erack@redhat.com</a>> wrote:<br>
</span><div><div>> >> On Friday, 2016-01-08 19:52:49 -0500, Rick C. Hodgin wrote:<br>
> >><br>
> >> > The category is called *"Metric."*<br>
> >> ><br>
> >> > When conveying fractional values, such that 1.2345E-08 (which is<br>
> >> > 0.000,000,012,345), it would do so in a metric-relative way using the<br>
> >> > standard milli (10^-3), micro (10^-6), nano (10^-9), pico (10^-12), and<br>
> >> so<br>
> >> > on...<br>
> >> ><br>
> >> > In the example, the *Metric* display would cause the value to show up<br>
> >> > as "*12,345<br>
> >> > pu*" (pico-units) if the thousands separator was used.<br>
> >><br>
> >> Could you give some examples what you think how the format code actually<br>
> >> should look like?<br>
> >><br>
> > Eike, I never heard back from you after my reply.<br>
> ><br>
> > The format would be "Metric" with "Metric:seconds" given for a specific<br>
> > override for the units name. And there are a few other options that I<br>
> > would like to append including a bias that the data may already be in, such<br>
> > as kilo-units ("Metric[:seconds][:bias=kilo]") and an override base to use,<br>
> > such as always displaying in milli-units<br>
> > ("Metric[:seconds][:bias=kilo][affix:milli]").<br>
> ><br>
><br>
> Please forgive my dyslexia. It should be:<br>
> Metric[:seconds][:bias=kilo][:affix=milli]<br>
><br>
> Each of the [] portions are optional, and would actually appear in a form<br>
> like this:<br>
><br>
> Metric:seconds:bias=kilo:affix=milli<br>
<br>
</div></div>I don't see how that would fit into the existing number format code<br>
syntax. It looks like something completely different.<br></blockquote><div><br></div></div></div><div>When I look to the existing formats, they seem to be a string parsed from left-to-right indicating what is conveyed in those places. So, I don't see where this one would be "something completely different" or anything that's unusable.<br><br>It would be applied using this type of logic (given in easily human-readable form):<br><br></div><div>if (string.lowercase().beginsWith("metric")) {<br></div><div> // "Metric" parsing<br></div>} else {<br><div> // Use the existing code for other format parsing<br>}<br></div><div><br></div><div>I'm open to suggestions. What do you propose?<br><br>The reason I used colons was to keep the formatting options concatenated, though it could use another character, or different words or symbols for words, as in: Metric:seconds:B-K:A-M<br><br></div><div>And if they used the default "units" then it would simply be: Metric:B-K:A-M<br></div><div><br></div><div>-----<br></div><div></div><div>Number: General, "General"<br></div><div>Number: -1234, "0"<br></div><div>Number: -1234.12, "0.00"<br></div><div>Number: -1,234, "#,##0"<br></div><div>Number: -1,234.12, "#,##0.00"<br></div><div>Number: -1,234.12, "#,###.00"<br></div><div>Number: (1,234), "#,##0_);(#,##0)"<br></div><div>Number: (1,234.12), "#,##0.00_);(#,##0.00)"<br><br></div><div>Percent: -13%, "0%"<br></div><div>Percent: -12.95%, "0.00%"<br><br></div><div>Currency: -$1,234 (black), "[$$-409]#,##0;-[$$-409]#,##0"<br></div><div>Currency: -$1,234.00 (black), "[$$-409]#,##0.00;-[$$-409]#,##0.00"<br></div><div>Currency: -$1,234 (red), "[$$-409]#,##0;[RED]-[$$-409]#,##0"<br></div><div><div>Currency: -$1,234.00 (red), "[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00"<br></div><div>Currency: -$1,234.-- (red), "[$$-409]#,##0.--;[RED]-[$$-409]#,##0.--"<br></div><div>Currency: -1,234.00 USD (black), "#,##0.00 [$USD];-#,##0.00 [$USD]"<br></div><div>Currency: -1,234.00 USD (red), "#,##0.00 [$USD];[RED]-#,##0.00 [$USD]"<br></div><div>Currency: -$1,234 (black), "[$$-409]* #,##0;-[$$-409]* #,##0"<br></div></div><div>Currency: -$1,234.00 (black), "[$$-409]* #,##0.00;-[$$-409]* #,##0.00"<br><br></div><div>Date: 12/31/99, "M/D/YY"<br></div><div>Date: Friday, December 31, 1999, "NNNNMMMM DD, YYYY"<br></div><div>Date: 12/31/99, "MM/DD/YY"<br></div><div>Date: 12/31/1999, "MM/DD/YYYY"<br></div><div>Date: Dec 31, 99, "MMM D, YY"<br></div><div>Date: Dec 31, 1999, "MMM D, YYYY"<br></div><div>Date: 31. Dec. 1999, "D. MMM. YYYY"<br></div><div>Date: December 31, 1999, "MMMM D, YYYY"<br></div><div>Date: 31. December 1999, "D. MMMM YYYY"<br></div><div>Date: Fri, Dec 31, 99, "NN, MMM D, YY"<br></div><div>Date: Fri 31/Dec 99, "NN DD/MMM YY"<br></div><div>Date: Fri, December 31, 1999, "NN, MMMM D, YYYY"<br></div><div>Date: Friday, December 31, 1999, "NNNNMMMM D, YYYY"<br></div><div>Date: 12-31, "MM-DD"<br></div><div>Date: 99-12-31, "YY-MM-DD"<br></div><div>Date: 1999-12-31, "YYYY-MM-DD"<br></div><div>Date: 12/99, "MM/YY"<br></div><div>Date: Dec 31, "MMM DD"<br></div><div>Date: December, "MMMM"<br></div><div>Date: 4th quarter 99, "QQ YY"<br></div><div>Date: 1, "WW"<br></div><div>Date: 12/31/99 01:37 PM, "MM/DD/YY HH:MM AM/PM"<br></div><div>Date: 12/31/1999 13:37:46, "MM/DD/YYYY HH:MM:SS"<br></div><div>Date: Friday, 22 Tevet 5760, "[~jewish]NNNND MMMM YYYY"<br></div><div>Date: Friday, Tevet 22 5760, "[~jewish]NNNNMMMM D YYYY"<br></div><div><div>Date: Fri Tevet 22 5760, "[~jewish]NN MMMM D YYYY"<br></div>Date: Fri 22 Tevet 5760, "[~jewish]NN D MMMM YYYY"<br></div><div>Date: 22 Tevet 5760, "[~jewish]D MMMM YYYY"<br></div><div>Date: Tevet 22 5760, "[~jewish]MMMM D YYYY"<br></div><div>Date: 22 Tevet, "[~jewish]D MMMM"<br></div><div>Date: Tevet 22, "[~jewish]MMMM D"<br></div><div>Date: Tevet 5760, "[~jewish]MMMM YYYY"<br></div><div>Date: Tevet, "[~jewish]MMMM"<br><br></div><div>Time: 13:37, "HH:MM"<br></div><div>Time: 13:37:46, "HH:MM:SS"<br></div><div>Time: 01:37 PM, "HH:MM AM/PM"<br></div><div>Time: 01:37:46 PM, "HH:MM:SS AM/PM"<br></div><div>Time: 876613:37:46, "[HH]:MM:SS"<br></div><div>Time: 37:46.00, "MM:SS.00"<br></div><div>Time: 876613:37:46.00, "[HH]:MM:SS.00"<br></div><div>Time: 12/31/99 01:37 PM, "MM/DD/YY HH:MM AM/PM"<br></div><div>Time: 12/31/1999 13:37:46, "MM/DD/YYYY HH:MM:SS"<br><br></div><div>Scientific: -1.23E+003, "0.00E+000"<br></div><div>Scientific: -1.23E+03, "0.00E+00"<br><br></div><div>Fraction: -1234 1/8, "# ?/?"<br></div><div>Fraction: -1234 10/81, "# ??/??"<br><br></div><div>Boolean Value: TRUE, "BOOLEAN"<br><br></div><div>Text: @, "@"<br></div><span><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div><div><br>
Eike<br>
<br>
--<br>
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.<br>
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A<br>
Better use 64-bit 0x6A6CD5B765632D3A here is why: <a href="https://evil32.com/" rel="noreferrer" target="_blank">https://evil32.com/</a><br>
Care about Free Software, support the FSFE <a href="https://fsfe.org/support/?erack" rel="noreferrer" target="_blank">https://fsfe.org/support/?erack</a><br>
</div></div></blockquote></span></div><br></div></div>
</blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
LibreOffice mailing list<br>
<a href="mailto:LibreOffice@lists.freedesktop.org">LibreOffice@lists.freedesktop.org</a><br>
<a href="http://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">http://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br>
<br></blockquote></div><br></div></div>