Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 27, 2013 8:04 AM by
HFM Report export to Excel changes cell category
Mar 22, 2013 7:54 AM
we just updgrated to version 220.127.116.11 and are noticing some strange behavior coming out of an some HFM reports we are exporting to Excel.
We are trying to sum up some values and are getting #VALUE!. We have to manually change the category settings of all columns in order to enable any Excel formulas. This occurs when values are "-".
We can manually change Excel to reflect the cells to be numbers but there are a lot of reports to change, and on top of this, the prior version of HFM/Reports did not display that issue.
Pls let me know how to resolve this issue.. Many thanks.
This content has been marked as final.
Show 1 reply
Re: HFM Report export to Excel changes cell category
Mar 27, 2013 8:04 AM
in response to
Issue is not with HFM, but with FR Studio and version 18.104.22.168.302. Patch is available.
Patch # 16088101 -- FR 22.214.171.124.303