3 ms·

I might not be an Office Excel power user, although I'm not sure, thus can be blind to those critical features. What are the things that you can't live without

I might not be an Office Excel power user, although I'm not sure, thus can be blind to those critical features. What are the things that you can't live without in Calc ?

chewxy 14y ago
Ohboy, let's go: * Calc's pivot tables is clunky, while working on Excel 2010 is like working on butter with a hot knife. No, it's not a "getting used to" thing. * Basic stuff like filter/sorting tools: Excel has a far better flow that helps you get the job done faster * DataNitro * Charting in libreoffice is broken. I use ggplot for most of my day jobs, but sometimes when you need to pull up a quick chart, LibreOffice serves to only nerf your speed. Again, not one of those "getting used to" thing * Try pivot-tabling a 1M row csv in Calc. * VBScript (though that's now more and more subplanted by DN) * Analysis tools - Excel is just so much richer. These things LibreOffice is better than Excel: * CSV (excel's a little clunky with CSV import) * regex search EDIT: formatting
- DeepDuh 14y ago
  One more thing Calc is better than Excel: It doesn't screw with your Microsoft Windows 7 windows. Multiwindow in Excel is just broken. Is Excel 2013 any better there? Anyway, I agree with everything else you said, it matches exactly my experiences with Calc. That being said I'd prefer Apple to push their iWorks applications over better OOffice - their technological basis is by far the best - the outcome of each click and each edit is completely predictable, the whole rendering engine works consistantly across all three products, so do hotkeys. They're just lacking a lot of sugar on top like the features you mention.
  - davidacoder 14y ago
    Yes, multi window finally works as it should in Excel 2013. That alone was a reason for me to update the second it was released.
    - DeepDuh 14y ago
      Ahh finally I can have peace of mind. Thanks for that hint.

I might not be an Office Excel power user, although I'm not sure, thus can be blind to those critical features. What are the things that you can't live without in Calc ?

chewxy 14y ago

Ohboy, let's go: * Calc's pivot tables is clunky, while working on Excel 2010 is like working on butter with a hot knife. No, it's not a "getting used to" thing. * Basic stuff like filter/sorting tools: Excel has a far better flow that helps you get the job done faster * DataNitro * Charting in libreoffice is broken. I use ggplot for most of my day jobs, but sometimes when you need to pull up a quick chart, LibreOffice serves to only nerf your speed. Again, not one of those "getting used to" thing * Try pivot-tabling a 1M row csv in Calc. * VBScript (though that's now more and more subplanted by DN) * Analysis tools - Excel is just so much richer. These things LibreOffice is better than Excel: * CSV (excel's a little clunky with CSV import) * regex search EDIT: formatting

DeepDuh 14y ago
One more thing Calc is better than Excel: It doesn't screw with your Microsoft Windows 7 windows. Multiwindow in Excel is just broken. Is Excel 2013 any better there? Anyway, I agree with everything else you said, it matches exactly my experiences with Calc. That being said I'd prefer Apple to push their iWorks applications over better OOffice - their technological basis is by far the best - the outcome of each click and each edit is completely predictable, the whole rendering engine works consistantly across all three products, so do hotkeys. They're just lacking a lot of sugar on top like the features you mention.
- davidacoder 14y ago
  Yes, multi window finally works as it should in Excel 2013. That alone was a reason for me to update the second it was released.
  - DeepDuh 14y ago
    Ahh finally I can have peace of mind. Thanks for that hint.