Search
Sort Score
Result 10 results
Languages All
Labels All
Results 3,061 - 3,070 of 30,493 for

worksheet

(0.1 sec)

  1. Incorrect formula processing - TOCOL and nested...

    Hi We are evaluating upgrading to the latest version of Aspose Cells to take advantage of the support for newer Excel functions. We have found an issue where the formula =TOCOL(SIMPLE_TABLE *(100-MULTIPLIERS),TRUE) retur…...workbook and access the first worksheet Workbook workbook = new Workbook();...Workbook(); Worksheet worksheet = workbook.Worksheets[0]; // Define...

    forum.aspose.com/t/incorrect-formula-processing...
    more..

  2. Specify Maximum Rows of Shared Formula with C++...

    Learn how to specify the maximum rows of shared formula in Excel files using Aspose.Cells for C++....5 ); // Access first worksheet Worksheet ws = wb . GetWorksheets...

    docs.aspose.com/cells/cpp/specify-maximum-rows-...
    more..

  3. 用 JavaScript 通过 C++ 冻结 Excel 工作表的窗格|Documentation

    在本文中，你将学习如何使用 Aspose.Cells for JavaScript 通过 C++ 编程方式冻结 Excel 工作表的窗格。...请使用 Worksheet.freezePanes(number, number...构建工作簿以打开文件或创建一个空文件。 2. 使用Worksheet.freezePanes()方法冻结窗格。 3.保存文件。...

    docs.aspose.com/cells/zh/javascript-cpp/how-to-...
    more..

  4. How to Lock Cells in Excel using C#

    Learn how to lock cells in Excel using C#. This guide provides step-by-step instructions with C# code examples using Aspose.Cells for .NET....first worksheet in the workbook using workbook.Worksheets[0] ....the SetStyle method. Enable worksheet protection with the Protect...

    blog.aspose.com/cells/how-to-lock-cells-in-exce...
    more..

  5. Setting Pivot Table Option - For Empty Cells Sh...

    Learn how to set the "For empty cells show" option in pivot tables using Aspose.Cells with C++....inputFilePath ); // Get the first worksheet WorksheetCollection sheets...= wb . GetWorksheets (); Worksheet sheet = sheets . Get ( 0 );...

    docs.aspose.com/cells/cpp/setting-pivot-table-o...
    more..

  6. 使用 Aspose.Cells 与 C++ 添加 ActiveX 控件|Documentation

    学习如何使用 Aspose.Cells for C++ 编程方式向 Excel 工作表添加 ActiveX 控件。...wb ; // Access first worksheet Worksheet sheet = wb . GetWorksheets...

    docs.aspose.com/cells/zh/cpp/add-activex-contro...
    more..

  7. 获取条件格式中使用的图标集、数据条或颜色比例对象（适用于C++）|Documentation

    Aspose.Cells for C++ 是一个用于操作电子表格文件的库。它支持在条件格式中使用图标集、数据条和颜色刻度对象以显示电子表格中的数据。本文介绍如何使用 Aspose.Cells 库获取这些对象的数据。...Get the first worksheet in the workbook Worksheet sheet = workbook...

    docs.aspose.com/cells/zh/cpp/get-icon-sets-data...
    more..

  8. 使用C++处理形状或图表的阴影效果|Documentation

    学习如何使用Aspose.Cells for C++操控形状或图表的阴影效果。...inputFilePath ); // Access first worksheet Worksheet ws = wb . GetWorksheets...

    docs.aspose.com/cells/zh/cpp/working-with-the-s...
    more..

  9. "horizontal" parameter is not working as per ex...

    Hi, we wanted to populate data horizontally for a specific array. So we used a horizontal parameter, but it is not working as expected. Please check the attachment. Thanks horizontal.zip (15.8 KB)...horizontally in your Excel worksheet using Aspose.Cells. To assist...populate data horizontally in a worksheet: using Aspose.Cells; public...

    forum.aspose.com/t/horizontal-parameter-is-not-...
    more..

  10. Verify that Cell Value Satisfies Data Validatio...

    Learn how to verify cell value satisfies data validation rules through the Aspose.Cells for JavaScript via C++ API....first worksheet const worksheet = workbook . worksheets . get...between 10 and 20 const cell = worksheet . cells . get ( "C1" ); //...

    docs.aspose.com/cells/javascript-cpp/verify-tha...
    more..