发起问题

# jmid35 的档案 - 活动

 2021-01-01 15:22:04 +0200 获得奖牌 ● 热门的问题 (来源) 2020-12-26 15:36:17 +0200 作最佳回答 Macro to Copy Cell values, formats, and image Hi, I am trying to figure out how to copy a cell from one sheet to another sheet using a macro. The cells contains formatted text and an image anchored to the cell. I am able to copy the cell values and formats using the code below. But it does not copy the image. Any help would be greatly appreciated. oSheets = ThisComponent.getSheets() CopyFromSheet = oSheets.getByName("Sheet1") CopyToSheet = oSheets.getByName("Sheet2") source = CopyFromSheet.getCellrangeByName("C9").getRangeAddress() destination = CopyToSheet.getcellbyposition(8,5).getCellAddress() CopyFromSheet.copyRange( destination , source )  LO 6.2.7 on Win10 2020-11-20 12:49:45 +0200 评论回答 Macro to check if formula bar is visible The reason is, if someone opens the document and they do not have the formula bar visible in their profile then I do not 2020-11-18 23:24:02 +0200 获得奖牌 ● 受欢迎的问题 (来源) 2020-11-18 21:47:51 +0200 评论回答 Macro to check if formula bar is visible This spreadsheet is being used as an interface in a complex application and all the toolbars and the formula bar are hid 2020-11-18 21:09:14 +0200 获得奖牌 ● 自学者 (来源) 2020-11-18 21:09:14 +0200 获得奖牌 ● 老师 (来源) 2020-11-18 20:31:22 +0200 回答问题 Macro to check if formula bar is visible I think I found a workable solution. I modified your code @Lupp to use the VisibleArea.Height Function isFormulaBarVisi 2020-11-18 19:13:04 +0200 评论回答 Macro to check if formula bar is visible I tried that and it works when cell row height is less the the window space of the formula bar. However, if the cell row 2020-11-18 13:24:43 +0200 问了问题 Macro to check if formula bar is visible Macro to check if formula bar is visible Hello, I have a Calc document and I would like to check if the formula bar is 2019-11-18 00:40:29 +0200 获得奖牌 ● 著名问题 (来源) 2019-10-29 00:56:07 +0200 获得奖牌 ● 热门的问题 (来源) 2019-10-25 16:44:04 +0200 评论回答 Macro to Copy Cell values, formats, and image By staying inside i mean that when I copy to Cell H5, the image might be positioned over C2. And yes that is with the im 2019-10-25 00:02:30 +0200 获得奖牌 ● 受欢迎的问题 (来源) 2019-10-24 22:27:34 +0200 评论回答 Macro to Copy Cell values, formats, and image I tried my own code again and it copied it but the image does not stay inside the target cell. 2019-10-24 22:26:34 +0200 评论回答 Macro to Copy Cell values, formats, and image I tried it again and it does copy it but the image does not stay inside the target cell. 2019-10-24 20:09:56 +0200 评论回答 Macro to Copy Cell values, formats, and image Like I said in the original post, the image is anchored to the cell that is being copied. I basically want to create a m 2019-10-24 20:08:03 +0200 评论回答 Macro to Copy Cell values, formats, and image Thank You for the code. I tried it but it does not copy anything. All it does is select the cells. 2019-10-24 16:02:30 +0200 评论回答 Macro to Copy Cell values, formats, and image That is what I am seeing too. Is it possible to copy the image and move the anchor to the cell it is copied to. 2019-10-24 15:32:31 +0200 问了问题 Macro to Copy Cell values, formats, and image Macro to Copy Cell values, formats, and image Hi, I am trying to figure out how to copy a cell from one sheet to anothe