Alex Kemp's Profil - Aktivität

hoe do i leave certain cells unprotected on a spreadsheet when protecting a spreadsheet how do i leave specific cells un

canr down load libre without a disc that is not available so what now Hi, We have attempted to download libre Office sev

LT not checking grammer I have installed the Language tool to check grammer and it is part of the 'Tools' in my Libre Of

admistrator is blocking my download can says administrator is blocking download never seen this one before is this a mic

Change corresponding tabel field to a copied field in Form view I have added a field to the tabel I'm using. If I copy a

Avery Label template inaccurate, how to fix? When I print from Microsoft Word, my Avery 8160 (inkjet, address labels) la

Please tell me there's a quicker way- Spreasheet to Shipping labels So my work database spits out excel spreadsheets tha

intall on slackware/kde Have you got a version that will install on slackware/kde? Regards, John

Issue with Merged Cells of table on the document Hi, In our application we are using libreoffice 4.3 which is convertin

macro basic XYDiagramm with regression line My script makes only points with line. Instead of this standard line I want

Sorting libreoffice gallery items by name Can the gallery please be updated to add the ability to sort gallery items by

In Calc, how can you have seperate horizontal scroll bars when window is split horizontally? In Calc, how can you have s

[Writer] mouse doesn't touch scrollbar I use: LibreOffice Writer Version: 6.1.5.2 Build ID: 6.1.5-2 CPU: 2; OS:Linux 4.

How to increase libreofice calc 6.3 scrollbar width? How to increase libreofice calc 6.3 scrollbar width? Thanks in a

I think we need scroolbar in LO's Customize option so that users can peacefull use the option which are not visible in t

How to change scrollbare size In LibreOffice (Calc) 6.4 the scrollbar is too small/thin. How do I increase the size? T

when i right click on a cell i get and up and down arrow box when i right click on a cell i get a small box with up and

How do I wholly and fully disable all automatic changes in Writer? How do I fully and wholly and without exception compl

Base - List box not formated as original field in associated table Hi folks, Im trying to create a small database for m

how to get ride of a hightlighted bible verse that I pasted on to a page before printing? I want to use your office prog

Converting issues from mircosoft word I have some issues with a downloaded document ( https://goo.gl/DhuFxV ) it opens w

Font problem in in 6 2 Since I loaded the newest version the Fonts are all in some foreigh language even though I instal

LibreCalc fonts/screen not displayed properly [Using Linux Mint 19.2, LO via Flatpak] I have not been able to upgrade L

Use different script for numbers for chosen cells (Khmer instead of arabic) in calculator possible? Valued team and memb

Embedding Fonts in 6.4 All of my free, open source mathematics texts and workbooks are created with LibreOffice. I had b

reduce fonts displayed in libreoffce On my system (Linux) there is a huge number of fonts installed... some by TeX, som

how do i gert rid of lock on some of my documents? This is a recent occurance. The word lock in front of my documents wi

Can I add LibreOffice applications shorcut to desktop/task bar? I want to open Writer / Calc with one double click!

How to apply colour styles only without changing cell format ? Hi, i have custom style "Sold" based on the default "Good

How do Imake Heading 2 content be partof ToC? I am using LibreOffice version 6.0.7.3 on Ubuntu 18.04.10. When I try to c

Microsoft have open-sourced all the fonts used in early Windows. They can be installed under Linux using ttf-mscorefonts

How to zeroe the last 3 digits of a number (not rounding) In LibreOffice Calc, how do I zeroe the last 3 digits of a num

How do I convert a widnows .bat job to a LibreOffice job? This job is run on the black command window. Like this: C

how do I add extra collumns to a spreadsheet I have a spreadsheet with three columns but want to ad another three

Saved Macros Is there a way to locate a saved macro when the sheet was definitely saved but the name of the macro not re

Is it possible to have a Bar Chart with Time values plotted accurately? C:\fakepath\barometer.csv.ods (rename to .CVS)

Is it possible to have a Bar Chart with Time values plotted accurately? C:\fakepath\barometer.csv.ods (rename to .CVS)

C:\fakepath\tags-numbers-charts.ods
C:\fakepath\tags-list.ods

This site has been operating since 2012 and, as I ask this question, contains 42,100 queries. Most of those questions are about LibreOffice, and every question is required to have at least one (very mysterious) Tag attached.

Yesterday I collected every tag for every question ever asked, put them into Calc and did an analysis, with 3 charts made of the results (first below is the image of the chart for the spread of OS reported, then the 3 charts that are currently available):

1. LibreOffice Package Queries (36,549 total)
2. LibreOffice Version Queries (7,393 total)
3. Operating System Queries (7,523 total)

Now, as you can tell, those charts need improvement. Nevertheless, I hear you say, where can we get the results? Well, the ODS is linked above (tags-numbers-charts.ods).

How did you do it, Alex?

1. Collect the Tags using a wget script (creates 165 text-files):

   for a in {1..165};    
   do    
       get="sort\=used\&page=$a"; wget -O tags-$a \    
       https://ask.libreoffice.org/en/tags/?$get;    
   done;

2. Extract each tag+number from each file as above into a .csv file:

   for a in {1..165};
   do
       fgrep -B1 '×' tags-$a | \
       awk '{ \
           if(index($1,"data-tag-name")) \
               { printf $1" "; getline; print $3 } \
       }' | \
       sed 's/^data-tag-name="\([^"]*\)".*215;\([,0-9]*\).*/\1 \2/' - >> tags.csv;
   done;

3. Use the CSV import routine to create a list of all the tags together with it's number in the aslibo DB:
    
   
    
   That creates tags.csv (same as the original file) and needs to be saved as a standard ODS file (available at top as tags-list.ods).
    

4. That list of tags needs de-duping.
    
   I installed remove-duplicates-fast. It removed an astonishing 1,173 dupes.
    
    
5. Classify & name the tags + produce the charts.
    
   ...and there you have it. Hopefully interesting.

If this helps then please tick the answer (✔)
...and/or show you like it with an uptick (∧)

(edit: created proper code sections (originals are each all on one line))

On 8 Oct 2015 I listed the LO-5.0.0 Graphics import/export filters. Those filters are made use of every time we import from, or export to, a LO-file (whether it is a Base, Calc, Impress or Writer file). So, 5 years later, what are the current Graphics filters?

On 19 Nov 2015 I detailed the LO-5.0.0 Calc import/export filters. 5 years later, what are the current Calc filters?

On 8 Oct 2015 I listed the LO-5.0.0 Draw import/export filters. Those filters are made use of every time we import from, or export to, a LO-Draw file. So, 5 years later, what are the current Draw filters?

On 8 Oct 2015 I listed the LO-5.0.0 Math import/export filters. Those filters are made use of every time we import from, or export to, a LO-Math file. So, 5 years later, what are the current Math filters?

On 8 Oct 2015 I listed the LO-5.0.0 Base import/export filters. Those filters are made use of every time we import from, or export to, a LO-Base (database) file. So, 5 years later, what are the current Base filters?

On 8 Oct 2015 I detailed the LO-5.0.0 Impress import/export filters. Life is 5 years further down the stream, so what are the current Impress filters?