So for now, OpenOffice Calc has lost a user. At the moment, I simply do not have time nor patience to re-build my workbook from the ground up, piece-by-piece to see what the offending style/graphic is. I’ve read in some forums that this might have to do with cells that have custom styles on it. They should automatically line up on the right side of the cell, unless youve changed the alignment. This is simply unacceptable behavior when the competing product, Microsoft Excel, does this in the background at near-instant speed. Problem with that is that now when I’ve made my changes, I still need to hit F9 (or is it Ctrl+Alt+F9) to force a recalculate and I have to wait a minute or two with the window frozen. Obviously Calc was struggling to auto-calculate with each change in the cell contents, so I did a quick web search and learned how to turn off Auto-Calculate (Tools > Cell Contents > Auto-Calculate should be unchecked). spreadsheet skills, creating dynamic charts is a good place to begin that journey. I fixed the rest of the column formula problems by copying and pasting into the workbook and had to wait for another minute or so while Calc churned away on that. Users will appreciate a chart that updates right before their eyes. If I move the chart (few pixels) on the sheet, the curves are updated. When it came back, the cell’s contents were now valid. If I leave the Edit mode, the chart goes back to previous state (identical to the source chart). The Calc window froze again for about 1 minute.
0 kommentar(er)
