ongdisheng opened a new pull request, #693: URL: https://github.com/apache/fesod/pull/693
<!-- Thanks very much for contributing to Apache Fesod (Incubating)! Please make sure that your code changes are covered with tests. And in case of new features or big changes remember to adjust the documentation. Feel free to ping committers for the review! In case of an existing issue, reference it using one of the following: Closed: #ISSUE Related: #ISSUE --> Related: #571 #272 ## Purpose of the pull request <!-- Describe the purpose of this pull request. For example: Closed: #ISSUE--> This PR adds support for reading shared formulas from XLSX files. Currently, when there are shared formulas in the file, Fesod cannot read the formula text from reference cells. This results in missing formula information for users who need to extract formulas from their Excel data. ## What's changed? <!--- Describe the change below, including rationale and design decisions --> This PR implements shared formula support by leveraging Apache POI's formula conversion utilities. When parsing XLSX files, the code now detects shared formulas by checking for the shared type attribute and shared index attribute in the formula XML tags. For master cells that contain the actual formula text, the formula and its position are stored in a map. For reference cells that only contain a shared index, the code retrieves the master formula and converts it to the cell-specific formula by calculating row and column offsets using Apache POI's [SharedFormula](https://poi.apache.org/apidocs/dev/org/apache/poi/ss/formula/SharedFormula.html) conversion method. A comprehensive unit test with various formula types has been added to verify the functionality, following the test cases referenced in PR #581. ## Checklist - [ ] I have read the [Contributor Guide](https://fesod.apache.org/community/contribution/). - [ ] I have written the necessary doc or comment. - [ ] I have added the necessary unit tests and all cases have passed. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
