xlsx number and formula parsing issue

[Aznath]

• 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"

[l0lawrence]

Hi @Aznath, thanks for the feedback we will get back to you as soon as possible.

[Aznath]

Hi,
In the meanwhile I also realized that cells containing individual letters (lowercase, uppercase, accented (é, è, ç, à, ù) and µ) are not parsed either.

Similar parsing issues occur when parsing pptx documents.

Is not parsed in xlsx documents:

• integers < 10 in individual cell
• individual letter
• images
• cells containing formulas
• text boxs
• plots

Is not parsed in pptx documents:

• integers < 10 in individual text box
• individual letter
• images
• slide footers
• slide notes

interesting observation:
Plots are not parsed when parsing a xlsx document, but they are partially parsed when parsing a pptx document.
Partially because if a plot contains pieces of information such as those that have been identified as non-parsed, those specific pieces of information won't be parsed.