Questions tagged [Spreadsheets] (21)

1
answer

How to create a conditionally-dependent cells in Calc?

There is a table consisting of two columns "name" and "quantity". How to make another table(m. b. and from another file) found in the first table, a certain "name"(or better the key word) and take the corresponding "number"?
elroy_Nitzsche asked April 8th 20 at 17:49
1
answer

Than watching a large table on a Mac?

There are several csv tables with many millions of rows. Than you can view them correctly on a mac?
Hellen59 asked April 4th 20 at 12:22
1
answer

How to make the standardization of Excel in PHP?

The system is written in PHP, the reports are uploaded in Excel (xlsx) using PHPSpreadSheet. You have to write nested loops. With cycles without attachments no problem, but how to make 2 investments in cycles is unclear. The array looks like this:$a = [ [ 'id' => 1, 'name' => 'Test', 'items' => [ [ 'label' =>...
stephanie_Dietrich asked April 4th 20 at 01:52
0
answer

In openoffice write only those rows that exist in another table openoffice?

Table 1 is a list of products with columns: "SKU", "product description"(in the table 1200 lines) The table has 2 columns: "SKU" and "product price".(there are 530 lines) Task: table 1 leave only need 530 lines with articles which are in vol. 2, delete the rest. Know that this is a simple VLOOKUP or VLOOKUP (in my case), a...
Alford.Becker asked March 31st 20 at 15:02
0
answer

Is there a web table design?

Is there a web table design, as the screenshots below? I need to quickly throw a different table structure, such as a registry of projects. The columns can change quite frequently, and I want buns like domain authentication, ACL, etc. Important point is you want to deploy in their facilities, on premise. I understand that ...
lysanne_Wucke asked March 29th 20 at 23:52
1
answer

Can we implement the timer with the click of a cell in Google spreadsheets?

Click on the cell to the right of the task, went to countdown (without visualization), changed the color of the cell. Click again, the countdown stopped, color returned to the original. The second click in a cell is the time difference between the current and previous click. If the cell already had a value, they are added t...
orland_Barro asked March 29th 20 at 20:51
1
answer

What is the macro for counting duplicates in Excel?

Hello. There is a table What is the formula required for this task: The first column product_id (our) Go the duplicate ID The last column hotline sort parameter The number in the list. In a specific ID range. Was: 55332 2 55332 2 50696 2 50696 2 50696 2 55332 2 55332 2 55332 2 Became 55332 1 55332 2 50696 1 50696 2 50696 3 ...
Alyce_Harb asked March 29th 20 at 20:27
3
answers

How to enter the data from the database into the table?

Get this information from the user base. How to display data in a table, so to speak. Example below.[{"id":"5","test_1":"test.5","test_2":"testing.5"},{"id":"4","test_1":"test.4","test_2":"testing.4"},{"id":"1","test_1":"test.1","test_2":"testing.1"}] Consider a table: Number = id Test = test_1 Test = test_2
Kianna asked March 29th 20 at 19:30
1
answer

Wordpress — create a table to fill in the guests/users of the site (not via CC)?

Everyone, good day! From time to time during the last 2 weeks digging Google in search of information on your issue (further maximized). I need to create on the website a form with defined fields, which will populate the users website. In addition, we need a separate page (not in the WP control panel) where you will have al...
Creola.Smith76 asked March 24th 20 at 13:22
2
answers

What is the analogue of Excel to be able to preview the link?

I have a table with the following structure:silkair, name, description, bet, max bet I want to make when you mouse over the link to display the preview image. Found a solution in VBA, but it doesn't work for my version of Excel. In Excel, you can add the annotation to the cell and insert the image, but in this case, the im...
Aglae.Bradtke asked March 24th 20 at 10:22