Apache OpenOffice (AOO) Bugzilla – Issue 23839
Underlines in user defined number format, accounting underlining
Last modified: 2017-05-20 11:11:49 UTC
There is a user defined number format: _(* #,##0.00_);_(* (#,##0.00);_(* "-"?? _);_(@_), which in Excel, provides for expressing a value with thousands separator, negatives indicated in parentheses () and when used with the underline format, the underline fills the cell to its margins. The same format code in Open Office does everything except alter the behaviour of the underlining and as result only the characters in the cell are underlined. This is really ugly if you're trying to produce presentation quality documents. The alternative is to use the cell border on the bottom, but that means inserting blank columns between the columns of numbers which is really poor sheet design. Is there some other way to achieve underlined adjacent number columns with out having the underlines meet or stuffing extra columns? Is this clear as mud?
Hi Bettina, 1 4 u. Frank
set the target
Just thought I would add a comment. I completely understand what Jeannie is suggesting. This feature is really vital to any CPA's, finance professionals, etc., being able to use OOo for their work. The lack of this feature would be one reason I would not be able to use OOo in a work setting. fwiw, the MS implementation has the underline function automatically recognize a number formatted in the "accounting" or "currency" format and when underlining is applied (of any sort) the underlining is automatically done as Jeannie suggests - filling the cell, not just the contents. Maybe something to consider as the issue is worked on. If you need any examples, I can point you to documents that will show the difference and what Jeannie (and myself now) are suggesting. Thanks, Jeff Causey
*** Issue 31799 has been marked as a duplicate of this issue. ***
Created attachment 29919 [details] Accounting underlining demonstration (Microsoft Excel 2000)
Created attachment 29920 [details] Format->Cell UI and Accounting Underline (Microsoft Excel 2000)
add keyword: ms_interoperability
Summary: "Underlines in user defined number format" --> "Underlines in user defined number format, accounting underlining" to make it more searchable Note: A description of single accounting underlining from an old CSS3 draft. "single line drawn below the bottom of the character, rather than just below the baseline." <http://www.w3.org/TR/2001/WD-css3-text-20010517/#text-underline-props>
Created attachment 30326 [details] (better) example demonstrates three things: accounting underlining, underline stretch to margin, and aligning currency symbol --Excel 2000
Created attachment 30327 [details] Excel 2000 source for previous attachment (#30326)
Created attachment 30328 [details] [replaces incorrect attachment id=30326] demonstrates three things: accounting underlining, underline stretch to margin, and aligning currency symbol -- Excel 2000
Hi Niklas, these RFEs are in your ownership.
cc myself
set target
Created attachment 78433 [details] "raw" (to be applied manually) patch; it implements the requested feature as a proof of concept A function extending patch for the Spreadsheet Processor LibreOffice Calc. It resembles a proof of concept (prototypical implementation) for supporting a "fill-in character" in user defined NumberFormat strings for spreadsheet cells; an asterisk ('*') character which shows up in between double quotes defines the immediately following character to be the fill-in character, which in turn is to be printed repeatedly such that the available cell space is used up. E.g. the user defined number (or currency) format string: $"*-"##0.0# results, when applied (we assume locale en_US) to the value 47.11 in a visible cell content of $----------47.11 (the number of dashes depends on the actual column width). Only one fill-in character definition per number format string is supported. When using standard conditional formatting (i.e. a tripel of format strings for negative values, postitive values and null, respectively) you can define a separate fill-in character per branch; the semicolon (';') separates the components of the tripel. From a typographical perspective you should use a fixed width (i.e. non-proportional) font for typesetting numerical data which is to be shown column-wise. This rule of thumb is twice as relevant when using this kind of "fill-in character" in your user defined number format string.
Created attachment 78434 [details] sample libreoffice 3.5.3 calc file SavedAs "Portable Document" (.pdf)
Created attachment 78435 [details] sample libreoffice 3.5.3 calc file (was used to "demonstrate/validate" during implementation)
Reset assigne to the default "issues@openoffice.apache.org".