질문하기

Pantona's profile - activity

2020-05-26 15:52:37 +0100 받은 배지  유명한 질문 (source)
2020-05-26 15:52:37 +0100 받은 배지  주목할 만한 질문 (source)
2020-05-26 15:52:37 +0100 받은 배지  인기있는 질문 (source)
2020-05-26 15:52:04 +0100 받은 배지  유명한 질문 (source)
2020-05-26 15:52:04 +0100 받은 배지  주목할 만한 질문 (source)
2020-05-26 15:52:04 +0100 받은 배지  인기있는 질문 (source)
2019-07-09 20:51:30 +0100 코멘트달린 답변 LibreOffice Calc: “Goal Seek” macro with target cell instead of target value?

Thank you very much! :-)

2019-07-09 20:51:22 +0100 으뜸 답변으로 표시됨 LibreOffice Calc: “Goal Seek” macro with target cell instead of target value?

Assumed we have this simple macro code for goal seek a value:

oGoal = seekGoal(oFormulaCell.CellAddress, oVariableCell.CellAddress, "20")

Would it be possible to replace the current value "20" with the value taken from a cell, e.g. taken from the cell oTargetValueCell.CellAddress?

I would love to use something like:

oGoal = seekGoal(oFormulaCell.CellAddress, oVariableCell.CellAddress, oTargetValueCell.CellAddress)

If it may help, here you can see the whole current (working) macro code:

Sub Goalseek

    Dim Sheet2
    Dim oFormulaCell
    Dim oTargetValueCell
    Dim oVariableCell
    Dim oGoal

oSheet = ThisComponent.Sheets(0)

oFormulaCell = oSheet.getCellRangeByName("A1")
oTargetValueCell = oSheet.getCellRangeByName("A2")
oVariableCell = oSheet.getCellRangeByName("A3")

oGoal = ThisComponent.seekGoal(oFormulaCell.CellAddress, oVariableCell.CellAddress, "20")
oTargetCell.setValue(oGoal.Result)

End Sub
2019-07-09 18:59:38 +0100 질문에 댓글을 달았습니다 Calc: How to create a simple "Goal Seek"-macro?

@Ratslinger: I've created a better request that is already working, but not perfectly. :-) You can have a look here: htt

2019-07-09 18:58:13 +0100 질문하였습니다 LibreOffice Calc: “Goal Seek” macro with target cell instead of target value?

LibreOffice Calc: “Goal Seek” macro with target cell instead of target value? Assumed we have this simple macro code for

2019-07-08 20:35:43 +0100 질문을 편집했습니다 Calc: How to create a simple "Goal Seek"-macro?

Calc: How to create a simple "Goal Seek"-macro? I tried to create a simple macro to run a "Goal Seek" (same as "Tools" -

2019-07-08 20:35:08 +0100 질문하였습니다 Calc: How to create a simple "Goal Seek"-macro?

Calc: How to create a simple "Goal Seek"-macro? I tried to create a simple macro to run a "Goal Seek" (Tools -> "Goal

2018-10-31 12:57:35 +0100 받은 배지  정리의 달인
2018-10-27 20:53:01 +0100 받은 배지  주목할 만한 질문 (source)
2018-10-27 20:53:01 +0100 받은 배지  유명한 질문 (source)
2018-08-17 02:46:44 +0100 받은 배지  유명한 질문 (source)
2018-08-17 02:46:44 +0100 받은 배지  인기있는 질문 (source)
2018-08-17 02:46:44 +0100 받은 배지  주목할 만한 질문 (source)
2018-05-10 22:23:29 +0100 질문하였습니다 LibreOffice Calc: How to export spreadsheet into iCalendar format (*.ics) file?

LibreOffice Calc: How to export spreadsheet into iCalendar format (*.ics) file? Let's assume we want to create a simple

2017-11-30 05:08:29 +0100 코멘트달린 답변 LibreOffice Calc: How to auto-fill a row with double click on handler?

Thank you very much! Maybe it would be useful if the LibreOffice-developers could add such a feature for columns also fo

2017-11-30 05:06:37 +0100 으뜸 답변으로 표시됨 LibreOffice Calc: How to auto-fill a row with double click on handler?

In the vertical way auto-fill works very easy with a simple double-click on the handler (which is located in the lower right edge of the marked cell). Then the whole column is getting auto-filled until the neighbour column on its left hand side is not occupied anymore.


How can I do the similar thing like auto-fill a horizontal row until the neighbour row above is not occupied anymore?

2017-11-30 05:06:37 +0100 받은 배지  학자 (source)
2017-11-30 05:06:36 +0100 받은 배지  조력자 (source)
2017-11-30 05:01:28 +0100 받은 배지  인기있는 질문 (source)
2017-11-30 00:45:03 +0100 받은 배지  학생 (source)
2017-11-29 18:45:00 +0100 질문하였습니다 LibreOffice Calc: How to auto-fill a row with double click on handler?

LibreOffice Calc: How to auto-fill a row with double click on handler? In the vertical way auto-fill works very easy wit