On Wed, Nov 17, 2010 at 1:22 AM, NoOp <[email protected]> wrote: > On 11/15/2010 11:18 PM, Marcello Romani wrote: > ... > > > > I downloaded two of the 12MB xlsx files and opened them with SCalc. It > > kept working at 100% CPU for several minutes, but nothing appeared, not > > even the toolbars or the cell grid. > > Eventually I killed the process. > ... > Same issue here. I thought that it was a matter of not enough memory on > the 1Gib desktop, so I tried on a 3Gib laptop & still had to kill the > process. On the laptop I let it run for approx 1 hour (start & stop the > process occasionally to keep the CPU temp down). >
That won't work. RAM is not the constraint here. The cell count size is. Note the Fractal size of G21 till AMQ1045. Is there any option to increase the row and column count? > @Manu: I'm not familiar with MSO2010, but if you expect the files to be > useful you will need to do some added work. As a test I attempted to > open the IFS Generalized.xlsx file in Excel 2003 (with the appropriate > file converters installed) and receive this message: > > Excel 2003 has limitations. The given spreadsheets works only in Excel 2010 and 2007, because of the row and column count. > - Some formulas have more levels of nesting than are allowed in this > version of Excel. Fromulas with more than seven levels of nesting will > not be opened and will be converted to #VALUE! errors." > #VALUE ERROR caused here are not due to formula levels, but real errors induced due to floating point expansion of complex numbers beyond the limits. They are part of the program and is not causing any problem. They are alternatives for looping in programming. I have used them to avoid using macros and 'for' loops > Suggest that you try creating one of these from OOo Calc directly and > save as an ODS. It think that's the only way you will be able to verify > yourself. > > The size limit can be solved because either I can reduce the row and col count used or OOo Calc has exactly 1024 cols - so I can shift from A21 till AMJ1045. But this is anyway only a temporary solution. What I would be requiring is the power of What-if analysis in OOo. I am propagating computational thinking in spreadsheet through fractals. These spreadsheets does not have macros, programming etc. Even stacks are implemented without macros. Calc can open the 'Unexpanded files'. Gnumeric can open the files though What-if does not operate. You can try with Mandelbrot Set or Julia Sets. Spreadsheets have been used only as a statistical and business tool or atleast that is what majority think. But they are excellent engineering tools as well. Fractals in spreadsheets proves just that -Manu > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
