[Closed] A way to limit AOO Calc's no. of rows and columns?
[Closed] A way to limit AOO Calc's no. of rows and columns?
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!
Any input?
Could help in embedding calc datasheet within AOO Writer!
Last edited by rajibando on Fri Sep 08, 2017 12:49 pm, edited 1 time in total.
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
Re: A way to limit AOO Calc's no. of rows and columns?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: A way to limit AOO Calc's no. of rows and columns?
No, no, not hidden and via protection; I know that part!
Only pre-determined limited rows and columns without hiding them!
Only pre-determined limited rows and columns without hiding them!
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
Re: A way to limit AOO Calc's no. of rows and columns?
I know it doesn't save any space because of the limited no, of rows-columns.
Why not appropriate for you the solution with hidden rows and columns?No, no, not hidden I know that part!
Only pre-determined limited rows and columns without hiding them!
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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: A way to limit AOO Calc's no. of rows and columns?
Yes, I am aware of this, 256 columns and 16384 to 65536 rows. Have seen the layout of CSV files to understand thatZizi64 wrote:The empty rows and empty columns NOT EXIST really in a speadsheet file. ... The visible grid and "cells" are a graphical layout only.
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.Zizi64 wrote:There is no (simple) way to decrease that limits. (You must modify the source code of the software.)
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
Last edited by rajibando on Fri Sep 08, 2017 5:52 am, edited 2 times in total.
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
Re: A way to limit AOO Calc's no. of rows and columns?
You understand absolutely nothing.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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: A way to limit AOO Calc's no. of rows and columns?
Yes, I know I am an idiot! This is not new to me!Villeroy wrote:You understand absolutely nothing.
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
Re: A way to limit AOO Calc's no. of rows and columns?
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...Yes, I am aware of this, 256 columns and 16384 to 65536 rows. Have seen the layout of CSV files to understand that
http://web.archive.org/web/201408190014 ... 8&zoneid=9
https://wiki.openoffice.org/wiki/Docume ... et_file%3F
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: A way to limit AOO Calc's no. of rows and columns?
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.
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: A way to limit AOO Calc's no. of rows and columns?
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: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.
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.
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
Re: A way to limit AOO Calc's no. of rows and columns?
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.
Code: Select all
abcdef,12.34,,,,,,35.12,fghjkl,24
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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: A way to limit AOO Calc's no. of rows and columns?
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!Zizi64 wrote:In a .CSV file you must mark the "empty cells" between the existing data values ... ... formula or a specific format property.
Were you talking to Villeroy?
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
Re: [Closed]A way to limit AOO Calc's no. of rows and column
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???
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.