Page 1 of 1

[Closed] A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 12:22 pm
by rajibando
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!

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 12:33 pm
by Villeroy
10x20.ods
A1:J20 with cell style "Unlocked", hidden rows and columns, protected sheet.
(10.71 KiB) Downloaded 63 times

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 2:41 pm
by rajibando
No, no, not hidden :-) and via protection; I know that part!
Only pre-determined limited rows and columns without hiding them!

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 3:29 pm
by Zizi64
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.

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 3:45 pm
by rajibando
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 :-(

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 3:51 pm
by Villeroy
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.

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 4:11 pm
by rajibando
Villeroy wrote:You understand absolutely nothing.
Yes, I know I am an idiot! This is not new to me!

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 8:44 pm
by Zizi64
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... :lol:

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

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Thu Sep 07, 2017 9:21 pm
by Villeroy
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.

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Fri Sep 08, 2017 4:51 am
by rajibando
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.

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Fri Sep 08, 2017 9:16 am
by Zizi64
In a .CSV file you must mark the "empty cells" between the existing data values:

Code: Select all   Expand viewCollapse view
abcdef,12.34,,,,,,35.12,fghjkl,24

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.

Re: A way to limit AOO Calc's no. of rows and columns?

PostPosted: Fri Sep 08, 2017 10:50 am
by rajibando
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?

Re: [Closed]A way to limit AOO Calc's no. of rows and column

PostPosted: Fri Sep 08, 2017 1:13 pm
by Zizi64
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???