949 questions
-1 votes
1 answer
58 views
How to copy the visible row instead of all row til the last row?
In my excel, there is a filter at E6 always, so the next visible row could be E170 or E600 or others, and i just wanna copy the visible rows under E6 instead of copying all rows before the last row. ...
0 votes
1 answer
90 views
How do I COUNTIF visible cells only with multiple criterias?
I have a working formula where column W is the range, and the criteria is LESS THAN OR EQUAL TO -0.15. =SUMPRODUCT((W:W<=-0.15)*(SUBTOTAL(103,OFFSET(INDEX(W:W,1),ROW(W:W)-MIN(ROW(W:W)),0)))) ...
0 votes
1 answer
85 views
Nested DIV going over the border of the parent DIV
I have a DIV nested within another DIV. The parent DIV has a border. The nested DIV matches the overall size of the parent DIV. By positioning the nested DIV absolutely, and using negative positions, ...
1 vote
1 answer
54 views
Summing up filtered html columns takes to much time, how to speed it up?
With my very basic "knowledge" in javascript I have written the following generic function to sum up filtered columns (i.e. the content of the visible <td> elements of a filtered ...
0 votes
1 answer
162 views
PyQt - Hidden widget leaves space in Window
I have the following code that produces a window with a QTableView visible. I add a QTextEdit to the right but hide it. When I run the code it looks as though space has been reserved on the right for ...
5 votes
2 answers
3k views
How can I distinguish between element not visible and not rendered?
I'm using Playwright for testing and need to differentiate between an element being hidden with CSS (via display, visibility, opacity, etc.) and an element not being rendered at all, meaning it's not ...
0 votes
3 answers
278 views
How to set visibility criteria in Asp.net Core 6 MVC web forms
I have this <div class="mb-3"> <label asp-for="DeliveryDt" class="control-label"></label> ...
0 votes
0 answers
53 views
C#, Forms, DataGridView. Unexpected Visible behaviour
I working on application with DataGridView. It contains several tabs, each tab includes a DataGridView of some parameters. I need implement Admin and User modes, where each grid table should hide some ...
0 votes
3 answers
695 views
Addressing Only Visible Cells when Using the .SpecialCells(xlCellTypeVisible) Method
I wish to perform calculations on only the visible cells of a filtered table range. I am able to set the filtered range using the .SpecialCells(xlCellTypeVisible) method but when I loop through the ...
1 vote
2 answers
81 views
Hiding sheets based on a list
I want to hide sheets whose names are not present in a list. I'm looking to replace the use of "Visible" with a reference to a list of cells in a worksheet named Visible. I need to replace ...
2 votes
1 answer
3k views
How to apply following formula for visible cells only?
=SORT(UNIQUE(FILTERXML("<t><s>"&TEXTJOIN("</s><s>",TRUE,A2:J6)&"</s></t>","//s"))) The above formula is for ...
0 votes
2 answers
70 views
Change the Visible property on several elements at once
In this code I have several elements like text box and buttons, and on depend the case, some are visible and some are not, like this (there are more elements): txtTipCOP.Visible = true; ...
0 votes
0 answers
51 views
Change visible all buttons create dynamically in loop if I clicked on certain C#
I've got this problem: In the loop I create buttons: for (int i = 0; i < poz; i++) { for (int j = 0; j < pion; j++) { ...
0 votes
1 answer
118 views
How do you make a Windows.Forms ListView item scroll into view?
I use a ListView to show a list of items. When a new item is added, or the user moves one up or down (via buttons), I want the list to scroll to show/keep the item visible to the user. How can I do ...
-2 votes
1 answer
92 views
Do ads recognize if they are visible or not? [closed]
Do ads on webpages recognize if they are visible? So does the website owner get money also if the ad is not visible? I think about situations where the page is not adapted for mobile devices and the ...