Code: Select all
OS: Windows 10 Version 2009
Word size of FreeCAD: 64-bit
Version: 0.20.1.29410 (Git)
Build type: Release
Branch: releases/FreeCAD-0-20
Hash: f5d13554ecc7a456fb6e970568ae5c74ba727563
Python 3.8.10, Qt 5.15.2, Coin 4.0.1, Vtk 8.2.0, OCC 7.6.3
Locale: English/United States (en_US)
Installed mods:
* Assembly4 0.12.3
* Curves 0.5.6
* ExplodedAssembly
* fasteners 0.4.2
* Manipulator 1.4.9
* MOOC 2022.4.21
* OpticsWorkbench 1.0.8
* sheetmetal 0.2.56
* ToolViewReverse_ToolBar
I often reuse spreadsheets from one file to the next as I have a template I like to use. While I am building my new part, I often end up Inserting and Removing rows in the new file to match what I need for that particular part. Many times it will work as expected and I have no problems. Then at other times, I have nothing but problems. Cells that use to be in the same row below where I've removed things are no longer in the same row, I often get a #PENDING message in cells below the remove point, and occasionally it will crash FreeCAD completely. Using UNDO to get me back to where I was before does not work either as it seems to mess things up even more. It gets to the point where I have to remove a single row, save the file, close it, open it back up, remove another row, and then repeat until I get all the rows removed I want. This is not very conducive to getting work done.
I finally got a file that I can duplicate some of the errors so I'm finally able to post something so hopefully someone can figure out what is going on.
If you open the "SSS_BermPlateLeft" spreadsheet you can see a large white area near the top between rows 6 and 16 that I want to remove. Before removing anything, scroll down to rows 69-76 and notice the rows are properly aligned as shown here:
Now go back up and just Remove Row 6. If you scroll back down to row 69, you will see that some of the alignment is no longer correct as shown here.
Go back up and Remove Row 6 again. Now the screen fills up with a bunch of #PENDING messages and if you go back down to row 67, you will notice that the rows are really messed up now.
Now if you go back up and Remove row 6 one more time, FreeCAD Crashes all together. While crashing, I notice an Illegal Storage Access error message.
I've been able to duplicate these steps multiple times, so I'm hoping others can duplicate this also.
Now the funny thing is if I delete Row 6, then close the file and save it, when I open it back up, the row was deleted and the data below which was screwed up comes back normal.
So if I go and delete one row at a time, close the file and save each time, I eventually get everything deleted. Very frustrating. I suspect the problem has to do with when cells are merged together as that seems to be the point where things go to heck at first.
Let me know if you need more info. Hopefully someone can figure this out as it is driving me nuts.
Thanks