| View previous topic :: View next topic |
| Author |
Message |
TRUTH_UNITED
General User
Joined: 08 Jun 2005
Posts: 17
|
 Posted: Sun Aug 05, 2007 11:43 pm Post subject: Size limit for an ods file? |
 |
|
Size limit for an ods file?
1. How big can an ods file be?
2.(I know it shouldn't be asked here but thank you so much if you can answer me) How big can a txt file be? I use the Windows XP Wordpad.
I love you. |
|
| Back to top |
|
 |
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Mon Aug 06, 2007 6:04 am Post subject: |
|
|
If you're talking about the actual file, then it can be as large as the OS and filesystem will allow. That depends on how you've formatted the hard drive (what filesystem you use). According to this page,
NTFS: File size limited only by size of volume [your hard drive]
FAT: Maximum file size 2GB
FAT32: Maximum file size 4GB
I don't know about Wordpad files.
Whether OOo could ever load and work with a file anywhere near that size is another question.
If you're talking about how many items you can store, each Calc sheet can hold 65536 rows, in 256 columns. A Calc document can have as many sheets as you like.
Do you really anticipate needing that much space? For what purpose, may I ask? |
|
| Back to top |
|
|
saphil
OOo Enthusiast
Joined: 28 Sep 2005
Posts: 121
Location: Atlanta GA
|
| Posted: Mon Aug 06, 2007 11:44 am Post subject: |
|
|
| I don't know about the OP, but I used to work in aa place that consolidated log files into spreadsheet files, and so I had a weekly chore of putting together the log files (of arbitrary length) into as small a number of spreadsheets as I could. I usually ended up with more than ten 64,000-row files. It would have made more sense to work with csv files, but their workflow called for excel sheets (excel-97 Max=64000 rows) |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Aug 06, 2007 12:13 pm Post subject: |
|
|
| acknak wrote: | .... A Calc document can have as many sheets as you like...
|
Sorry, I have to disaggree.
| Code: |
Sub Main
oSheets = thiscomponent.sheets
for i = 1 to 300
oSheets.insertNewByName("New Sheet "& i, 0)
next
End Sub
|
The maximum count of sheets seems to be 256. |
|
| Back to top |
|
|
TRUTH_UNITED
General User
Joined: 08 Jun 2005
Posts: 17
|
| Posted: Mon Aug 13, 2007 12:00 am Post subject: |
|
|
| acknak wrote: | each Calc sheet can hold 65536 rows, in 256 columns. A Calc document can have as many sheets as you like.
Do you really anticipate needing that much space? For what purpose, may I ask? |
65536x256 is "that much space"?
what if I had 70000 employees in my company?
what if I added an entry every day in my life?
and the bottom line is, why did nobody warn me about this limitation when I installed the software? |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Mon Aug 13, 2007 4:15 am Post subject: |
|
|
| TRUTH_UNITED wrote: | | acknak wrote: | each Calc sheet can hold 65536 rows, in 256 columns. A Calc document can have as many sheets as you like.
Do you really anticipate needing that much space? For what purpose, may I ask? |
65536x256 is "that much space"?
what if I had 70000 employees in my company?
what if I added an entry every day in my life?
and the bottom line is, why did nobody warn me about this limitation when I installed the software? |
Caveat emptor?
On the other hand 65536x256 is 16,777,216 cells and 65536*256 *256 = 4,294,967,296. A little over 4 billion cells is not bad!.
If you have 70,000 employees it would be madness to use a spreadsheet for this data.
As acknak asked. "Do you really anticipate needing that much space? For what purpose, may I ask?"
If you really need this kind of storage then you almost certainly want something like a database not a spreadsheet.
4,294,967,296
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Mon Aug 13, 2007 6:11 am Post subject: |
|
|
| TRUTH_UNITED wrote: | | what if I had 70000 employees in my company? |
Then you can afford to pay someone to set up a proper database.
| TRUTH_UNITED wrote: | | what if I added an entry every day in my life? |
If you use a new row every day and you live to be 100, you'll still only use just over half the rows. |
|
| Back to top |
|
|
bobharvey
Super User
Joined: 23 Apr 2004
Posts: 1075
Location: Lincolnshire
|
| Posted: Mon Aug 13, 2007 6:18 am Post subject: |
|
|
| RickRandom wrote: | | TRUTH_UNITED wrote: | | what if I had 70000 employees in my company? |
Then you can afford to pay someone to set up a proper database. |
[/quote]I never fail to be amazed at the way people persist in trying to force software to do something it was never intended to. They would not use the company car to tow an "Artic" trailer, nor yet a screwdriver as a cold chisel.
I'm not even sure the data protection registrar would not have a fit about what is mentioned there. |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Mon Aug 13, 2007 6:27 am Post subject: |
|
|
| bobharvey wrote: | | They would not use the company car to tow an "Artic" trailer, nor yet a screwdriver as a cold chisel. |
To the man with only a hammer, everything is a nail! But if you employ 70000 people, you can afford more than a hammer.
Perhaps the original poster should be offered a refund.  |
|
| Back to top |
|
|
jwr
OOo Advocate
Joined: 06 Sep 2006
Posts: 367
Location: Germany
|
| Posted: Thu Aug 30, 2007 12:33 am Post subject: |
|
|
| TRUTH_UNITED wrote: |
and the bottom line is, why did nobody warn me about this limitation when I installed the software? |
This reminds me of the following stickers I found in the US state of California a few years ago:
- This building is not protected against earthquakes (engraved at a tiny plate near an emergency exit staircase inside a 20 level skyscraper)
- WARNING: Objects in this mirror may be approaching faster than expected (sticked to the mirror of a rented car and covering the reflected image)
- Be careful handling this drink. It may be very hot! (found at a styrofoam cup of Coke).
-> Just contact your lawyer and he will explain you how to make money with this software.
Regards -Hans-
_________________
Windows 2K, OOo-2.3.0, MS-IE-6.0, Firefox-1.0.4, MS Office 97,
Say NO to MS OpenXML: http://www.noooxml.org/petition |
|
| Back to top |
|
|
bobharvey
Super User
Joined: 23 Apr 2004
Posts: 1075
Location: Lincolnshire
|
| Posted: Thu Aug 30, 2007 1:24 am Post subject: Re: Size limit for an ods file? |
|
|
| TRUTH_UNITED wrote: | | 1. How big can an ods file be? |
Well, max. tabs = 256, max rows = 65536, max columns = 256, max cell contents = 64KB. Overhead for empty file less than 8KB.
I'll leave you to do the maths.
| Quote: | | and the bottom line is, why did nobody warn me about this limitation when I installed the software? |
Did you ask? Google claims to have taken 0.005 seconds to find the answers above. It might have taken slightly longer, I blinked.
I love you too.
PS: Corel's Quattro Pro spreadsheet supports 18,278 columns and up to 1,000,000 rows. And has since the days of MSdos, from my memory. |
|
| Back to top |
|
|
AndrewZ
Moderator
Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA
|
| Posted: Thu Mar 20, 2008 6:16 am Post subject: |
|
|
| jrkrideau wrote: | | On the other hand 65536x256 is 16,777,216 cells |
Not anymore  1024 * 65536 = 67,108,864
Article: New features in OpenOffice.org 3.0
_________________
<signature>
* Did you solve your problem? Do others a favor: Post the solution
* OpenOffice.org Ninja
* BleachBit
</signature> |
|
| Back to top |
|
|
|
