Category News

更精確地計算複雜公式

10月 28, 2024
ONLYOFFICE Docs v8.2 為迴圈引用和其它複雜的公式添加反覆運算計算，否則會產生錯誤。

ONLYOFFICE Docs is a comprehensive online editor, allowing users to create text documents, spreadsheets, presentations, and forms. It enables your users to edit, share, and collaborate on documents online in their preferred browser, within your own application. It is fully compatible with OOXML (Office Open XML) formats and supports popular Microsoft Office and other document formats such as CSV, DOC, DOCX, EPUB, HTML, ODP, ODS, ODT, PDF, PPT, PPTX, RTF, TXT, XLS, and XLSX.

The ONLYOFFICE Docs v8.2 update adds support for performing iterative calculations. This enables formulas to be repeatedly recalculated until a specific, stable result is reached or a set number of attempts is made. By setting iteration limits and defining acceptable precision levels, iterative calculations enable users to control the number of recalculations, allowing the formula to reach an approximation or convergence point that serves as the final value. This process is particularly useful when dealing with circular references, where a formula refers to its own cell either directly or through a sequence of references involving other cells. Without iterative calculations, such formulas would produce errors, as they would require an infinite loop of recalculations. This is widely used in scenarios requiring complex dependencies, such as financial projections, engineering simulations, and scientific modeling.

To see a full list of what's new in v8.2.0, see our release notes.

ONLYOFFICE Docs is licensed by the number of simultaneous document connections and is available as an annual license with 1 year support and upgrades. See our ONLYOFFICE Docs licensing page for full details.

For more information, see our ONLYOFFICE Docs product page.

用儲存格合併增強了試算表組織

10月 28, 2024
合併儲存格透過結構良好的佈局增強了試算表的可讀性，並為表格提供了精美、專業的外觀。

Cell merging is a spreadsheet feature that combines two or more adjacent cells into a single, larger cell, creating a unified space for data. This is particularly useful for creating visually organized and readable spreadsheets, allowing headers to span multiple columns or rows, enhancing clarity and alignment in complex data sets. By merging cells, users can create more structured layouts, making the data presentation cleaner and often easier to understand at a glance. For example, in financial reporting or project tracking sheets, merging cells can emphasize titles, group categories, or highlight specific sections of data, adding visual polish. It can also help when building dashboards, forms, and reports where visual hierarchy and structured information flow are essential for end-user readability and comprehension.

Several React spreadsheet controls offer the ability to merge cells including:

  • SpreadJS by MESCIUS allows users to merge spreadsheet cells, enabling a customizable and organized data layout within web applications.
  • Jspreadsheet Pro offers a straightforward cell merging experience that enhances the presentation of grouped or consolidated data in a spreadsheet format.
  • Infragistics Spreadsheet React (part of Ignite UI by Infragistics) provides flexible cell merging capabilities, helping developers create visually cohesive data arrangements.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) supports cell merging for enhanced readability and structure in complex data sheets.

For an in-depth analysis of features and price, visit our React spreadsheet controls comparison.

Compare React Spreadsheet Controls

創建清晰且可自訂的代碼文件

10月 28, 2024
透過符合您專案需求並簡化了流程的詳細文件，實現無縫的代碼維護和協作。

Code documentation features embed comments and annotations within code, helping developers understand its structure and functionality. Many Integrated Development Environments (IDEs) enhance this by automating documentation, offering real-time syntax checks, and enabling quick access to key information like parameters and return types. This improves collaboration, speeds up onboarding, and simplifies maintenance, making the code easier to scale and manage.

Several IDEs provide code documentation functionality including:

  • WebStorm by JetBrains lets you create clear, structured code documentation with integrated JSDoc support, improving readability and providing real-time type hints.
  • Delphi Enterprise by Embarcadero facilitates streamlined documentation, offering built-in tools for documenting complex applications with clear comments and metadata.
  • EiffelStudio by Eiffel Software allows you to generate multi-format, customizable code documentation, ensuring easy maintenance, scalability, and third-party integration.

For an in-depth analysis of features and price, visit our comparison of IDEs.

Compare Integrated Development Environments

用中繼資料增強 PDF 管理

10月 25, 2024
提供對 PDF 中繼資料精細控制的 PDF 元件可以提高輔助功能並簡化文件組織工作流程。

Manipulating PDF metadata unlocks powerful ways to enhance, organize, and standardize document collections. By programmatically editing underlying details such as title, author, keywords, subject, creation date, and modification history, developers can make PDFs more searchable, accessible, and compliant with standards like PDF/A. Effective metadata management transforms PDFs from simple static files into organized, retrievable assets, streamlining workflows and optimizing document handling, especially for businesses managing vast libraries of digital documents.

Several .NET PDF components offer support for manipulating metadata including:

  • Document Solutions for PDF by MESCIUS offers a robust set of tools for comprehensive PDF metadata manipulation.
  • Aspose.PDF for .NET empowers developers with granular control over PDF metadata, allowing you to tailor documents for search engines.
  • IronPDF for .NET provides seamless integration for metadata extraction and modification within .NET applications.
  • PDFlib offers a versatile solution for programmatic PDF metadata manipulation, enabling you to automate tasks and optimize document management.

For an in-depth analysis of features and price, visit our comparison of .NET PDF components.

Compare .NET PDF Components

提供清晰、分層的 XML 文件檢視

10月 25, 2024
XML 檢視器使導航和理解複雜資料結構變得更加容易，從而有助於使用者識別錯誤、不一致性和關係。

XML viewers provide developers with a straightforward way to view, navigate, and occasionally edit the structure and content of XML files through an intuitive interface. By displaying XML data in a hierarchical, tree-like format, they make it easier to understand the relationships between elements and attributes, which is especially valuable when working with complex files. These tools improve readability, support debugging, and help developers quickly identify structural issues or inconsistencies. By visually organizing XML data, XML viewers simplify data management and analysis, speeding up both development and troubleshooting tasks.

Several structured document tools offer an XML viewer including:

  • Oxygen XML Author Professional by Syncro Soft lets you efficiently view and edit XML content with robust validation features.
  • PrimalXML by SAPIEN Technologies allows you to easily visualize, manipulate, and validate XML data with a simple and intuitive UI.
  • Altova XMLSpy Professional XML Editor facilitates advanced XML viewing, editing, and debugging, offering powerful tools for schema and document validation.
  • Stylus Studio XML Professional Suite enables seamless XML viewing, transformation, and validation with a comprehensive set of development and troubleshooting features.

For an in-depth analysis of features and price, visit our structured document tools comparison.

Compare Structured Document Tools