[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 Qubit changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME CC||qu...@runcibility.com --- Comment #12 from Qubit --- (In reply to comment #7) > That solves that problem, BUT that format must be added to the list of > available Currency formats category permanently. Another option is the > "Add" button add the format to the list so it is always there. > > Until they fix the list of formats, this should remain open. This notation is possible, and bug 63536 is now labeled as an enhancement and has status: NEW, so resolving this bug as WORKSFORME. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 ign_christian changed: What|Removed |Added CC||ign_christ...@yahoo.com See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=66089 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 ign_christian changed: What|Removed |Added CC||rico_samangg...@yahoo.co.id --- Comment #11 from ign_christian --- *** Bug 48810 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #10 from PhilC2K --- At the very least, add this to the Currency list of formats, or create an Accounting category: [$$-409]* #,##0.00_);[RED][$$-409]* (#,##0.00);[$$-409]* -_) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #9 from Michael Adams --- (In reply to comment #8) > (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 .. > Of course, my ideas and reasoning are hardly definitive :). Also, once I've thought more, why couldn't we get rid of the (to me) silly locale number code idea? Isn't "en_us" *better* (more self documenting) than "409"? Wouldn't "[$#-en_us]* #,##0.00;[RED][$#-en_us]* (#,##0.00);[$#-en_us]* -##;@", to roll-up my "complete" idea as a concrete example, be more understandable? After all, computers and programs exist to assist with the repetitive and mundane so why shouldn't Calc figure out what the locale number for "en_us" (e.g.) is and just "do the right thing"? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #8 from Michael Adams --- (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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #7 from PhilC2K --- 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]* -##;@ That solves that problem, BUT that format must be added to the list of available Currency formats category permanently. Another option is the "Add" button add the format to the list so it is always there. Until they fix the list of formats, this should remain open. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #6 from Michael Adams --- I'm thinking this need to be marked "RESOLVED - DUPLICATE" referencing this bug: https://bugs.freedesktop.org/show_bug.cgi?id=34943 I'd have done so, except I'd kind of like a second opinion from an actual LO dev... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 PhilC2K changed: What|Removed |Added Priority|medium |high --- Comment #5 from PhilC2K 2012-05-27 06:42:21 PDT --- This is NOT some mundane enhancement, this is a major DEFICIENCY since the days of OOo 1.1 Beta2 of basic functionality! This kind of thing goes straight to the heart of our acceptance and credibility in the eyes of the adopters. Imagine how serious we would be taken if you could not full-justify text in Writer. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 Roman Eisele changed: What|Removed |Added Severity|major |enhancement --- Comment #4 from Roman Eisele 2012-05-26 09:25:33 UTC --- This is a feature/enhancement request, therefore changing the Importance field accordingly. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #3 from Andrea Pescetti 2012-05-08 14:53:22 PDT --- For the record: the corresponding OpenOffice issue, that has some more background information, is https://issues.apache.org/ooo/show_bug.cgi?id=15773 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #2 from Lionel Dricot 2012-04-24 02:04:24 PDT --- Could you confirm that, in order to fix this bug, there should be a new "accounting" format (adding a button next to the "currency" format) which have the following properties: a) alligning the currency symbol on the left b) replacing 0 value by a dash. c) putting negative numbers between parenthesis. I'm not sure about the color. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 45780] Accounting notation FORMATTING
https://bugs.freedesktop.org/show_bug.cgi?id=45780 --- Comment #1 from Matt Johnson 2012-04-05 15:29:36 PDT --- I just noticed this problem as well as I attempt to move my organization toward more FOSS solutions. I'm grabbing the git repository right now and going to see if I can fiddle with the code a bit and help out. I'm new to this project, so I'm not sure how to make sure I get notified of any changes to it, but I clicked the 'Add me to CC' Please let me know if there's more to that part of it. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
