Spredsheet changes are not getting reflected in exported pdf

Here is my code
https://pastebin.pl/view/a7ed61fb
https://pastebin.pl/view/34da6816

I am trying to scan the sheet → get all the formula in the range → and modify all of them with a string. I am able to export the pdf fine, but it is not getting the changes on the fly. Am I doing anything wrong here

Works for me. Apart from that it doesn’t replace only formulas but every cell in used area, and getCellByPosition(I,J) should be getCellByPosition(J,I) instead (swapped col,row). However, the PDF is written with the new content. LibreOffice 7.2.z and 7.1.5

2 Likes