Share to: share facebook share twitter share wa share telegram print page

Help talk:Table


Note: You can also ask questions here: Help desk. Teahouse. Village pump (technical).

Rates per million. Change to rates per 100,000

See: United States drug overdose death rates and totals over time#Comparisons to other countries in Europe.

The rates in the US tables are per 100,000. So I want to convert the rates in the Europe table below from "per million" to "per 100,000". That means moving the decimal place one place to the left. Can someone do this for me?

Better yet can someone explain exactly how to do it step by step in Libreoffice Calc. I will put this info in a section in Help:Table/Advanced or another table help page.

Drug-induced mortality rates per million among adults (15-64), females, males and total.[1]
Location Year Females Males Total
 Austria 2022 18 65 42
 Belgium 2020 7 34 21
 Bulgaria 2022 1 8 4
 Croatia 2022 13 71 42
 Cyprus 2022 3 13 8
 Czech Republic 2022 6 12 9
 Denmark 2021 19 60 40
 Estonia 2022 34 155 95
 Finland 2022 33 106 70
 France 2016 3 16 9
 Germany 2022 10 49 30
 Greece 2020 10 58 34
 Hungary 2021 3 9 6
 Ireland 2020 64 130 97
 Italy 2022 2 13 8
 Latvia 2022 12 96 53
 Lithuania 2022 10 86 47
 Luxembourg 2022 5 31 18
 Malta 2020 6 43 26
 Netherlands 2022 13 40 26
 Norway 2022 53 118 86
 Poland 2021 5 11 8
 Portugal 2021 4 19 11
 Romania 2022 1 3 2
 Slovakia 2021 3 12 7
 Slovenia 2022 16 74 46
 Spain 2021 7 34 21
 Sweden 2022 35 102 70
 Turkey 2022 1 7 4

References

  1. ^ "Overdose situation (FAQ drug overdose deaths in Europe)". European Union Drugs Agency. Scroll down to Figure 1.5. Then; "Show data table".

--Timeshifter (talk) 14:57, 6 March 2025 (UTC)[reply]

I figured out how to do it in free Google Sheets, freeware LibreOffice Calc, and free Excel online.
See: User:Timeshifter/Sandbox284.
--Timeshifter (talk) 22:11, 10 March 2025 (UTC)[reply]
Simplified instructions are here:
Help:Creating tables#Rates per million or per 100,000.
--Timeshifter (talk) 00:56, 13 March 2025 (UTC)[reply]

Template:Scrolling table doc

See the rarely used templates listed in this doc:

There are better methods here:

I am leaving a note here in hopes some others will look and see if I am correct.

If so, someone with more time than me might put the templates up for deletion here:

I suggested the same here:

--Timeshifter (talk) 11:45, 8 April 2025 (UTC)[reply]

I can't tell from this what your question is, but if you want a scrolling table, it is just a matter of setting height (or max-height) and overflow. Ditto width. See WP:PNT, top right just above the ToC; it uses {{PNT table}} and maxes out at around ten rows, and then scrolls. Is that what you are asking about? Mathglot (talk) 20:04, 16 August 2025 (UTC)[reply]
I added a subsection: Help:Table#Scrolling tables. It links to Help:Table/Advanced#Scrolling tables. See it and the sections that follow for examples of scrolling, sticky headers, and combinations thereof. Feel free to add more info there.
I think the scrolling table at Wikipedia:Pages needing translation into English could be done with Template:Sticky table start.
That table used {{PNT table}}, and I haven't studied it to know whether it has specialized functions that would conflict with Template:Sticky table start. Maybe Jroberson108 knows.
As for Template:Scrolling table doc see the horizontal scrolling table at Women's National Cricket League#Team performance. It has a sticky left column, and looks great. But the table wikitext is majorly different from standard table wikitext. And that table can now be done with Template:Sticky table start. --Timeshifter (talk) 17:15, 17 August 2025 (UTC)[reply]

Column operations

Column operations, like row operations, are a fundamental part of tables. There used to be a top-level (H2) section for column operations, until it was removed in this edit. Why was this done? Mathglot (talk) 19:43, 16 August 2025 (UTC)[reply]

The old version at "Column operations":
https://en.wikipedia.org/w/index.php?title=Help:Table&oldid=1288271420#Column_operations
All of that info was about width so I put that info in its own overall section called "Width" on the same page.
Just now I created a new overall section about "Column operations". With a link to the large section on Width (on the same page), and a link to the section on column alignment here: Help:Table/Advanced#Column alignment. That section is part of a much larger overall section: Help:Table/Advanced#Horizontal alignment in cells. That covers alignment in individual cells too.
I remember moving a lot of stuff off the Help:Table page in order to shorten it. Also to get rid of all 2-level subsections. Now you have only one level of subsections. Much easier to navigate.
I think the Width section should not be a subsection of Column operations. Because Width covers full table width too. And it links to another width page covering yet more intricacies of table and column width: Help:Table/Width.
So Width is a large and complicated subject, and deserves to be an overall section. --Timeshifter (talk) 10:14, 17 August 2025 (UTC)[reply]

Helping tool

Hello, is there a tool to help move around columns of a table? It is for this one [1], it is long and many columns are combined at certain parts, so it is sort of complicated. It would be very convenient to have a tool to move around the columns because the order of the featured parties does not reflect anymore their real relevance (for example, the third bloc is completely banned now), so I was wondering if such a tool exists. With the visual editor I can uniquely delete a couple of columns (not most), but I can't move around any. Thanks, Super Ψ Dro 14:02, 20 August 2025 (UTC)[reply]

Hey. There is info here:
Help:Creating tables#Move/delete row/column
But rowspans and colspans probably mess things up.
Jroberson108. Any ideas?
By the way, Super Dromaeosaurus, that table needs Template:Sticky header.
--Timeshifter (talk) 17:09, 23 August 2025 (UTC)[reply]
Hi, in the end I managed to alter the table with the visual editor after some experimenting. I was going to remove this thread but I forgot, so apologies. The issue is now resolved, but appreciate the help anyway. Super Ψ Dro 17:38, 23 August 2025 (UTC)[reply]
OK Super Dromaeosaurus. I added Template:Sticky table start. This version:
https://en.wikipedia.org/w/index.php?title=2025_Moldovan_parliamentary_election&oldid=1307451974#Opinion_polls
--Timeshifter (talk) 18:15, 23 August 2025 (UTC)[reply]
Nice, thank you! Super Ψ Dro 20:26, 23 August 2025 (UTC)[reply]
Super Dromaeosaurus. Looks like someone already broke it. See diff. They removed the left sticky column, and the row hover highlighting {{mw-datatable}}. That really helps follow a row across a wide table. --Timeshifter (talk) 23:06, 23 August 2025 (UTC)[reply]
I agree it is helpful. I suggest pinging the user at the thread you started at the article's talk page and explaining this to them. Super Ψ Dro 23:09, 23 August 2025 (UTC)[reply]

I don't usually do that since there are so many other tables I can improve without objections. --Timeshifter (talk) 23:46, 23 August 2025 (UTC)[reply]

Prefix: a b c d e f g h i j k l m n o p q r s t u v w x y z 0 1 2 3 4 5 6 7 8 9

Portal di Ensiklopedia Dunia

Kembali kehalaman sebelumnya