Libre office calc open slow and run slow for certain file

[Loong]

It took a long wait to open a file, but if i opened with excel 2010, and open with libre calc as read only, it able to load normal.
Thus, after calculating a cell(press enter in edit of a summed cell), it will cause sudden lag, delay any action, selecting other cells, type or any kind. But in read only mode( i choosed to edit in read only), it can edit cells normally like it used to.
other larger file can be opened normally, just dont know why…

i’ve tried unchecking OpenGL, Javascript but no fix on it.

[fpy]

Guidelines for asking

Here is a suggested list of guidelines for asking questions. Research the problem online first to avoid duplication. Mention what you find. Attempt to solve the problem before asking, and explain what efforts you have made. Programming questions should include code snippets. Simplify and isolate the problem as much as possible. Use elementary problem solving or debugging techniques. Describe problems encountered and show error messages. Give all information and steps necessary to reproduc…