Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature Request: Add Support for LibreOffice Calc and Numbers Formats in DRL Parsers #6063

Open
Rashmesh opened this issue Sep 4, 2024 · 0 comments

Comments

@Rashmesh
Copy link
Contributor

Rashmesh commented Sep 4, 2024

Feature Request: Add Support for LibreOffice Calc and Numbers Formats in DRL Parsers

Current Situation:
The DRL parsers in the Apache Incubator KIE Drools project currently only support the XLS format for spreadsheets. This limitation presents two main issues:

  1. The supported XLS format is outdated, leading to frequent upgrade prompts.
  2. Users are restricted to using Microsoft Excel, a paid software solution.

Proposed Change:
We propose expanding the DRL parsers' compatibility to include:

  1. LibreOffice Calc (https://www.libreoffice.org/discover/calc/)
  2. Apple Numbers (https://en.wikipedia.org/wiki/Numbers_(spreadsheet))

Rationale:
Implementing support for these additional spreadsheet formats would bring several benefits:

  1. Increased Compatibility: Users would have more options for creating and editing spreadsheets compatible with DRL parsers.

  2. Wider User Base: By supporting open-source and alternative spreadsheet applications, we can attract users who prefer or are required to use non-Microsoft solutions.

  3. Cost Reduction: Removing the dependency on Microsoft Excel allows users to utilize free, open-source alternatives, potentially reducing software costs for individuals and organizations.

  4. Modern Format Support: This update would address the current issue of prompts to upgrade from the outdated XLS format.

  5. Cross-Platform Accessibility: LibreOffice Calc is available on multiple operating systems, while Numbers caters to the macOS and iOS ecosystems, broadening the project's reach.

Implementation Considerations:

  • The parsing logic may need to be adapted to handle the specific file formats of LibreOffice Calc (.ods) and Numbers (.numbers).
  • Compatibility testing will be crucial to ensure consistent behavior across all supported formats.
  • Documentation updates will be necessary to inform users about the new supported formats.

I believe this enhancement will significantly improve the flexibility and accessibility of the Apache Incubator KIE Drools project, aligning it with modern spreadsheet usage patterns and open-source principles.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: 📋 Backlog
Development

No branches or pull requests

1 participant