Pergunte aqui

# Perfil de raymondvillain - atividade

 2018-02-19 16:42:43 +0200 Medalha recebida ● Pergunta famosa (fonte) 2018-01-30 07:04:08 +0200 Medalha recebida ● Pergunta famosa (fonte) 2017-12-09 03:32:08 +0200 Resposta comentada CALC: How to write a macro that can be used as a formula? Thanks, that makes sense. I'll have to find a work-around. 2017-12-08 07:52:47 +0200 Medalha recebida ● Pergunta notável (fonte) 2017-12-08 04:25:59 +0200 Pergunta comentada CALC: How to write a macro that can be used as a formula? Running Ubuntu 16.04, Using Libreoffice version: Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2 CPU Threads: 6 2017-12-08 04:25:30 +0200 Pergunta comentada CALC: How to write a macro that can be used as a formula? Using Libreoffice version: Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2 CPU Threads: 6; OS Version: Linux 4. 2017-12-07 22:11:24 +0200 Medalha recebida ● Pergunta popular (fonte) 2017-12-07 20:11:46 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 20:09:35 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 20:08:47 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 20:06:22 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 20:05:59 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 20:05:36 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 20:04:41 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 19:50:58 +0200 Pergunta editada CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 19:44:56 +0200 Perguntou CALC: How to write a macro that can be used as a formula? CALC: How to write a macro that can be used as a formula? Want to enter a macro in one cell of a spreadsheet and have it 2017-12-07 19:39:11 +0200 Medalha recebida ● Pergunta notável (fonte) 2017-10-28 19:18:12 +0200 Marcada como a melhor resposta how to insert values of uniform distribution into a column Wish to select a column (in a Calc spreadsheet) of length 10, say, E10 through E19, and populate it with integer values from a specified interval of a uniform distribution. From the menu, I select Insert > function to bring up a box, under "category" I select "statistical", but there does not appear to be a uniform distribution available. 2017-10-28 19:18:12 +0200 Medalha recebida ● Acadêmico (fonte) 2017-10-28 19:18:02 +0200 Medalha recebida ● Pergunta notável (fonte) 2017-08-16 02:35:24 +0200 Respondeu uma pergunta how to insert values of uniform distribution into a column Thanks! Much appreciated. Kept looking for "Fill" but could not find it. 2017-08-16 02:32:50 +0200 Medalha recebida ● Pergunta popular (fonte) 2017-08-15 20:38:13 +0200 Pergunta editada how to insert values of uniform distribution into a column how to insert values of uniform distribution into a column Wish to select a column (in a Calc spreadsheet) of length 10, 2017-08-15 20:24:06 +0200 Perguntou how to insert values of uniform distribution into a column how to insert values of uniform distribution into a column Wish to select a column of length 10, say, E10 through E19, a 2017-08-09 04:15:43 +0200 Medalha recebida ● Entusiasta 2017-08-08 22:46:44 +0200 Medalha recebida ● Pergunta popular (fonte) 2017-08-08 20:35:46 +0200 Perguntou number size in bytes number size in bytes Is there a built in function that returns the size, in bytes, of a hexadecimal integer? 2016-06-25 15:10:53 +0200 Resposta comentada Calc user created default template only affects Sheet1 I have the same problem, cannot open new calc spreadsheet and have desired cell alignment on any sheet other than sheet1. Created template with desired alignment and set it as the default. Then opened a new spreadsheet. Sheet1 had the desired alignment, but NOT SHEET 2 (or 3, or 4....). Is it possible to have the "default template" control the format of new spreadsheets with more than one sheet? 2016-01-22 17:21:25 +0200 Medalha recebida ● Pergunta famosa (fonte) 2014-05-14 10:06:58 +0200 Medalha recebida ● Pergunta notável (fonte) 2014-04-25 22:33:22 +0200 Medalha recebida ● Pergunta notável (fonte) 2014-04-25 22:33:22 +0200 Medalha recebida ● Pergunta famosa (fonte) 2014-04-25 22:24:38 +0200 Medalha recebida ● Pergunta famosa (fonte) 2014-02-13 21:00:55 +0200 Medalha recebida ● Pergunta popular (fonte) 2014-01-13 16:38:37 +0200 Perguntou how to modify dde links Calc spreadsheet linked to tables in Writer. For unknown reason, some DDE links are not updating ("#VALUE!" message appears in the Writer document). Tried to modify the DDE links in write (edit-> links-> etc.) but then libreoffice crashes. Any suggestions? 2014-01-07 00:01:23 +0200 Medalha recebida ● Pergunta popular (fonte) 2013-12-31 04:29:22 +0200 Medalha recebida ● Editor (fonte) 2013-12-31 04:28:17 +0200 Respondeu uma pergunta basic function to return cell contents Just figured it out. Cell.getValue is the magic bullet: Function AddFromSheet(Optional nSheet) If IsMissing(nSheet) Then Cell=ThisComponent.getCurrentController().getActiveSheet().getCellRangeByName("C4") AddFromSheet = Cell.getValue  Else Cell=ThisComponent.getSheets().getByIndex(nSheet-1).getCellRangeByName("C4") AddFromSheet = Cell.getValue  EndIf End Function 2013-12-31 04:02:45 +0200 Perguntou basic function to return cell contents Spreadsheet has many sheets. Want to write a basic function that will return the numerical value stored in a particular cell (that is in the same location) in all the sheets. Something like Function AddFromSheet(Optional nSheet) If IsMissing(nSheet) Then AddFromSheet = ThisComponent.getCurrentController().getActiveSheet().$C$4  Else AddFromSheet = ThisComponent.getSheets().getByIndex(nSheet-1).$C$4  EndIf End Function Obviously this doesn't work, but, in general, how does one specify (in the basic programming language) the contents of a particular cell? In the example above, cell C4 contains a real number. I want the function to return this number. 2013-10-04 18:02:33 +0200 Medalha recebida ● Pergunta notável (fonte) 2013-10-03 23:17:01 +0200 Medalha recebida ● Pergunta popular (fonte) 2013-10-03 22:29:36 +0200 Medalha recebida ● Estudante (fonte) 2013-10-03 18:38:59 +0200 Perguntou where to find checksums for LibreOffice for windows 8 64 bit running Microsoft command line check sum executable (csiv.exe), need to compare it to the known correct value. Is it to be found on the web?