質問する

Ron's profile - activity

2019-05-06 11:04:50 +0100 バッジを受け取った  有名な質問 (source)
2017-02-01 19:51:32 +0100 バッジを受け取った  卓越した質問 (source)
2017-01-31 00:02:27 +0100 バッジを受け取った  人気の質問 (source)
2017-01-30 23:19:04 +0100 質問に回答する Is it possible to remove the hyperlink underline for mailto: links?

Try this (copied from "How can Calc be prevented from formatting a mailto: link":)

Uncheck Tools > AutoCorrect Options... > Options > URL Recognition. Afterwards, none of the URLs or mail directions will be converted to a link.

2017-01-30 22:14:32 +0100 質問をする How can Calc be prevented from formatting a mailto: link

When I enter an email address in a cell, Calc automatically converts it to a mailto: link. I don't want it to do that. How/where can I turn that off?

2014-01-30 05:13:46 +0100 バッジを受け取った  有名な質問 (source)
2014-01-30 05:13:46 +0100 バッジを受け取った  卓越した質問 (source)
2014-01-30 05:13:46 +0100 バッジを受け取った  人気の質問 (source)
2013-10-11 17:14:33 +0100 バッジを受け取った  有名な質問 (source)
2013-10-11 17:14:33 +0100 バッジを受け取った  卓越した質問 (source)
2013-10-11 17:14:33 +0100 バッジを受け取った  人気の質問 (source)
2012-11-22 14:47:07 +0100 コメント付き回答 [SOLVED] XIRR Function Illegal Argument Exception

Glad to, but don't know how - find no answer button - edited title to say SOLVED, but not correct, I guess. How do I mark it as answered?

2012-11-20 03:53:57 +0100 バッジを受け取った  生徒 (source)
2012-11-20 03:53:01 +0100 バッジを受け取った  自己学習者 (source)
2012-11-12 15:49:58 +0100 質問に回答する [SOLVED] XIRR Function Illegal Argument Exception

Found it! It was that parmsx(0)(0)(0) was an Integer and I didn't catch it. Even though declared as a Double, its value was in the range of an integer and, so, was converted as an Integer. parmsx(1)(0)(0) was not in integer range, though, and was converted as a Double. Changing -18141 to -18141.0001 fixed it.

2012-11-12 04:24:30 +0100 バッジを受け取った  編集者 (source)
2012-11-12 04:05:27 +0100 質問をする [SOLVED] XIRR Function Illegal Argument Exception

I'm trying unsuccessfully to construct my own parameters to the XIRR() function. When I use the DataArray property of a ScCellRange object it works. When I manually constuct the same data (well almost) it gives an illegal argument exception. Here is the parameter construction that works:

  • dim dates as object: dim values as object: dim parms() as object
  • dates = sheet.getCellRangeByPosition(0, startRownum, 0, activeRownum)
  • values = sheet.getCellRangeByPosition(8, startRownum, 8, activeRownum)
  • parms = Array(values.dataArray, dates.dataArray)

Here is the parameter construction that fails:

  • dim valdata(activeRownum - startRownum) as variant
  • dim datdata(activeRownum - startRownum) as variant
  • dim parmsx() as object
  • valdata = array(array(-18141#), array(20965.99484#))
  • datdata = array(array(41026#), array(41213#))
  • parmsx = Array(valdata, datdata)

Here are the data and their structure as viewed in the basic editor: image description

The data appear identical except for some differences in types. I have been unable to exactly duplicate the types and don't know if that is causing the problem.

I have been completely unsuccessful attempting to actually modify the DataArray property of the cell range object even though xray does not say it is read-only. It gives a run-time exception.

XIRR takes a 1Xn array of values and a 1Xn array of the same number of dates. Here are the respective calls to the XIRR function:

  • dim result
  • result = fA.callFunction("XIRR", parms)
  • result = fA.callFunction("XIRR", parmsx)

The call with parmsx gives the exception.

2012-11-02 23:14:53 +0100 バッジを受け取った  サポーター (source)
2012-11-02 23:14:16 +0100 バッジを受け取った  学者 (source)
2012-11-02 23:13:48 +0100 コメント付き回答 macro overlays formula in cell

SOLVED - thank you

2012-11-01 07:26:26 +0100 バッジを受け取った  教師 (source)
2012-11-01 02:12:31 +0100 質問に回答する adding numbers within a single cell

Code your initial entry in the cell as "=4". When you return to add the 5, edit the cell (just hit F2) and append "+5" to the "=4", giving "=4+5". Hit enter and the resulting "9" will be displayed.

2012-11-01 02:07:34 +0100 質問をする macro overlays formula in cell

When a cell is selected and it contains a formula, Calc by default shows the formula in the formula bar and the calculation result in the cell.

But when I code =MyMacro() in a cell and MyMacro() saves a result in the cell with thisComponent.currentController.selection.setValue(result) the formula is overwritten with the result and the call to MyMacro() is lost. The result displays in both the selected cell and in the formula bar.

What did I do wrong or fail to do?