I m writing an application, where i ve 30 rows, 1 column with data.
Each cell in the 30 rows has a picture object placed over it (it means an Excel shape).
If i try to get the screen position for the picture objects, that are in the visible range, then i m able to get the screen co-ordinates correctly Say for example for the cells A1..A10.
但是,如果试图在可见的距离内图图图谱上找到屏幕坐标,所回数值是不正确的。
由于在计算X和Y屏幕坐标上适用<代码>ActiveWindow.RangeFromPoint(X,Y),因此APIC正退回。
Can somebody help me?
在我看来,你所说的一切都是有益的,即“x & y 坐标,任何东西都必须在屏幕上,因为这正是他们坐标的决定因素!
例如,最上层和最左边的坐标值为0,0,而(就我而言)最右面价值为1920,1080,因为我的屏幕为1920x1080。 如果标的或点,或表面上的任何东西,点数就可能无效,因为Excel在屏幕可见范围内测量坐标。 现在也许有办法绕过这一点,并说,可能的话说,100号楼中的某一点具有协调价值(10,3000),但谁知道。
您目前面临的问题很可能是我正在处理的问题——你在抽空某个特定物体时如何发现? 似乎你需要一个方案,不断重新测量所有屏幕物体的坐标,并将坐标通过你所需要的方案。 照片或电池可能具有某种Xy的位置,但如果用户浏览、剪辑、左边或右边,或流出的动物,该物体就会与屏幕的边缘有关,从而具有不同的坐标。 如果你知道有一份普通照会要求这样做,我当然要听取它的意见。
我知道我没有完全回答你的问题,但我希望这样做。
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...
