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?