On 12/08/10 04:35, Kaushal Shriyan wrote: > Hi, > > I have Openoffice Office Suite 3.3 RC 7 on Windows XP. > > We follow steps for Data Pilot. > > 1. Select all. > 2. Data option Data Pilot and Start. > 3. In Row fields we take Mask and Cause. > 4. In Data Fields we take Cause (Count-Cause). > 5. Save it in .xlsx format . > > In open office this all takes 30 to 40 minutes. and in Microsoft XL it takes > hardly 10 minutes. > > Minimum 65000 rows so we have to save it in xlsx format. > > Approx size of the file in csv format is 70 to 80 MB and we save it in xlsx > format. > > Please suggest/guide > > Thanks > > Kaushal >
Microsoft XL? - Are you talking about a version of MS Office? What version of Excel did you use for the testing? I thought that OOo Calc was supporting a million rows in version 3.3 and saving it with the default ODF file format. The one thing that you should realize is MSO and OOo do thing differently across the board. There are things that OOo seems to do faster than MSO and there are things that seem to do faster with MSO. MSO has thousands and thousands of paid workers to make MSO the "best product" in their eyes and their idea of what people want and need. OOo does not have the personnel or resources to compete in the programming aspect. But OOo's people who do program are doing their best with the resources at hand. Many of the MSO options are looked at by OOo programmers and then they need to figure out how to do it within OOo. I bet when the options you tested was developed by MSO, it took many years to get the coding to be as fast as you think it is. How long has OOo had those options? How many man hours did MSO spend on getting it working, and how many has OOo been able to dedicate to it. Remember, although there are some paid employees from Oracle [Sun before] that are working on the code base for OOo, I would suspect that there are 10, 20, 50 times as many unpaid volunteers working on making it better. I left MSO for OOo since MSO was becoming much slower than OOo at that time. Whatever versions are now out for MSO may be better at some things, but I still say OOo is overall the better choice. I do remember reading an article that states that if you are a "high-end" user of an office suite, then MSO might be a better choice. Their "high-end" user seemed to be less than 1/2% of most business users and even less of personal users of an office suite. Otherwise, the article stated, OOo most likely be a better choice for the user, business or personal. I believe that. I have MSO 2003 but have used it once in the past 6 months. Now that I have Ubuntu for all but one laptop, I use OOo only unless I must use MSO for something that only MSO does. Actually I cannot wait for 3.3 to get out of the RC stage. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
