Issue 128336 - Golf handicap differential calculation errors
Summary: Golf handicap differential calculation errors
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: help (show other issues)
Version: 4.1.7
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-12 20:12 UTC by randolph scott
Modified: 2020-03-17 00:28 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
My league golf handicap record. (11.50 KB, application/x-ole-storage)
2020-03-12 20:12 UTC, randolph scott 		no flags Details
corrected spreadsheet (13.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-03-13 19:51 UTC, Czesław Wolański 		no flags Details
Screenshot from MS Excel 2010 (227.50 KB, image/jpeg)
2020-03-14 09:56 UTC, Czesław Wolański 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description randolph scott 2020-03-12 20:12:47 UTC 
Created attachment 86898 [details]
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.
Comment 1 Czesław Wolański 2020-03-13 19:30:24 UTC 
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.
Comment 2 Czesław Wolański 2020-03-13 19:49:45 UTC 
See attached file "FIXED" - your data seems OK.
Comment 3 Czesław Wolański 2020-03-13 19:51:09 UTC 
Created attachment 86900 [details]
corrected spreadsheet
Comment 4 Czesław Wolański 2020-03-14 09:55:25 UTC 
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.
Comment 5 Czesław Wolański 2020-03-14 09:56:10 UTC 
Created attachment 86901 [details]
Screenshot from MS Excel 2010
Comment 6 oooforum (fr) 2020-03-16 11:09:06 UTC 
Wrong place: this tool is dedicated to reporting bugs and not to provide help.