tracker issue : CF-4206915

select a category, or use search below
(searches all categories and all time range)

SpreadsheetGetValue returns a "-"

| View in Tracker

Status/Resolution/Reason: To Track//NeedMoreInfo

Reporter/Name(from Bugbase): Mike F. / ()

Created: 01/29/2020

Components: Document Management, Spreadsheet

Versions: 2018

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2018.0.06.316308 /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2016

Vote Count: 0

Problem Description: the spreadsheetgetvalue returns a '-' when I call it.  the cell has a formula which displays a number.  When I call spreadsheetgetformula it works correctly.  When I run the same code and same file on CF2016 it works correctly.

Steps to Reproduce: 

Actual Result:  returns  - 

Expected Result: It should return a numerical value as a string

Any Workarounds: None



Mike, Can you pls. share the formula or the spreadsheet and the test cfm script that you are using . I don't so the issue on CF 2018 update 7. I'm attaching the test script and the spreadsheet I used.
Comment by Piyush K.
33109 | February 13, 2020 06:45:59 AM GMT