Apache OpenOffice Community Forum

Is there a way to limit the no. of rows and columns when I create a new AOO Calc spreadsheet document? Say, to 20 rows and 1o columns? I know it doesn't save any space because of the limited no, of rows-columns.
Any input?
Could help in embedding calc datasheet within AOO Writer!

No, no, not hidden and via protection; I know that part!
Only pre-determined limited rows and columns without hiding them!

I know it doesn't save any space because of the limited no, of rows-columns.

No, no, not hidden I know that part!
Only pre-determined limited rows and columns without hiding them!

Why not appropriate for you the solution with hidden rows and columns?

The empty rows and empty columns NOT EXIST really in a speadsheet file. (There is not any description part for the empty cells in the XML file of the ODF archive.
The visible grid and "cells" are a graphical layout only.

The AOO Calc and LO Calc has only a maximum limit for the row count and culumn count. There is no (simple) way to decrease that limits. (You must modify the source code of the software.)
You can not modify the limit by modifying the default template or by adjusting other related settings of the office suite, or by any action of the user inteface.

In my opinion: it is enough to hide the unwanted rows and columns: you (or other users) can not write into the hidden cells. Remember: The empty cells: not exist.

Zizi64 wrote:The empty rows and empty columns NOT EXIST really in a speadsheet file. ... The visible grid and "cells" are a graphical layout only.

Yes, I am aware of this, 256 columns and 16384 to 65536 rows. Have seen the layout of CSV files to understand that

Zizi64 wrote:There is no (simple) way to decrease that limits. (You must modify the source code of the software.)

Oh! Is it not possible without changing the source code or Binary code? I was under the impression that it could be done by some abstruse settings.

For instance, I wanted to have the row-column settings manipulated via data within the spreadsheet itself in the form of (row=10, col=10).

In that case, I guess I have to remain satisfied with what is possible

rajibando wrote:Yes, I am aware of this, 256 columns and 16384 to 65536 rows. Have seen the layout of CSV files to understand that

You understand absolutely nothing.

Villeroy wrote:You understand absolutely nothing.

Yes, I know I am an idiot! This is not new to me!

Yes, I am aware of this, 256 columns and 16384 to 65536 rows. Have seen the layout of CSV files to understand that

The older versions had lower limit values: (65536, 32000 rows). The users usually want more and more rows. You are a special type of the users...

http://web.archive.org/web/201408190014 ... 8&zoneid=9
https://wiki.openoffice.org/wiki/Docume ... et_file%3F

The xls file format is limited to 65536 rows 256 columns. This highly efficient binary format can not address more cells.
csv is a plain text database exchange format with no inherent limits. You can read Gigabytes line by line and write into a database until the job is done.

Villeroy wrote:csv is a plain text database exchange format with no inherent limits. You can read Gigabytes line by line and write into a database until the job is done.

Let us not get into an argument here. My comment about CSV was in response to Zizi's comments that empty rows and columns don't actually exist but are only for graphical layout:

Zizi wrote:The empty rows and empty columns NOT EXIST really in a speadsheet file. ... The visible grid and "cells" are a graphical layout only.

In a .CSV file you must mark the "empty cells" between the existing data values:
The 6 commas mean 5 "empty cells" between the "non empty cells" in a file what was imported into the Calc.

But in real ODF type spreeadsheet file those empty cells are not marked: there are description parts only for the cells/cellranges that containing some data (numeric or textual) or formula or a specific format property.

Zizi64 wrote:In a .CSV file you must mark the "empty cells" between the existing data values ... ... formula or a specific format property.

Excuse me, but I did not understand the need for that post of yours! I know them already. My mere mention of CSV should have been the clue!

Were you talking to Villeroy?

I just tried to clarify the structure of the different file types: There is not millions of predefined cells in a new, empty odf file, in turn the limit is for rows: 1,048,576 and for columns: 1,024. If you want use 100 cells only, the you use 100 cells only. Why it is important for you: how many are the maximum values???