Search
Sort Score
Result 10 results
Languages All
Labels All
Results 41 - 50 of 4,142 for

excel formula api

(0.02 sec)

  1. Shared Formula gives wrong result for condition...

    Hi, If I try to use the IF condition in SharedFormula the output result is wrong while setting the Formula through code. If I use the Formula manually in Excel gets the correct output. For example: cells[“H2”].SetShar…...Shared Formula gives wrong result for condition Aspose.Cells...calculate-formula , cells-net , set-shared-formula kiran5388...

    forum.aspose.com/t/shared-formula-gives-wrong-r...
    more..

  2. Cell object - Formula and Value setters are int...

    Hello, I have encountered a problem after a recent update for Aspose.Cells for .NET, from version 6.0.0.0 to 7.0.2.0. The problem is related to cell Formulas/values - in this new version, it seems that the Formula and V…...Cell object - Formula and Value setters are interfering one with...problem is related to cell formulas/values - in this new version...

    forum.aspose.com/t/cell-object-formula-and-valu...
    more..

  3. Manage formulas of Excel files|Documentation

    Aspose.Cells can simply get, set and calculate Formulas of Excel files....Svenska Türkçe 日本語 Manage formulas of Excel files Contents [ Hide...Introduction One of the of Microsoft Excel’s compelling features is its...

    docs.aspose.com/cells/net/using-formulas-or-fun...
    more..

  4. EOMONTH formula/function calculation error on R...

    Hi. We have found, that function EOMONTH in some case calculates wrong. Please check following code examples: @Test public void eomonth_success_test() throws Exception { Workbook workbook = new Workbook("C://in.xlsx"); …...EOMONTH formula/function calculation error on Russian locale...Aspose.Cells Product Family formula-calculation makarovalv September...

    forum.aspose.com/t/eomonth-formula-function-cal...
    more..

  5. Calculate the cells using formula and data pres...

    Hello Aspose, I have a source workbook where I have two sheets named ‘Data’ and ‘Calculations’. using Aspose I will copy these, calculate and export the output Excel. In ‘Data’ sheet I will add dynamic data using code a…...Calculate the cells using formula and data present in other sheet...calculate and export the output excel. In ‘Data’ sheet I will add...

    forum.aspose.com/t/calculate-the-cells-using-fo...
    more..

  6. Formula Evaluation is not working as expected g...

    Hi Team, I have a workbook with almost 3000 Formulas. I am evaluating entire workbook through Aspose.cells (in java frame work with Aspose.cells 7.4.2 licensed version) after writing new inputs to the Excel workbook. I …...Formula Evaluation is not working as expected giving wrong result...workbook with almost 3000 formulas. I am evaluating entire workbook...

    forum.aspose.com/t/formula-evaluation-is-not-wo...
    more..

  7. #NUM! inside FV(NPER()) formula causes evaluati...

    Hi, I have an example worksheet with the following Formula at cell A1: =FV(0.05/12,NPER($A$2/12,$B$2,-$C$2-IF(FALSE,$C$2,0),0,0),0,-400000,0) The NPER(…) part evaluates to #NUM! in Excel, resulting in the entire formu…... inside FV(NPER()) formula causes evaluation error Aspose...worksheet with the following formula at cell A1: =FV(0.05/12,NPER($A$2/12...

    forum.aspose.com/t/num-inside-fv-nper-formula-c...
    more..

  8. Calculate formula with SUMIF using Aspose.Cells...

    Hello, We have an Excel date Formula that when computed by Aspose with CalculateFormula gives a different result then the result from Excel 2013. Sample Code: var workbook = new Workbook(“SUMIF.xlsx”); …...Calculate formula with SUMIF using Aspose.Cells for .NET in C#...Cells Product Family sumif-in-excel ibmromania February 11, 2020...

    forum.aspose.com/t/calculate-formula-with-sumif...
    more..

  9. Export Formula from a Range - Aspose.Cells Prod...

    Dear Sir, Currently we are in a process of converting Interop.Excel with Aspose.cells. We have a requirement to export the Formulas & values in a range to an array. Do we have any methods to do this in aspose.cells. I …...Export Formula from a Range Aspose.Cells Product Family Anishc...process of converting Interop.Excel with Aspose.cells. We have a...

    forum.aspose.com/t/export-formula-from-a-range/...
    more..

  10. How to apply formula to pivot table data ysing ...

    Hi All, I am having sheet which shows the data for employees Shift wise. I have used the pivot table to show the data employee wise.. the problem is wherever I am using Consolidation Function as SUM the data is coming…...How to apply formula to pivot table data ysing C# Aspose.Cells...how to calculate or apply formulas in pivot table.. I tried pivotTable...

    forum.aspose.com/t/how-to-apply-formula-to-pivo...
    more..