Suggestion
Rick C. Hodgin
rick.c.hodgin at gmail.com
Tue Jan 26 05:22:41 PST 2016
On Tue, Jan 26, 2016 at 5:50 AM, Eike Rathke <erack at redhat.com> wrote:
> Hi Rick,
>
> On Monday, 2016-01-25 16:26:53 -0500, Rick C. Hodgin wrote:
>
> > On Mon, Jan 25, 2016 at 3:21 PM, Rick C. Hodgin <rick.c.hodgin at gmail.com
> >
> > > On Tue, Jan 12, 2016 at 8:00 AM, Eike Rathke <erack at redhat.com> wrote:
> > >> On Friday, 2016-01-08 19:52:49 -0500, Rick C. Hodgin wrote:
> > >>
> > >> > The category is called *"Metric."*
> > >> >
> > >> > When conveying fractional values, such that 1.2345E-08 (which is
> > >> > 0.000,000,012,345), it would do so in a metric-relative way using
> the
> > >> > standard milli (10^-3), micro (10^-6), nano (10^-9), pico (10^-12),
> and
> > >> so
> > >> > on...
> > >> >
> > >> > In the example, the *Metric* display would cause the value to show
> up
> > >> > as "*12,345
> > >> > pu*" (pico-units) if the thousands separator was used.
> > >>
> > >> Could you give some examples what you think how the format code
> actually
> > >> should look like?
> > >>
> > > Eike, I never heard back from you after my reply.
> > >
> > > The format would be "Metric" with "Metric:seconds" given for a specific
> > > override for the units name. And there are a few other options that I
> > > would like to append including a bias that the data may already be in,
> such
> > > as kilo-units ("Metric[:seconds][:bias=kilo]") and an override base to
> use,
> > > such as always displaying in milli-units
> > > ("Metric[:seconds][:bias=kilo][affix:milli]").
> > >
> >
> > Please forgive my dyslexia. It should be:
> > Metric[:seconds][:bias=kilo][:affix=milli]
> >
> > Each of the [] portions are optional, and would actually appear in a form
> > like this:
> >
> > Metric:seconds:bias=kilo:affix=milli
>
> I don't see how that would fit into the existing number format code
> syntax. It looks like something completely different.
>
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.
It would be applied using this type of logic (given in easily
human-readable form):
if (string.lowercase().beginsWith("metric")) {
// "Metric" parsing
} else {
// Use the existing code for other format parsing
}
I'm open to suggestions. What do you propose?
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
And if they used the default "units" then it would simply be:
Metric:B-K:A-M
-----
Number: General, "General"
Number: -1234, "0"
Number: -1234.12, "0.00"
Number: -1,234, "#,##0"
Number: -1,234.12, "#,##0.00"
Number: -1,234.12, "#,###.00"
Number: (1,234), "#,##0_);(#,##0)"
Number: (1,234.12), "#,##0.00_);(#,##0.00)"
Percent: -13%, "0%"
Percent: -12.95%, "0.00%"
Currency: -$1,234 (black), "[$$-409]#,##0;-[$$-409]#,##0"
Currency: -$1,234.00 (black), "[$$-409]#,##0.00;-[$$-409]#,##0.00"
Currency: -$1,234 (red), "[$$-409]#,##0;[RED]-[$$-409]#,##0"
Currency: -$1,234.00 (red), "[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00"
Currency: -$1,234.-- (red), "[$$-409]#,##0.--;[RED]-[$$-409]#,##0.--"
Currency: -1,234.00 USD (black), "#,##0.00 [$USD];-#,##0.00 [$USD]"
Currency: -1,234.00 USD (red), "#,##0.00 [$USD];[RED]-#,##0.00 [$USD]"
Currency: -$1,234 (black), "[$$-409]* #,##0;-[$$-409]* #,##0"
Currency: -$1,234.00 (black), "[$$-409]* #,##0.00;-[$$-409]* #,##0.00"
Date: 12/31/99, "M/D/YY"
Date: Friday, December 31, 1999, "NNNNMMMM DD, YYYY"
Date: 12/31/99, "MM/DD/YY"
Date: 12/31/1999, "MM/DD/YYYY"
Date: Dec 31, 99, "MMM D, YY"
Date: Dec 31, 1999, "MMM D, YYYY"
Date: 31. Dec. 1999, "D. MMM. YYYY"
Date: December 31, 1999, "MMMM D, YYYY"
Date: 31. December 1999, "D. MMMM YYYY"
Date: Fri, Dec 31, 99, "NN, MMM D, YY"
Date: Fri 31/Dec 99, "NN DD/MMM YY"
Date: Fri, December 31, 1999, "NN, MMMM D, YYYY"
Date: Friday, December 31, 1999, "NNNNMMMM D, YYYY"
Date: 12-31, "MM-DD"
Date: 99-12-31, "YY-MM-DD"
Date: 1999-12-31, "YYYY-MM-DD"
Date: 12/99, "MM/YY"
Date: Dec 31, "MMM DD"
Date: December, "MMMM"
Date: 4th quarter 99, "QQ YY"
Date: 1, "WW"
Date: 12/31/99 01:37 PM, "MM/DD/YY HH:MM AM/PM"
Date: 12/31/1999 13:37:46, "MM/DD/YYYY HH:MM:SS"
Date: Friday, 22 Tevet 5760, "[~jewish]NNNND MMMM YYYY"
Date: Friday, Tevet 22 5760, "[~jewish]NNNNMMMM D YYYY"
Date: Fri Tevet 22 5760, "[~jewish]NN MMMM D YYYY"
Date: Fri 22 Tevet 5760, "[~jewish]NN D MMMM YYYY"
Date: 22 Tevet 5760, "[~jewish]D MMMM YYYY"
Date: Tevet 22 5760, "[~jewish]MMMM D YYYY"
Date: 22 Tevet, "[~jewish]D MMMM"
Date: Tevet 22, "[~jewish]MMMM D"
Date: Tevet 5760, "[~jewish]MMMM YYYY"
Date: Tevet, "[~jewish]MMMM"
Time: 13:37, "HH:MM"
Time: 13:37:46, "HH:MM:SS"
Time: 01:37 PM, "HH:MM AM/PM"
Time: 01:37:46 PM, "HH:MM:SS AM/PM"
Time: 876613:37:46, "[HH]:MM:SS"
Time: 37:46.00, "MM:SS.00"
Time: 876613:37:46.00, "[HH]:MM:SS.00"
Time: 12/31/99 01:37 PM, "MM/DD/YY HH:MM AM/PM"
Time: 12/31/1999 13:37:46, "MM/DD/YYYY HH:MM:SS"
Scientific: -1.23E+003, "0.00E+000"
Scientific: -1.23E+03, "0.00E+00"
Fraction: -1234 1/8, "# ?/?"
Fraction: -1234 10/81, "# ??/??"
Boolean Value: TRUE, "BOOLEAN"
Text: @, "@"
> Eike
>
> --
> LibreOffice Calc developer. Number formatter stricken i18n
> transpositionizer.
> GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563
> 2D3A
> Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
> Care about Free Software, support the FSFE https://fsfe.org/support/?erack
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20160126/77297223/attachment.html>
More information about the LibreOffice
mailing list