Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 20 Sep 2013 16:01:12 +0200Sudoku solver, calc internal tokens number exceededhttps://ask.libreoffice.org/en/question/8985/sudoku-solver-calc-internal-tokens-number-exceeded/Whats the maximum number of characters in libre office calc cell? I use LibreOffice 3.5 build 403 on openSUSE 12.2. When I try to enter quite long formula Libre shorten it from 964 char to 958 in one example, and 982 to 976 chars in an other example. I've tried searching on google but founded nothing usefull. So... two question
1. Whats the maximum number of characters in a calc cell
2. If max char is more than 1024, Why do Libre office shorten my formula?
/J
**[edit]** found that it is 512 chars, but somehow ignored that and allowed little more than that, between 950 and 1000QuiWed, 12 Dec 2012 19:46:15 +0100https://ask.libreoffice.org/en/question/8985/Does Libre Writer have a maximum page size limit?https://ask.libreoffice.org/en/question/22886/does-libre-writer-have-a-maximum-page-size-limit/Microsoft Word has a page size limit of 22 inches by 22 inches. I would like to use a page size of 30x42 with newspaper column formatting. I want to use OLE linking to bring my Libre Writer document into an Autocad drawing.SteveGFri, 20 Sep 2013 16:01:12 +0200https://ask.libreoffice.org/en/question/22886/How to convert calc in odb ?https://ask.libreoffice.org/en/question/21757/how-to-convert-calc-in-odb/I succeed in converting short calc file (about 100 rows for instance) in odb (Libre Office Base) (copy/paste is ok), but it doesn't work with a calc file of 164 380 rows, it finishes in a "null pointer" error if I paste it into Libre Office Base. I imagine this is a bug due to a limit in Libre Office Base, since I can see my 164380 rows in calc without any problem...
Since I don't know what is the limit of copy/paste number of rows, I don't know how to do it exactly.
Isn't there a program / module / add-on able to copy/paste large calc file > 150 000 rows to create an odb database ? Or can we know the limit of the number of rows we can copy/paste from calc to odb ? I suggest a possible evolution of Base, that could be create a table directly from a calc file, since I've seen many of questions on the net about that question, and it's easy to convert any text file in calc, so it could be usefull to import any kind of file data into a database with such a function.
Thank you for your answer.Convert calc in odbSat, 24 Aug 2013 08:29:40 +0200https://ask.libreoffice.org/en/question/21757/