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

Creating a macro - Writing a Script - Using the API

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

Postby rajibando » Thu Sep 07, 2017 12:22 pm

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!
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
rajibando
 
Posts: 52
Joined: Sat Jul 29, 2017 4:59 am

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

Postby Villeroy » Thu Sep 07, 2017 12:33 pm

10x20.ods
A1:J20 with cell style "Unlocked", hidden rows and columns, protected sheet.
(10.71 KiB) Downloaded 62 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby rajibando » Thu Sep 07, 2017 2:41 pm

No, no, not hidden :-) and via protection; I know that part!
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
rajibando
 
Posts: 52
Joined: Sat Jul 29, 2017 4:59 am

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

Postby Zizi64 » Thu Sep 07, 2017 3:29 pm

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.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8210
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby rajibando » Thu Sep 07, 2017 3:45 pm

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 :-(
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
rajibando
 
Posts: 52
Joined: Sat Jul 29, 2017 4:59 am

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

Postby Villeroy » Thu Sep 07, 2017 3:51 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby rajibando » Thu Sep 07, 2017 4:11 pm

Villeroy wrote:You understand absolutely nothing.
Yes, I know I am an idiot! This is not new to me!
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
rajibando
 
Posts: 52
Joined: Sat Jul 29, 2017 4:59 am

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

Postby Zizi64 » Thu Sep 07, 2017 8:44 pm

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
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8210
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby Villeroy » Thu Sep 07, 2017 9:21 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby rajibando » Fri Sep 08, 2017 4:51 am

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.
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
rajibando
 
Posts: 52
Joined: Sat Jul 29, 2017 4:59 am

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

Postby Zizi64 » Fri Sep 08, 2017 9:16 am

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.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8210
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby rajibando » Fri Sep 08, 2017 10:50 am

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?
LibreOffice 4.0.3.3 (Build ID: 400m0(Build:3)) in Knoppix 7.2.0
rajibando
 
Posts: 52
Joined: Sat Jul 29, 2017 4:59 am

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

Postby Zizi64 » Fri Sep 08, 2017 1:13 pm

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; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8210
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Macros and UNO API

Who is online

Users browsing this forum: t_t_u and 11 guests