can you please explain your question as its not clear.
whether you are connecting to Essbase or Planning , which version etc and what you are trying to do ?\
Sorry about the confusion. I am connected to Essbase using Smart View Version 220.127.116.11.200 and I am trying to submit data for upload.
In the worksheet that I am trying to submit I have formatted all of the cells to be the Accounting number format (excel formatting option), a few cells were accidently changed to the currency format which inserted the dollar sign.
When I tried to submit the worksheet, all of the data values were uploaded except for the one cell that had the currency format. Below you can see the 15,000 in June was submitted but the 5,000 did not because of the formatting.
Jan Feb Mar Apr May Jun Forecast Forecast Forecast Forecast Forecast Forecast Working Working Working Working Working Working FY14 FY14 FY14 FY14 FY14
Labor Reg - Budget Fcst Adj ENT.32.6980 - - - - - 15,000 Labor OT - Budget Fcst Adj ENT.32.6980 - - - - - - Emp Benefits Health Plans - Budget Fcst
ENT.32.6980 - - - - - $5,000.00
The dollar sign or text didn't submitted as its text and the DataType for your account is number , so it will not store text value even if you try to enter.
I hope that clarifies.
The currency formatting isn't text though. If you look in the cell text/formula bar, the only thing that appears is the number, not the $. I don't understand why Smart view would recognize it as text?
In the old Essbase Add-In the same cell is successfully submitted, what is different with Smart View?
The data should submit with that format. If it does not, It sounds like a bug and you should submit an SR to Oracle. I've not tried it with 18.104.22.168.200 but it worked in older versions. You could also check, there is a version22.214.171.124.210 out now, I didn't see a solution for this issue in the readme, but you might try it