Frage stellen

Alex Kemp's Profil - Aktivität

2020-12-06 08:53:31 +0100 Überarbeitete Frage how do i leave certain cells unprotected on a spreadsheet

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

2020-12-06 02:57:54 +0100 Überarbeitete Frage can't download libre without a disc that is not available just like the other question below so what now.

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

2020-12-02 17:59:59 +0100 Überarbeitete Frage LT not checking grammar

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

2020-12-02 17:50:45 +0100 Überarbeitete Frage administrator is blocking my download can

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

2020-12-02 17:47:43 +0100 Überarbeitete Frage Change corresponding table field to a copied field in Form view

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

2020-12-02 01:13:25 +0100 Überarbeitete Frage Avery Label template inaccurate, how to fix?

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

2020-12-02 01:11:19 +0100 Überarbeitete Frage Please tell me there's a quicker way- Spreadsheet to Shipping labels

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

2020-12-02 01:02:14 +0100 Überarbeitete Frage install on slackware/kde

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

2020-11-29 19:59:09 +0100 Überarbeitete Frage Issue with Merged Cells of table on the document

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

2020-11-29 18:42:25 +0100 Überarbeitete Frage macro basic XYDiagram with regression line

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

2020-11-28 22:06:56 +0100 Überarbeitete Frage Sorting libreoffice gallery items by name

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

2020-11-28 21:57:18 +0100 Überarbeitete Frage In Calc, how can you have separate horizontal scrollbars when window is split horizontally?

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

2020-11-28 21:53:30 +0100 Überarbeitete Frage [Writer] mouse doesn't touch scrollbar

[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.

2020-11-28 21:47:21 +0100 Überarbeitete Frage How to increase libreoffice calc 6.3 scrollbar width?

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

2020-11-28 21:45:37 +0100 Überarbeitete Frage I think we need scrollbar in LO's Customize option so that users can peacefull use the option which are not visible in the screen.

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

2020-11-28 21:43:16 +0100 Überarbeitete Frage How to change scrollbar size

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

2020-11-28 01:18:34 +0100 Überarbeitete Frage when i right click on a cell i get an up-and-down arrow box

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

2020-11-28 01:17:18 +0100 Überarbeitete Frage How do I wholly and fully disable autocorrections, spell checking and grammar checking in Writer?

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

2020-11-28 01:03:38 +0100 Überarbeitete Frage Base - List box not formatted as original field in associated table

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

2020-11-27 15:42:57 +0100 Überarbeitete Frage how to get rid of a highlighted bible verse that I pasted on to a page before printing?

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

2020-11-27 15:29:33 +0100 Überarbeitete Frage Converting issues from Microsoft Word

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

2020-11-26 23:07:03 +0100 Überarbeitete Frage Font problem in 6 2

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

2020-11-26 22:59:19 +0100 Überarbeitete Frage LibreCalc fonts/screen not displayed properly

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

2020-11-26 22:53:20 +0100 Überarbeitete Frage Use different script for numbers for chosen cells (Khmer instead of Arabic) in calculator possible?

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

2020-11-26 22:49:51 +0100 Überarbeitete Frage Embedding Fonts in 6.4

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

2020-11-26 22:25:39 +0100 Überarbeitete Frage reduce fonts displayed in libreoffice

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

2020-11-26 16:30:50 +0100 Überarbeitete Frage how do i get rid of lock on some of my documents?

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

2020-11-26 16:21:09 +0100 Überarbeitete Frage Can I add LibreOffice applications shortcut to desktop/task bar?

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

2020-11-26 16:17:49 +0100 Überarbeitete Frage How to apply colour styles only without changing cell format ?

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

2020-11-26 16:06:54 +0100 Überarbeitete Frage How do I make Heading 2 content be part of ToC?

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

2020-11-26 12:22:37 +0100 Kommentierte Frage Most general fonts?

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

2020-11-26 01:01:05 +0100 Überarbeitete Frage How to zero the last 3 digits of a number (not rounding)

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

2020-11-26 00:40:20 +0100 Überarbeitete Frage How do I convert a Windows .bat job to a LibreOffice job?

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

2020-11-25 13:00:11 +0100 Überarbeitete Frage how do I add extra columns to a spreadsheet

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

2020-11-24 14:20:35 +0100 Überarbeitete Frage Is there a way to locate a saved macro when the sheet was definitely saved but the name of the macro not recorded before the computer shut down?

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

2020-11-23 22:09:24 +0100 Überarbeitete Frage Is it possible to have a Bar Chart with Time values plotted accurately?

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

2020-11-23 22:01:25 +0100 Überarbeitete Frage Is it possible to have a Bar Chart with Time values plotted accurately?

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

2020-11-23 20:51:55 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2020-11-21 23:23:33 +0100 Als beste Antwort markiert What are the Tag Results for all Queries since 2012?

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):

C:\fakepath\os-queries-lo.png

  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:
     
    image description
     
    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.
     
    image description  
  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))

2020-11-21 23:20:01 +0100 Als beste Antwort markiert What are the 6.x Graphics Import/Export Filters?

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?

2020-11-21 23:19:39 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2020-11-21 23:19:27 +0100 Als beste Antwort markiert What are the 6.x Calc Import/Export 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?

2020-11-21 23:19:16 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2020-11-21 23:19:09 +0100 Als beste Antwort markiert What are the 6.x Draw Import/Export 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?

2020-11-21 23:18:51 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2020-11-21 23:18:45 +0100 Als beste Antwort markiert What are the 6.x Math Import/Export 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?

2020-11-21 23:18:39 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2020-11-21 23:18:20 +0100 Als beste Antwort markiert What are the 6.x Base Import/Export 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?

2020-11-21 23:18:00 +0100 Als beste Antwort markiert What are the 6.x Impress Import/Export 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?