We will be migrating from Ask to Discourse on the first week of August, read the details here

 2020-10-07 19:56:03 +0200 commented answer [Calc] How to combine multiple tables, in different sheets, into a new one? It helped me too :D I just modified $E$2 to match list of my sheets names, and replaced every 2 and 9 respectively with 2020-08-07 13:20:35 +0200 received badge ● Famous Question (source) 2020-06-19 20:43:18 +0200 commented answer [SOLVED] Ubound(Array()) doesn't work to know how many elements has the Array with method .getDataArray() Glad it helped :) UBound(Simple_Row_array(), 1) will give you the highest index of the first dimension, no matter what 2020-06-17 13:49:21 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Try using Oracle Java 9, 10 or 11, 2020-06-16 17:18:39 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Sorry, (replaced supported by not recognised) I will do now.. I deleted all the jre 9, 10 and 11 from my machine 2020-06-16 17:18:12 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Sorry, I will do now.. (replaced supported by not recognised) 2020-06-16 17:04:03 +0200 edited answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Versions after Oracle Java 8 are not supported since LibreOffice 6. I recommend the use of OpenJDK. For Windows users, 2020-06-16 17:02:36 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Sorry, I will do now.. 2020-06-16 15:38:46 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java I tried any Oracle jre more than 8 (9, 10, 11 no works) in 6.4.3.2 (x64) and 6.4.1.2 (x86) and it's not recognized, only 2020-06-16 15:37:22 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java I tried any Oracle jre more than 8 (9, 10, 11 no works) in 6.4.3.2 (x64) and 6.4.1.2 (x86) and it's not recognized 2020-06-16 15:35:17 +0200 commented answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java I tried any jre more than 8 (9, 10, 11 no works) in 6.4.3.2 (x64) and 6.4.1.2 (x86) and it's not recognized 2020-06-16 14:08:04 +0200 edited answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Versions after Oracle Java 8 are not supported since LibreOffice 6. I recommend the use of OpenJDK. For Windows users, 2020-06-16 14:07:15 +0200 edited answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Versions after Oracle Java 8 are not supported since LibreOffice 6. I recommend the use of OpenJDK. For Windows users, 2020-06-16 13:59:42 +0200 edited answer I have been trying to create a new database in base but it keeps telling me I have a problem with Java Versions after Oracle Java 8 is are not supported since LibreOffice 6. I recommend the use of OpenJDK. For Windows user 2020-06-16 13:58:31 +0200 answered a question I have been trying to create a new database in base but it keeps telling me I have a problem with Java Versions after Oracle Java 8 is not supported since LibreOffice 6. I recommend the use of OpenJDK. For Windows users, f 2020-06-15 22:06:03 +0200 commented question Generate Base Report as HTML with Links You are welcome :) Because of your question I knew that hyperlink exists :) 2020-06-14 16:11:51 +0200 commented question Generate Base Report as HTML with Links check this out: https://ask.libreoffice.org/en/question/3632/hyperlink-field-types-in-base/ 2020-06-14 16:06:44 +0200 commented answer Hyperlink field types in Base As far as I remember. they only have two people working on Base, so the focus is actually on the stability of the softwa 2020-06-14 06:34:44 +0200 received badge ● Notable Question (source) 2020-06-13 21:29:25 +0200 edited question Macro to convert Gregorian calendar to other calendar (example: hijri) Macro to convert Gregorian calendar to other calendar (example: hijri) For example Hijri to Gregorian: (see answer below 2020-06-13 21:27:52 +0200 marked best answer Macro to convert Gregorian calendar to other calendar (example: hijri) For example Gregorian to Hijri : (see answer below) 2020-06-13 21:27:15 +0200 answered a question Macro to convert Gregorian calendar to other calendar (example: hijri) This is example of the function that returns any date from Gregorian date: Function ConvertDate( sDate As String, sCale 2020-06-13 21:27:08 +0200 edited question Macro to convert Gregorian calendar to other calendar (example: hijri) Macro to convert Gregorian calendar to other calendar (example: hijri) This is example of the function that returns any 2020-06-13 21:24:26 +0200 edited answer [SOLVED] Ubound(Array()) doesn't work to know how many elements has the Array with method .getDataArray() You have to change these lines: Print UBound(Simple_Row_array(),1) Print UBound(Simple_Row_array()) with: Print UBou 2020-06-13 21:24:26 +0200 received badge ● Associate Editor (source) 2020-06-13 21:21:43 +0200 commented answer Howto Set LO defaults I think his motives is that he works with people who are used to work with M\$ Office, so this workaround is to be sure t 2020-06-13 21:21:43 +0200 received badge ● Commentator 2020-06-13 21:12:26 +0200 edited answer [SOLVED] Ubound(Array()) doesn't work to know how many elements has the Array with method .getDataArray() You have to change these lines: Print UBound(Simple_Row_array(),1) Print UBound(Simple_Row_array()) with: Print UBou 2020-06-13 21:08:11 +0200 commented question [SOLVED] Ubound(Array()) doesn't work to know how many elements has the Array with method .getDataArray() This line : ThisComponent.Sheets.getByName("Concedidos") will generate error in my libreoffice, because Concedidos sheet 2020-06-13 21:04:06 +0200 answered a question [SOLVED] Ubound(Array()) doesn't work to know how many elements has the Array with method .getDataArray() You have to change these lines: Print UBound(Simple_Row_array(),1) Print UBound(Simple_Row_array()) with: Print UBou 2020-06-13 20:34:48 +0200 edited answer Changing back and forth, RTL and LTR ‪The problem with mixing RTL and LTR is that symbols (spaces included) are neutral to text direction, so they automatica 2020-06-13 19:19:28 +0200 edited answer Changing back and forth, RTL and LTR ‪The problem with mixing RTL and LTR is that symbols (spaces included) are neutral to text direction, so they automatica 2020-06-13 19:17:31 +0200 edited answer Changing back and forth, RTL and LTR ‪The problem with mixing RTL and LTR is that symbols (spaces included) are neutral to text direction, so they automatica 2020-06-13 19:14:56 +0200 edited answer Changing back and forth, RTL and LTR ‪The problem with mixing RTL and LTR is that symbols (spaces included) are neutral to text direction, so they automatica 2020-06-13 19:13:31 +0200 edited answer Changing back and forth, RTL and LTR ‪The problem with mixing RTL and LTR is that symbols (spaces included) are neutral to text direction, so they automatica 2020-06-13 19:05:22 +0200 commented answer Changing back and forth, RTL and LTR It is very limited, they should add at least RLM, LRM, RLE, LRE, PDF to be able to cover most of the case (I translate s 2020-06-13 18:56:44 +0200 answered a question Changing back and forth, RTL and LTR ‪The problem with mixing RTL and LTR is that symbols (spaces included) are neutral to text direction, so they automatica 2020-06-13 15:52:47 +0200 commented question Keybinding don't work on non-English layout I am on windows 10 and am on Arabic keyboard, but don't have this problem. 2020-06-11 13:32:44 +0200 answered a question problem with Arabic letters لأ السلام عليكم، تأكد من استخدامك لآخر إصدار ليبر أوفيس. مثلا الإصدار 6.4.3.2 2020-06-10 19:09:16 +0200 edited answer كيف أكتب بالعربية في برنامج ماث السلام عليكم، يجب أن ترسل طلب الإضافة في موقع صيانة وتحديث ليبر أوفيس : bugs.documentfoundation.org ثم شرح المشكل بال 2020-06-10 19:08:43 +0200 edited answer كيف أكتب بالعربية في برنامج ماث السلام عليكم، يجب أن ترسل طلب الإضافة في موقع صيانة وتحديث ليبر أوفيس : bugs.documentfoundation.org ثم شرح المشكل بالتف