From: Joel Madero <firstname.lastname@example.org>
To: toki <email@example.com>
Sent: Fri, 13 Nov 2015 21:12
Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.
On 11/13/2015 08:23 PM, toki wrote:
On 13/11/2015 19:27, Joel Madero wrote:
I have never seen a 150 mb functional spreadsheet before.
That size is not uncommon in environments where Excel is the only office
tool that the employees know how to use.
Trust me...I know. I worked somewhere where we had a 750 meg excel file
that crashed multiple times a day and was entirely useless. When I
suggested that someone (meaning I) take the time to do it right....IT
pushed back heavily and was afraid that I'd break something (as if
things weren't already horribly broken....).
I recommend to most people who see their spreadsheets creeping into the
10's to 100's of megs to start looking at how to structure databases and
do things right instead of horrible hacks that tend to have lots of
issues - despite many people trying, a spreadsheet is not a database.
[Joel, although I agree that my 7 MB spreadsheet has gotten unwieldy, I have no clue how to design
and implement a database to replace the mess. I suspect that most users who have these oversized,
abused, spreadsheets have the same problem. Businesses should be able to hire a database designer
but as a retired individual I don't have financial resources to even get training in database
design. So I appear to be stuck. I won't go into any of my spreadsheet's details here. Suffice it
to say I recognize that it has become a kludge.
At 7,145 KB after about 45 weeks accumulation of data I can see the possibility that the .ods file
could expand past 8MB for the full year. Then it will start over and I'll need to figure out how to
carry over some values computed from this year's data to the new spreadsheet. -- jl]
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. (continued)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy