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

    Formula in Excel Sheet shows #VALUE!.

    bhatt t

      Hi,

      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.

      Bhatt.