Dear Calc team, at work I often have to compare figures from different spreadsheet files (for example imagine a movement analysis for some figures from financial reports of different reporting quarters). In my opinion neither OpenOffice nor MS Excel has a really intuitive and fast method for achieving this.
Though MS Excel is based on a multi document window, the only advantage is, that Excel can arrange the opened files vertically or horizontally. This a bit better than with OpenOffice where you have to arrange two complete OpenOffice windows by yourself. Nevertheless I prefer the single document window of OpenOffice, but my suggestions would be to add some sort of layers (as you have it in a painting programm). In every layer one spreadsheet file can be loaded. Then one would need something similar to the split window function. After using this, one should be able to assign different layers to different parts of the window. Now the user can work with different file as if they were one. A special case would be to open the same file again in a new layer and use my proposed feature to work easily across different sheets within the document. Another interesting thing making life easier would be some sort of "synchronized scrolling". Imagine you have very similar spreadsheet files only filled with different data. Take two of them and display them side by side assuming the feature described above. Now you want to look up some figures in the first file to compare them to the correspondent figures in the second file. Then it would be nice if the view of the second file follows your scrolling / cell cursor movement in the first file. What do you think about the proposals? Would it be hard to implement? Or doesn't it make sense to you? Best regards, Sebastian --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
