[Solved-Workaround] Too less number of rows
[Solved-Workaround] Too less number of rows
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.
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
Reason: tagged solved
OpenOffice 3.1 on Windows 10
Re: Too less number of rows.
Hello,
you should update (to AOO4.1 or LO). Then you have 1.048.576 rows.
you should update (to AOO4.1 or LO). Then you have 1.048.576 rows.
LibreOffice 5.4, 7.0, 7.2 on LinuxMint/Win10
Re: Too less number of rows.
The OpenOffice.org 3.1 is an archaic old version. Where you found it?OpenOffice 3.1 on Windows 10
Please install (not upgrade) a recent version of LO or AOO
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: Too less number of rows.
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
Re: Too less number of rows.
https://wiki.documentfoundation.org/Faq/Calc/022
https://wiki.openoffice.org/wiki/Docume ... et_file%3F
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: Too less number of rows.
Hi,
https://support.office.com/en-us/articl ... 9d656771c3
maximum: 16,384 columns (if you use the xslx format)
https://support.office.com/en-us/articl ... 9d656771c3
maximum: 16,384 columns (if you use the xslx format)
LibreOffice 5.4, 7.0, 7.2 on LinuxMint/Win10
Re: Too less number of rows.
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.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.
Re: Too less number of rows.
May I ask what you are doing that you need that many columns?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.
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.
LibreOffice 7.3.7. 2; Ubuntu 22.04
Re: Too less number of rows.
Thank you to all of you. I guess I will transpose the sheet.
OpenOffice 3.1 on Windows 10