yarg icon indicating copy to clipboard operation
yarg copied to clipboard

Published 20 hours ago • verified publisher icon cuba-platform

Excel sheet getting corrupted after adding formulas to it

Open kkorada opened this issue 6 years ago • 5 comments

Environment

  • YARG version: 2.0.12
  • Client type: Java
  • Browser: Chrome
  • Database: H2
  • Operating system: Windows

Description of the bug or enhancement

  • Minimal reproducible example I have created a template in xlsx file and it is working fine. But when added formulas to it the output file is getting corrupted.

  • Expected behavior It should generated good file and formulas should be copied to other cells

  • Actual behavior Output file is getting corrupted. Please check error below. Removed Records: Formula from /xl/worksheets/sheet1.xml part Removed Records: Shared formula from /xl/worksheets/sheet1.xml part Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

kkorada avatar Jul 05 '18 08:07 kkorada

any update on this, still facing the issue. Please help.

kkorada avatar Jul 12 '18 04:07 kkorada

hi, can u share your template.xlsx with formulas

srinivas460 avatar Jul 12 '18 04:07 srinivas460

report3-github.xlsx PFA

kkorada avatar Jul 12 '18 06:07 kkorada

I have checked sheet1.xml by extracting it. The formula is getting shared.

kkorada avatar Jul 12 '18 06:07 kkorada

any update on this ?

kkorada avatar Jul 13 '18 10:07 kkorada