发起问题

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