Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

    Search for this: planning/ designing database

   This should be able to help you. Of course, this is only my opinion, but then again I wrote it. 
This is only one of multiple chapters about using Base that are available for downloading.

Dan

-------- Original message --------
From: "James E. Lang" <jim+lou@lang.hm> 
Date:11/14/2015  1:42 AM  (GMT-05:00) 
To:  
Cc: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Large spreadsheet does not open in
  LibreOffice. 

-----Original Message-----
From: Joel Madero <jmadero.dev@gmail.com>
To: toki <toki.kantoor@gmail.com>
Cc: users@global.libreoffice.org
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]

Best,
Joel

-- 
Jim


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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