Azure / Azure/azure-sdk-for-python
xlsx number and formula parsing issue
- Dominant language
- Python
- Stars
- 5.6k
- Forks
- 3.4k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 193
Description
- **Package Name**: azure-ai-documentintelligence
- **Package Version**: 1.0.0b4
- **Operating System**: Windows
- **Python Version**: Python 3.11.0
**Describe the bug**
When parsing a .xlsx file with begin_analyze_document() function and the prebuilt-layout model, numbers smaller than 10 are not parsed. However, decimal numbers smaller than 10 are parsed. Cells containing values that comes from excel formulas are not parsed either.
**To Reproduce**
Steps to reproduce the behavior:
1. Create a .xlsx file with numbers smaller than 10 and a cell containing a formula
2. Parse the file
3. check parsing output
**Expected behavior**
Numbers smaller than 10 and formula cells should be parsed. The parsed output should be as follow:
"page_content\":\"# Sheet1\\ntest\\nint < 10\\n1\\n2\\n3\\n4\\n5\\n6\\n7\\n8\\n9\\nfloat\\n1.5\\nint >= 10\\n10\\n11\\n12\\n13\\n14\\n15\\nsum\\n121.5\\n\"
**Screenshots**
excel sheet:

parsed output:
"page_content\":\"# Sheet1\\ntest\\nint < 10\\nfloat\\n1.5\\nint >= 10\\n10\\n11\\n12\\n13\\n14\\n15\\nsum\\n\"
Contributor guide
Assessment
This issue has not been assessed yet.