質問する

# Chris UK's profile - activity

 2018-01-05 21:53:33 +0200 バッジを受け取った ● 人気の質問 (source) 2017-11-07 20:52:47 +0200 質問をする Calculate based on month (Sharing a Formula) Calculate based on month (Sharing a Formula) I dont know where to share this so I thought here would be a good place as 2017-08-10 09:32:58 +0200 バッジを受け取った ● 有名な質問 (source) 2017-08-10 09:32:58 +0200 バッジを受け取った ● 卓越した質問 (source) 2016-11-21 15:07:39 +0200 バッジを受け取った ● 体系学者 2016-03-10 20:05:13 +0200 バッジを受け取った ● 人気の質問 (source) 2016-03-10 13:53:26 +0200 バッジを受け取った ● 人気の質問 (source) 2016-01-25 13:29:49 +0200 質問に回答する Spell check does not work at all in Version: 5.0.3.2 From what i remember setting up in an earlier version I have to ensure that the dictionaries were set correctly. 2016-01-25 13:29:46 +0200 質問に回答する Move a column from one sheet to another and keep the same data If its the cell reference only you can lock it like this. sheet2.$B$12  2016-01-25 13:27:07 +0200 質問に回答する Why is spreadsheet returning #NAME?, #REF! and #VALUE! try changing your formula, this should do it. =SUM(C5/D5)  As far as i am aware, your version is just for duplicating cell data. 2016-01-25 13:26:18 +0200 質問をする Changing cell data on button click. Im using two buttons and assigning a recorded macro to them, the only way i could get this to work was by assigning the same macro to both mouse down and mouse up events otherwise a double click was required. I created two macros, ToggleOn and ToggleOff both are essentially the same code with just one edit, here is the code: REM ***** BASIC ***** sub Main rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ---------------------------------------------------------------------- dispatcher.executeDispatch(document, ".uno:SelectObject", "", 0, Array()) rem ---------------------------------------------------------------------- dim args2(0) as new com.sun.star.beans.PropertyValue args2(0).Name = "ToPoint" args2(0).Value = "$C$4" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args2()) rem ---------------------------------------------------------------------- dim args3(0) as new com.sun.star.beans.PropertyValue args3(0).Name = "StringName" args3(0).Value = "n" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args3()) rem ---------------------------------------------------------------------- dispatcher.executeDispatch(document, ".uno:JumpToNextCell", "", 0, Array()) end sub  The change i referred to is just a "y" or "n". args3(0).Value = "n"  Can anybody tell me is there a better way to do this, Im not fussy about the form control, button check box or otherwise, i would just prefer to have only one form control that toggles the cell data if possible. 2016-01-25 01:28:36 +0200 バッジを受け取った ● 熱心な人 2016-01-23 21:54:40 +0200 バッジを受け取った ● 自伝作家 2016-01-20 14:19:24 +0200 コメント付き回答 What does it means "IF(A24<"B",$B$13,H24+K24)" cell formulae? Thats good to know about the fixed reference, I have been struggling with that, So any of the references can be fixed, can I mix them so that some are fixed and others dynamic? 2016-01-18 14:29:05 +0200 コメント付き質問 Calc, define database range without empty cells? This might work, not going to answer with it as i dont know. IF($Categories.$A$1:$A$500 !"",$Categories.$A$1:$A$500) 2016-01-18 14:29:03 +0200 質問をする Calc: Duplicate reference formatting automatically? Hello, I have a reference to a range of cells on a seperate sheet, these are in the same document. Is there a way to copy the formatting of the referenced sheets automatically? I'm currently getting frustrated as when i add a new line to the area being referenced it breaks my layout in the first sheet. What i want to be able to copy is the data which works but also the borders, font styles and merged cells. Is this at all possible? or would i need a macro to do it?