v4.0.0-alpha.1

Prerelease: OpenXML-Office v4.0.0-alpha.1

I are thrilled to announce the v4.0.0-alpha.1 prerelease of openxml-office, marking a major milestone in the journey toward v4. This release introduces Excel document creation and cell data manipulation as the initial focus, laying the groundwork for a robust, multi-language supported OpenXML library.

Key Highlights

• Excel Support:
  • Create new Excel files.
  • Update cell data with improved performance and flexibility.
  • Leverages Rust's safety and speed for handling large datasets.

XML parsing and data processing handling is long way to go, At present SQLite is doing some lifting behind the scene. This will be updated by next itration for performance and memory optimisation

• Starting Point for v4 Development:
  This alpha release is the foundation for a complete overhaul of the library, focusing on modularity and performance improvements.

Roadmap for v4

• C# Integration and NuGet Release:

  • Native support for C# developers, enabling seamless integration.
  • Planned for an upcoming release in the v4 development cycle.

• Python Integration:

  • Following C#, Python will be the next supported language to broaden accessibility.

We welcome feedback, testing, and contributions to shape the future of openxml-office.

🚀 Try it out and help us make v4 exceptional!

GitHub: DraviaVemal/openxml-office

v3.0.0-Alpha.16

What's Changed

• Bump Microsoft.NET.Test.Sdk from 17.10.0 to 17.11.0 by @dependabot in #111
• Readme update by @DraviaVemal in #112
• Word document by @DraviaVemal in #113
• Word update by @DraviaVemal in #114
• Bump actions/download-artifact from 2 to 4.1.7 in /.github/workflows in the github_actions group across 1 directory by @dependabot in #115
• Pipeline actions version update by @DraviaVemal in #116
• Content update by @DraviaVemal in #117
• pipeline update by @DraviaVemal in #118
• Organizing outline to fille the component control and analyzing share… by @DraviaVemal in #119
• pipeline update by @DraviaVemal in #120
• Update nuget-publish-alpha.yml by @DraviaVemal in #121

Full Changelog: v2.9.0...v3.0.0-Alpha.16

v2.9.0

v2.9.0

I’m excited to announce the release of OpenXML-Office version 2.9.0. This update introduces several enhancements and new features aimed at improving the stability and functionality of the Excel package.

Key Features and Enhancements

Test Coverage

• Enhanced Stability: I’ve updated the test coverage to improve the overall stability of the software. This enhancement aims to ensure a more reliable performance across various modules and scenarios.

Excel Package

• View Setting Options: Added new options to customize view settings to sheet.
• Active Cell and Sheet Functions: Introduced functions to set the active cell and active sheet, providing better control and navigation within Excel documents.
• Formula Input and Calculation Chain: Added functionality for formula input and a calculation chain to streamline formula management and improve calculation accuracy.

Documentation

• Gitbook Documentation Update: The Gitbook documentation will be updated to reflect these changes as soon as possible. I appreciate your patience and will ensure that the documentation is aligned with the new features and improvements.

Future Release Plans

• Additional Features: Future updates will focus on expanding functionalities and improving existing features based on user feedback and evolving needs.

What's Changed

• Excel Formula Update by @DraviaVemal in #103
• Auto tag code version using actions by @DraviaVemal in #104
• Excel view by @DraviaVemal in #106
• More view options by @DraviaVemal in #108
• Test Coverage update by @DraviaVemal in #110

Full Changelog: v2.8.0...v2.9.0

Thank you for your continued support and contributions to OpenXML-Office. We look forward to delivering more enhancements in upcoming releases!

v2.8.0

v2.8.0

I’m thrilled to introduce the stable release of OpenXML-Office version 2.8.0. This update brings a host of improvements and new features designed to enhance the Presentation module and optimize the Excel module.

Key Features and Enhancements

Global Package

• Extended Color Settings: We’ve expanded the color setting options across all packages by adding a new generic color setting. This improvement provides greater control and flexibility for color customization, setting the stage for future updates.
• Chart Property Enhancements: The global model now includes several new options, such as axis line color, axis placement, and axis title settings. I’ve also addressed issues with combo chart axes, updated pie chart data points, and refined line chart marker and color options. Additionally, chart theme colors have been fine-tuned, and height and width options have been adjusted for better pixel alignment. New invert color options are now available as well.

Presentation Package

• Shape Details and Table Updates: In the Presentation module, you can now specify and reuse shape details for height and width updates. I’ve also improved table range validation and merge range features. Text options now support bullets, numbering, and paragraph end options.

Excel Package

• Core Reorganization: I’ve reorganized the core of the Excel module to reduce implementation complexity. While no new features have been added in this release, this refactor aims to improve maintainability and performance.

Common Updates to Both Modules

• Improved Test Setup: The test setup has been updated to cover new components, ensuring comprehensive testing and stability of the new features.
• Code Refactoring: Variables and methods have been updated to maintain a consistent code pattern across packages, enhancing overall code quality and maintainability.

Documentation

• Gitbook Documentation Update: My Gitbook documentation is not yet fully updated. I apologize for the delay and will prioritize fixing this as soon as possible.

Future Release Plans

• Enhanced Customization: Future updates will include adding shapes directly to components like slides and sheets.
• Excel Features: I am working on a formula parser for the next major release. Due to a busy schedule, progress on this package may be slower than anticipated.

Your contributions are vital to the evolution of OpenXML-Office, and I’m excited about the advancements I’ll be bringing in future releases. Stay tuned for more updates!

v2.8.0-Alpha.9

This is Pre-Release informing on going change

Bug Fix

• Test suit result upload script fix
• Combo chart axis issues fixed
• Removed irrelevant data label option in series data of pie chart setting
• Height, Width, X and Y related positioning bugs are fixed and reorganised
• Reorganised code to make it simpler
• Presentation table and cell merge update
• Fixed spreadsheet properties the resulted in invalid cells

Features

• Color Option are extended with generic options to give more relavent and detailed options
• Bullets and numbering options are added to the text block
• Updated axis line and ites color option for charts
• Added Anonymous data collection code flow to better understand the requirement priority
• Invert chart color options are added

Documents

• Documentation is not update for v2.8.0 for already completed nor planned item. Please refer the test project code to see the most reacent options

v2.7.5

Release v2.7.5

Bug Fix

• Dependency Updates
• PPT Table Merge
• Trendline cleanup
• Combo chart Axis update

v2.7.0

OpenXMLOffice Stable Release v2.7.0

I'm excited to announce the stable release of OpenXML-Office version 2.7.0. This release brings a host of updates and new features that enhance the functionality and user experience across the Presentation and Excel modules.

Key Features and Enhancements

Presentation Module Updates:

• Theme System Update: The theme system for the edit template has been updated to use the existing multimaster layout, providing a more cohesive and flexible design framework.
• Table Merge Cell Options: Enhanced table functionalities with updated merge cell options, allowing for more robust table manipulations.

Excel Module Updates:

• Edit Excel Update Support: Improved support for shared strings and styles during Excel edits, ensuring data integrity and visual consistency.
• Scatter Type Chart: Full support for scatter type charts, adding to the array of chart options available for users.
• Merge Cell. Full support added to merge cell and remove existing merge range.

Common Updates to Both Modules:

Chart Enhancements:

• Generic Axis Type Option: Updated the axis type option in combo charts to be more generic, improving customization capabilities.
• Generalized Axis Options: Standardized axis options from vertical and horizontal to X and Y, simplifying axis management.
• 3D Bubble Chart Support: Added support for 3D bubble charts, including options for non-size bubble data, expanding data visualization possibilities.
• Value Axis Enhancements: Improved settings for value axis bounds and units, offering more precise control over chart scales.
• Trendline Options: Introduced trendline options within series settings for line charts, allowing for more detailed data analysis.
• Text Options for Axis: Updated text options for axis scales, headers, and titles, enhancing readability and customization.

Hyperlink Integration:

• TextBlock in Textbox: Added hyperlink support.
• Picture Components: Hyperlinks can now be added to picture components.
• TableCell in PPT Table: Hyperlink functionality included.
• DataCell Content in Excel: Enabled hyperlinks for data cells.

Code Refactoring:

• Conducted significant code refactoring to reduce duplication and extend generic options, making the codebase more maintainable and adaptable to future features.

Documentation:

• Gitbook Updates: The Gitbook documentation has been updated to cover most new features and changes. Additional updates are forthcoming to complete the documentation.

Test Coverage:

• Improved Test Coverage: Test coverage has been enhanced across the project with a goal of achieving a minimum of 80% coverage for each file. A status badge has been added to the README to track progress, ensuring the stability of new features.

Future Release Plans:

• Excel Formula Updates: Upcoming releases will focus on improving Excel formula support.
• Multimaster Theme Setup: Further enhancements for multimaster theme setups in presentations.
• Additional Chart Customizations: Plans to add more control options to charts for greater customization capabilities.

Your feedback is crucial in driving the continued improvement of OpenXML-Office. Thank you for your ongoing support and contributions. I look forward to delivering more powerful and user-friendly features in future releases.

v2.6.23

v2.6.23

Presentation Module:

• Edit File, Load & Save bug fix and iDocs.
• Chart embedded excel bugs addressed

Excel Module:

• Edit File, Load & Save bug fix and iDocs.

v2.6.16

v2.6.16

Presentation Module:

• Fixed exception handling related to Data label bug.
• Resolved issue with Slide relation exception.

Excel Module:

• Addressed bug fix for SetRow.

Overall:

• Started publishing debug symbols to NuGet.org for easy debugging and issue reporting.

v2.6.7

OpenXMLOffice Stable Release v2.6.7

I'm thrilled to announce the stable release of OpenXML-Office version 2.x, a significant milestone in functionality and usability. This release incorporates enhancements and features from previous alpha versions, ensuring a robust and user-friendly experience across the Presentation and Excel modules.

Key Features and Enhancements

Presentation Module:

• Extended compatibility from 2013 Office to 2007 Office, broadening the range of applications capable of opening generated files.
• Introduced compatibility updates to ensure seamless integration with various applications.
• Added support for editing existing presentations, enabling users to modify content with ease.
• Added 3D chart support to base charts, including area, bar, column, and pie, enhancing visualization options.
• Extended .net support from net45, check package nuget frameworks for details.
• G Slide and office 365 web based bugs resolved

Spreadsheet Module:

• Extended compatibility from 2013 Office to 2007 Office, broadening the range of applications capable of opening generated files.
• Introduced chart support, empowering users to create and add charts directly to target sheets.
• Added 3D chart support to base charts, including area, bar, column, and pie, enhancing visualization options.
• Resolved issues with misplaced shared strings and old styles, ensuring data integrity and consistency.
• Extended .net support from net45, check package nuget frameworks for details.
• G Sheet and office 365 web based bugs resolved

Documentation:

• Initiated version-based documentation, providing comprehensive guidance on the changes introduced in this release.
• Gitbook documentation is continually updated to reflect the latest features and enhancements.

Mainstream Development Focus:

• Development efforts continue to prioritize Presentation and Excel functionalities, paving the way for future enhancements in these core areas.

Backward Compatibility:

• Committed to ensuring backward compatibility, guaranteeing a smooth transition for users as they adopt new versions of OpenXML-Office.

Deprecation Notice:

• OpenXMLOffice.Excel package is now marked as deprecated. Users are encouraged to migrate to OpenXMLOffice.Spreadsheet package for continued support and enhancements.

Roadmap for Future Releases:

• Ambitious features are planned for future releases, including enhanced Excel functionalities such as formula support and advanced chart capabilities.

Consistency is Key:

• Committed to gradually and consistently updating OpenXML-Office to ensure comprehensive feature coverage based on user feedback and requests.

Your feedback is invaluable in shaping the evolution of OpenXML-Office. I appreciate your continued support as we strive to deliver a robust and user-friendly solution. Thank you for being part of our journey.