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 2020/03/12 20:12:47 UTC
[Issue 128336] New: Golf handicap differential calculation errors
https://bz.apache.org/ooo/show_bug.cgi?id=128336
Issue ID: 128336
Issue Type: DEFECT
Summary: Golf handicap differential calculation errors
Product: Calc
Version: 4.1.7
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: help
Assignee: issues@openoffice.apache.org
Reporter: ranscott@optonline.net
Target Milestone: ---
Created attachment 86898
--> https://bz.apache.org/ooo/attachment.cgi?id=86898&action=edit
My league golf handicap record.
Golf handicap differential calculations show #VALUE! in each cell. I can't find
anything wrong with the formula.
LibreOffice Calc and Microsoft Excel plus Optimum's email view show the
correct results of the calculations.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
--- Comment #3 from Czesław Wolański <cz...@gmail.com> ---
Created attachment 86900
--> https://bz.apache.org/ooo/attachment.cgi?id=86900&action=edit
corrected spreadsheet
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
--- Comment #5 from Czesław Wolański <cz...@gmail.com> ---
Created attachment 86901
--> https://bz.apache.org/ooo/attachment.cgi?id=86901&action=edit
Screenshot from MS Excel 2010
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
--- Comment #4 from Czesław Wolański <cz...@gmail.com> ---
I have done research on your file.
It is stored in Excel 97-2003 format. When I open it in MS Excel 2010
(compatibility mode) and switch to editing mode, for each cell with "number"
I see tooltip (help text):
"The number in this cell is formatted as text or preceded by an apostrophe".
(see attached screenshots from Excel 2010, file "Apostrophe")
Therefore OpenOffice is not to blame - something is wrong with your file.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
Czesław Wolański <cz...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |czeslaw.wolanski@gmail.com
--- Comment #1 from Czesław Wolański <cz...@gmail.com> ---
Hi,
It seems AOO Calc treats a number as text in a cell formatted as number.
For example: if you edit cell E1, you will see in the input line of formula
bar: "'103" instead of "103".
Look at the following link:
https://www.ryananddebi.com/2009/11/29/remove-apostrophes-before-numbers-in-openoffice-calc/
where you will find a detailed procedure under "The Solution" section:
"There is a solution for this. It involves a “find and replace” function.
[...]"
If you follow it precisely, as I did, you should regain your calculation: cell
Z9 = 19.288
However if you are looking for explanation, you shall ask someone wiser than
me.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |knmc@apache.org
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
--- Comment #2 from Czesław Wolański <cz...@gmail.com> ---
See attached file "FIXED" - your data seems OK.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128336] Golf handicap differential calculation errors
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128336
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |oooforum@free.fr
Resolution|--- |NOT_AN_OOO_ISSUE
--- Comment #6 from oooforum (fr) <oo...@free.fr> ---
Wrong place: this tool is dedicated to reporting bugs and not to provide help.
--
You are receiving this mail because:
You are the assignee for the issue.