You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/08 18:02:00 UTC

[Bug 124207] New: Table Converts Percent number to an imprecise proxy

https://issues.apache.org/ooo/show_bug.cgi?id=124207

            Bug ID: 124207
        Issue Type: DEFECT
           Summary: Table Converts Percent number to an imprecise proxy
           Product: Writer
           Version: 4.0.0
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: samjennings@hotmail.com
                CC: issues@openoffice.apache.org

Steps:
Make a table in OpenOffice.
Add an integer number followed by a percent.
(For example, 43%)

Observe:
Openoffice converts the number to 
43.00%

This is highly undesirable behavior.  People often use an approximate (or
rounded) percentage and do not intend significant digits beyond the rounding. 
Therefore, in each such case (literally 99% of the time) OpenOffice is forcing
their table data to be wrong.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124207] Table Converts Percent number to an imprecise proxy

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124207

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |elish@apache.org
             Latest|---                         |4.1-dev
    Confirmation on|                            |
     Ever confirmed|0                           |1

--- Comment #1 from Edwin Sharp <el...@apache.org> ---
IMHO the default behavior should be leave 43% as is.
AOO410m1(Build:9750)  -  Rev. 1565724
Rev.1565724
Win 7

Return to 43% by: right click - Number Format... - Options - Decimal places=0

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124207] Number Format number of decimals for Table Cells and Fields can not be predefined via Styles

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124207

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |UNCONFIRMED
                 CC|                            |rainerbielefeld_ooo_qa@biel
                   |                            |efeldundbuss.de
            Summary|Table Converts Percent      |Number Format number of
                   |number to an imprecise      |decimals for Table Cells
                   |proxy                       |and Fields can not be
                   |                            |predefined via Styles
     Ever confirmed|1                           |0
           Severity|normal                      |trivial

--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
This problem is not limited to Writer Tables, similar default setting in Calc.

There is a workaround (of course, the same as Edwin told) in the forum:
<https://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=39060>

The current behavior probably is intended, generally default format seems to be
2 decimals. In Calc that can be modified easily in Default-Style, but I
currently do not know how to do something similar in Writer.

The issue does not only affect Number Values in Writer tables, but also Fields,
so related Text document calculation, possibly more. 
Currently this one is more or less WONTFIX, there will not be a particular
"show percent in Table without decimals by default" fix. Next one wants 1
Decimal? The costs really are to high for a feature what can simply be replaced
by the mentioned workaround 

But indeed, some enhancement would be fine, IMHO we need a possibility to
predefine Number styles in Writer. But what does ODF tell? Or may be it's
already possible and we only don't know? We will have to check that before we
can ask for a fix.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124207] Number Format number of decimals for Table Cells and Fields can not be predefined via Styles

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124207

--- Comment #4 from Sam Jennings <sa...@hotmail.com> ---
I believe the best default behavior is to preserve what the user types.  It's
no trouble at all to add ".00%" after a number if you want it there, but it's a
royal pain in the posterior to remove it when the program insidiously puts it
back.  The feature mentioned above is not obvious to anyone who hasn't asked
about its existence.  Most of your users will get stranded at this point.  The
out of the box behavior is not what a user would want... 

And this is not a feature request, it's a bug report.  I'm 100.00% certain it
is a bug.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Issue 124207] Number Format number of decimals for Table Cells and Fields can not be predefined via Styles

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124207

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
     Ever confirmed|0                           |1
           Severity|trivial                     |minor

--- Comment #5 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO420m1(Build:9800)  -  Rev. 1586681
Rev.1586681
Win 7

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Bug 124207] Table Converts Percent number to an imprecise proxy

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124207

--- Comment #2 from Sam Jennings <sa...@hotmail.com> ---
(In reply to Edwin Sharp from comment #1)
> IMHO the default behavior should be leave 43% as is.
> AOO410m1(Build:9750)  -  Rev. 1565724
> Rev.1565724
> Win 7
> 
> Return to 43% by: right click - Number Format... - Options - Decimal places=0

Thank you.  At least there's a viable workaround.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.