Ask Your Question

ChrisOfBristol's profile - activity

2017-08-16 16:11:09 +0200 commented answer How do I stop "accept change" every time I cut and paste?

I haven't done an upgrade recently, but had the same problem. I've no idea how 'Track Changes - Record' and 'Track Chang

2017-01-03 04:17:44 +0200 received badge  Taxonomist
2016-01-24 16:24:02 +0200 received badge  Popular Question (source)
2016-01-16 21:38:53 +0200 answered a question Writer crashes in Ubuntu MATE 14.04

I've upgraded to Ubuntu 15.10 MATE and there are no problems.

2016-01-16 21:37:10 +0200 received badge  Famous Question (source)
2016-01-16 21:33:44 +0200 asked a question Word document conversion - problem with columns?

I’ve just converted a friend’s computer to Linux and he has started using Writer for his documents. He has a document which he tells me had two columns as a Word document. In Writer the two sides are just aligned with tabs and spaces. Obviously unless he keeps exactly the original page format it turns into a complete mess.

Is the conversion from Word columns to Writer columns a bodge which just spaces out the two halves with spaces and tabs, or is perhaps his memory at fault and he had just used tabs in the Word document?

2015-05-02 13:56:49 +0200 received badge  Famous Question (source)
2015-01-26 19:21:46 +0200 commented question Writer crashes in Ubuntu MATE 14.04

I think this is related to having Calc open as well. It's a serious problem, it's making LibreOffice very nearly unusable.

2015-01-21 00:12:01 +0200 commented answer Writer crashes in Ubuntu MATE 14.04

I have upgraded as you suggest, although the second command should be:

sudo apt-get dist-upgrade

Office Writer and Calc are still crashing though. It happens less often and is more likely to when both are open together.

2015-01-21 00:07:47 +0200 received badge  Notable Question (source)
2015-01-14 14:37:24 +0200 received badge  Popular Question (source)
2015-01-13 22:33:26 +0200 asked a question Writer crashes in Ubuntu MATE 14.04

Writer is crashing quite often, I have auto-save on but I lose any work since the last one. I think it is always related to editing tables.

I am using Version: Build ID: 420m0(Build:2) English Ubuntu 33bit 14.04 MATE English

2014-04-01 19:52:12 +0200 received badge  Notable Question (source)
2014-03-25 19:13:58 +0200 received badge  Supporter (source)
2014-03-25 16:24:41 +0200 received badge  Popular Question (source)
2014-03-25 11:07:26 +0200 received badge  Student (source)
2014-03-25 02:25:52 +0200 commented answer Data labels on data series

That's it and it looks so easy! I have spent hours trying to work this out. Thanks very much! I've just noticed the Legend with the makers' names. That is something else I will use.

2014-03-25 02:01:16 +0200 asked a question Data labels on data series

I have a simple XY Scatter (lines only) graph, all the data comes from a separate sheet. There are two data series - see the two attached pictures.

I have selected Data Labels - Show Category. It doesn't seem to use column B properly to supply the labels. If I choose B2:B4 for VW (to get A, B, C) then try to change the Audi range to B6:B8 (to get AA, BB, CC), I find that the VW range has changed to that as well. It seems to use the same set to apply to both series. In the example here I have set it to B2:B8 hoping it will sort it out itself but as you can see it just starts at the beginning with A for each series. Perhaps I don't understand data ranges properly.

image description

image description

2013-10-21 13:02:34 +0200 received badge  Notable Question (source)
2013-10-21 13:02:34 +0200 received badge  Famous Question (source)
2013-10-21 13:02:34 +0200 received badge  Popular Question (source)
2013-10-01 19:59:45 +0200 marked best answer Associating a group of files

This would be like creating a project - I'd like to associate several different types of documents together, so that I can open one main document then click an option to get a list of documents within that project.

For example a report which associates two spreadsheets and three documents. Ideally opening one would open all of them, so that the whole report is available to work on and I can just swap windows from one to another.

2013-08-13 17:28:43 +0200 received badge  Famous Question (source)
2013-08-13 17:28:43 +0200 received badge  Notable Question (source)
2013-03-22 21:49:03 +0200 received badge  Popular Question (source)
2012-11-27 00:24:56 +0200 received badge  Scholar (source)
2012-11-27 00:11:55 +0200 commented answer Summing a range of cells

Works perfectly - amazing you've saved me hours of frustration! I assume it's not necessary to put the range in the second part because it must match the first part, you are just telling which column to look at.

2012-11-27 00:03:11 +0200 answered a question Summing a range of cells

Mariosv - This looks like the right sort of thing, I'm trying it now.

2012-11-26 23:36:18 +0200 asked a question Summing a range of cells

I would like to sum a range - for example:


1.John 1
2.Paul 2
3.Sue 1
4.Sue 3

sum(column B where column A = Sue) giving result 4 sum(column B where column A = Paul) giving result 2

Looks a bit like SQL really.

The only way I can think of getting round this is to create a "name" for each set of values in column A then sum(sue), sum(Paul) etc. This is a lot of work and it's horrible to use.

Edit: I have found that /Data/Define Range works a lot better for defining ranges, although it doesn't do the selection.

Is there a practical way of doing this?

2012-10-05 18:30:56 +0200 answered a question Associating a group of files

Thanks mjjzf and w_whalley for stimulating my thought processes. Here is the final script, I hope someone finds it useful:

echo There are no guarantees on its actions.
echo For example it needs a limit on the number of files it opens.

project=$(basename "$0")

for fn in *; do

  if [ "$file" = "$project" ] ; then
    if [ "$ext" = "odt" -o "$ext" = "ods" ] ; then
      echo "$fn"
      libreoffice "$fn" &


Check that all the files you want associated with the project and opened at the same time start with the same name and are .ods or .odt ones. Save the script into the directory with the same name, give it the executable property.

Double-click on the script to open all the files but no others, example:


club files.ods

club files.odt

club files spreadsheet 1.ods

club files spreadsheet 2.ods

club files document 1.odt

club files document 2.odt