Azure / Azure/azure-sdk-for-python

xlsx number and formula parsing issue

Open
#38,691 3 comments 1 reaction 1 assignee Assigned to @bojunehsu View on GitHub
Client customer-reported Document Intelligence needs-team-attention question Service Attention
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:
![Image](https://github.com/user-attachments/assets/dfc5dc7b-266c-46db-99b0-72084ca42d77)

parsed output:
"page_content\":\"# Sheet1\\ntest\\nint < 10\\nfloat\\n1.5\\nint >= 10\\n10\\n11\\n12\\n13\\n14\\n15\\nsum\\n\"

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.