I didn’t quite understand your last response, but I gather you wanted to take me up on my offer. Here is what I have done:
- I cleared ALL cells of Direct Formatting.
- I deleted all but the first 200 rows.
The changes I have made should allow you to open the spreadsheet and add back what you want rather quickly.
I would strongly suggest you add back in reasonable increments and save to a new file at each step. This way you’ll be able to recover at whatever point the file begins to crash again (hopefully it won’t if you follow my earlier advice about formatting).
The modified file is attached: [C:\fakepath[Template] Levyraati _ Music Club _ Disc Jury(mod 20151004).ods](/upfiles/14439792737734098.ods)
Good luck.
(Please click the check next to my post if you believe my response is the best answer to your question.)
-------------------
After your last update, I downloaded the file and opened it. I was able to easily move from the first cell to the last. I entered scores into the scoring section and watched the totals recalculate. There was a recalculation delay of about 2 seconds, but no other obvious issues.
Given the resources of my computer, the 2 second recalculation delay after adding only a few numbers indicates the massive nature of your initialized spreadsheet. As more data is entered, this recalculation delay will likely grow.
I realize you indicated earlier that a database solution is not an option. However, a solution that only a few can open, or that becomes so slow as to not be viable is not really an option either.
Your problem definitely seems to be one of resources. You didn’t indicate the speed of your AMD chip, but given that it is Quad-Core, I would assume this not to be the issue.
I also didn’t notice any mention of your graphics card. Given the heavy amount of color you have applied to the cells, this could be an area for further investigation. Check for a driver update and also look at the graphics card specs to see if it is up to the task. Try drastically reducing your computer’s screen resolution and see if you can open the file.
Add RAM if possible. Even if this is not the problem, you gain from your investment.
IF YOU WOULD LIKE, I can try to reset the background color in all cells to None, then let you see if you can open the modified spreadsheet. If so, you can still use color, but do so more prudently. For instance, you could color the font rather than the cell. Better yet, you could color the font for the headings ONLY. This still provides visual clues to the user without sucking all the life out of your computer’s resources.
(Please click the check next to my post if you believe my response is the best answer to your question.)
-------------------
There is a lot you haven’t told us about you computer, but I’m guessing you have exceeded the RAM limits, the processor limits, or both.
The first thing I would advise is to reboot your computer and close any programs running in the foreground or background (where possible) before opening the file.
The second thing I would advise is to open LO Calc and make sure that formulas are not being automatically recalculated when you open a spreadsheet file.
The third thing I would advise is to open the file on a computer with more RAM (or add RAM to your computer if that is possible).
The fourth thing I would advise is (and you are going to hate this after all the work you’ve done) stop what you are doing. Spreadsheets are, by their nature, designed to perform a specialized task. They are not, by their nature, specialized graphics applications. They are not, by their nature, specialized database applications.
Where database software allows the programmer some flexibility in deciding computer resource requirements (RAM vs. disk; normalized relational databases vs. flat files, etc.), spreadsheet software affords less such flexibility. Although oversimplified, upon opening a spreadsheet, the spreadsheet software is first loaded into memory, then the spreadsheet data (including your application) is loaded into memory. Once this is done, recalculation, etc. occurs based on your program settings and your spreadsheet file settings.
Depending on the global and file settings, and on the file size, RAM and processor requirements can be significant, even for a spreadsheet file that has no data from your users.
I would suggest you try to design your application using database software, or perhaps even to create your application as a standalone executable.
(Please click the check to the upper left of my post if my answer successfully addresses your question.)
