Ask Your Question
0

I have more than 3000 columns in a sheet and this is the reason I do not use Libre office. Why does not it support more columns like Office Excel? You might be losing userbase.

asked 2019-01-23 19:36:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have more than 3000 columns in a sheet and this is the reason I do not use Libre office. Why does not it support more columns like Excel Office? You might be losing userbase.

edit retag flag offensive close merge delete

Comments

This is tdf#50916.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-23 20:44:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2019-01-23 20:51:17 +0200

ajlittoz gravatar image

How many rows?

If your number of rows is significantly lower than the number of columns, why don't you transpose your sheet? You can have "only" 1024 columns (2^10) but 2^20 rows.

Really needing more than 3000 columns questions the relevance of spreadsheet application as a tool. I hope that you don't manually enter more than 3000 elements for a "record"; It sounds like you have a machine entry process to feed your sheet (some automaton logging data?). In this case, perhaps another application would be more appropriate than spreadsheet.

Note: hiding behing wiki post is not friendly towards the volunteers who try to help; most of them are not affiliated with Libre Office or The Document Foundation. If you feel like submitting a feature request, go to the dedicated bugzilla site. As a side remark, posting as wiki prevents you from gaining karma points needed to access advanced features of AskLO.

To answer the above question or provide additional information, use the edit link under your question; don't use an answer (an answer is supposed to bring a positive fix to your problem).

edit flag offensive delete link more

Comments

Thank you.

dester gravatar imagedester ( 2019-01-23 21:41:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-23 19:36:27 +0200

Seen: 123 times

Last updated: Jan 23