0 Replies Latest reply on Jul 25, 2013 8:30 AM by bhatt t

    Formula in Excel Sheet shows #VALUE!.

    bhatt t


      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.