[Solved-Workaround] Too less number of rows

Discuss the spreadsheet application

[Solved-Workaround] Too less number of rows

Postby gorinw10 » Mon Jan 21, 2019 10:23 pm

I use excel file more than thousands of rows and uninstalled open office immediately after installing because it does not support my file. Excel supports 65536 rows. And some free office alternatives too.

If you add this option you might increase your userbase.
Last edited by Hagar Delest on Thu Jan 24, 2019 9:11 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 3.1 on Windows 10
gorinw10
 
Posts: 4
Joined: Mon Jan 21, 2019 10:21 pm

Re: Too less number of rows.

Postby mikele » Mon Jan 21, 2019 10:50 pm

Hello,
you should update (to AOO4.1 or LO). Then you have 1.048.576 rows.
LibreOffice 5.4.7 on LinuxMint/WinXP/Win7
mikele
 
Posts: 44
Joined: Wed Nov 21, 2018 11:11 am
Location: Germany

Re: Too less number of rows.

Postby Zizi64 » Tue Jan 22, 2019 12:01 am

OpenOffice 3.1 on Windows 10

The OpenOffice.org 3.1 is an archaic old version. Where you found it?

Please install (not upgrade) a recent version of LO or AOO
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.2; AOO4.1.5
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: 7827
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Too less number of rows.

Postby gorinw10 » Tue Jan 22, 2019 3:40 am

Thanks to both of you.
OpenOffice 3.1 on Windows 10
gorinw10
 
Posts: 4
Joined: Mon Jan 21, 2019 10:21 pm

Re: Too less number of rows.

Postby gorinw10 » Wed Jan 23, 2019 8:19 pm

I guess I made a crucial mistake in my question. I meant columns. Yes. Microsoft Office supports 65.536 columns but open office does not. I can not use files with large numbers of columns. There must be lots of people like me. May be open office might be losing userbase from there and there things like that? Is it hard to code more columns - or any other reason for that? Some other free office alternatives use that much columns.
OpenOffice 3.1 on Windows 10
gorinw10
 
Posts: 4
Joined: Mon Jan 21, 2019 10:21 pm

Re: Too less number of rows.

Postby Zizi64 » Wed Jan 23, 2019 8:42 pm

Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.2; AOO4.1.5
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: 7827
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Too less number of rows.

Postby mikele » Wed Jan 23, 2019 9:32 pm

Hi,
https://support.office.com/en-us/articl ... 9d656771c3
maximum: 16,384 columns (if you use the xslx format)
LibreOffice 5.4.7 on LinuxMint/WinXP/Win7
mikele
 
Posts: 44
Joined: Wed Nov 21, 2018 11:11 am
Location: Germany

Re: Too less number of rows.

Postby RusselB » Wed Jan 23, 2019 10:51 pm

My opinion only: If you need more than 100 columns for a spreadsheet, then you should strongly consider using a database instead.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4926
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Too less number of rows.

Postby jrkrideau » Wed Jan 23, 2019 11:19 pm

gorinw10 wrote:I guess I made a crucial mistake in my question. I meant columns. Yes. Microsoft Office supports 65.536 columns but open office does not. I can not use files with large numbers of columns. There must be lots of people like me. May be open office might be losing userbase from there and there things like that? Is it hard to code more columns - or any other reason for that? Some other free office alternatives use that much columns.


May I ask what you are doing that you need that many columns?

I tend to agree with RusselB that anything with that many columns is not something that should be done in a spreadsheet. Depending on what you are doing a data base may be a much better tool but there may be other software that will do what you need.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3681
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Too less number of rows.

Postby gorinw10 » Wed Jan 23, 2019 11:22 pm

Thank you to all of you. I guess I will transpose the sheet.
OpenOffice 3.1 on Windows 10
gorinw10
 
Posts: 4
Joined: Mon Jan 21, 2019 10:21 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests