Tweet
Originally posted by oiaohm
View Post
Do make sure with the scrolling you have hardware acceleration on. But the cell to cell bit comes from the first spreadsheet program VisiCalc yes 1979.
There is kind of a reason. Excel allows max of 32,767 characters in a cell(that limit goes back to VisiCalc). Yes LibreOffice calc does in fact allow 2 to the power of 31 chars in a cell.
Lot of these people cannot find shift-enter so are putting a line of text per cell instead of using the 32767 to put all the text in 1 cell. Yes there is a drop down arrow and the end of the input line that turns it into a input box in Calc and excel for a reason.
There is a reason one MS Office users use excel so much of the stuff you describe word tables are not able to do maths dependability. Yes word table can successfully do 1+1 in sum and give you 11 for no good reason at times.
M@GOid I would hope your define of vast is not 32767+ worth of text. Lets just say Libreoffice Calc with true 1G vast text per Cell is a little system taxing(for understatement of decade) so it kind of understand why LibreOffice wanted to display only one cells worth of data at a time.
Yes I know people ask all the time how to I put more than 32767 chars into excel calc cell. Yes the instruction they get back all the time is just split that up over cells as solution. Not hey do you think it time to create a document to go along with that and Microsoft is not increasing the limit.
Yes Calligra sheets is a very rare exception. Most spreadsheets programs(as in over 95% of them) follow the 1979 VisiCalc model with how to handle text in cells yes this is the the no scrolling from end of one cells contents to the start of the next cells contents.
Yes with 32767 chars to play with you should be able do a paragraph per cell. I have seen far too many that have a paragraph split over cells as well.
There is kind of a reason. Excel allows max of 32,767 characters in a cell(that limit goes back to VisiCalc). Yes LibreOffice calc does in fact allow 2 to the power of 31 chars in a cell.
Lot of these people cannot find shift-enter so are putting a line of text per cell instead of using the 32767 to put all the text in 1 cell. Yes there is a drop down arrow and the end of the input line that turns it into a input box in Calc and excel for a reason.
There is a reason one MS Office users use excel so much of the stuff you describe word tables are not able to do maths dependability. Yes word table can successfully do 1+1 in sum and give you 11 for no good reason at times.
M@GOid I would hope your define of vast is not 32767+ worth of text. Lets just say Libreoffice Calc with true 1G vast text per Cell is a little system taxing(for understatement of decade) so it kind of understand why LibreOffice wanted to display only one cells worth of data at a time.
Yes I know people ask all the time how to I put more than 32767 chars into excel calc cell. Yes the instruction they get back all the time is just split that up over cells as solution. Not hey do you think it time to create a document to go along with that and Microsoft is not increasing the limit.
Yes Calligra sheets is a very rare exception. Most spreadsheets programs(as in over 95% of them) follow the 1979 VisiCalc model with how to handle text in cells yes this is the the no scrolling from end of one cells contents to the start of the next cells contents.
Yes with 32767 chars to play with you should be able do a paragraph per cell. I have seen far too many that have a paragraph split over cells as well.
These documents I receive had no reason whatsoever to be in a spreadsheet. There is no math to be done in them. And by vast I mean a full page Phoronix article done in vertical, in one cell. My guess is, either those people are too lazy to click a couple times to change the document to landscape and create a table, or they simply don't know you can do that on Word/Writer/whatever.
Either way, the document became very messy and unprofessional. I do my part sending them well organized documents done in a text editor, but if you are in a office environment long enough, you know some people would rather die than change their computing habits.
Comment