https://bugs.freedesktop.org/show_bug.cgi?id=45780
--- Comment #8 from Michael Adams <[email protected]> --- (In reply to comment #7) > I see that they implemented the M$ method of repeating fill characters. The > resulting LO format for the financial accounting format wold be: > [$$-409]* #,##0.00;[RED][$$-409]* (#,##0.00);[$$-409]* -##;@ ...... > Until they fix the list of formats, this should remain open. Agreed. It would also be nice if the "[$nnn-xxx]" specifier could be *extended* so that just "[$#-#]" (typed typed like that) would mean: Just give me the current currency symbol in the current locale, /whatever/ it is. Replacing the first "#" with a symbol would mean: Give me the current currency symbol in the current locale, if none, use what's listed in place of the first "#". My reasoning for the use of "#" was that, in general numeric formatting, "#" is: if there is a number for this "spot" use it, else omit it. That is, if we aren't in a defined locale (??) or the locale doesn't specify a currency symbol, we omit the symbol. My reasoning for the introduction of such a "short-hand" is simple laziness! One less item to have to look up or remember (what *is* the locale number of "de_ch" in LO again?). Of course, my ideas and reasoning are hardly definitive :). All my financial reporting sheets and most of those companies/persons I exchange such data with are all in the same locale (en_us). I think that would be a nice shorthand for those of us that do not (currently) require multi-locale support, while supporting a graceful way to "place-hold" the specifier for when/if that requirement *does* change. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
