Troubleshooting
Problem
User opens a separate XLSX spreadsheet, which contains values which (previously) had been created via fGetVal formulae (by running (F9) that report).
Afterwards, user opens a Data Entry form.
User switches back to the original (XLSX) spreadsheet. The values have changed to zero (0).
Symptom
There are other ways of reproducing the problem. One simple/easy way to reproduce it is as follows:
1. Launch main Controller client (CCR.EXE)
2. Click green "X" to launch Excel
3. Click "File - Open" and open a relevant XLSX file
2. Click green "X" to launch Excel
3. Click "File - Open" and open a relevant XLSX file
- This is an XLSX spreadsheet which contains figures previously created via fGetVal formulae (sometimes known as an 'imput file')
- Specifically, it contains several cells which are currently populated with values/figures/data (via fGetVal forumae).
4. Switch back to the main Controller 'classic' client, and click "Company - Data Entry - Reported Values"
5. Choose some parameters, and open any Data Entry (DE) form
5. Choose some parameters, and open any Data Entry (DE) form
6. Now switch back to the "Input file" (the other XLSX file)
- Notice how all the values have changed to zero.
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
ibm11105845