I have 11gr2 Forms/Reports with Windows Server 2008 64-bit.
I have Excel sheet imported from Oracle Reports with destype=enhancedspreadsheet.
Problem is in my Excel sheet, that when I add formula to multiply two columns, it shows #VALUE! error, which is actually occurs
when we multiply a text column with number column.
Although values in columns in number format (like 8600.000,45.000), it assumes these as text column and when
I re-enter same values in columns manually, formula column shows result without any error.
Is there any settings in REPORTS to avoid this error ?
Thanks with Regards.