incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 23839] Underlines in user defined number format, accounting underlining
Date Thu, 21 Jun 2012 22:41:55 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=23839

--- Comment #15 from johann messner <johann.messner@hotmail.com> ---
Created attachment 78433
  --> https://issues.apache.org/ooo/attachment.cgi?id=78433&action=edit
"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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

Mime
View raw message