Ask Your Question

redwdc's profile - activity

2020-10-30 17:39:27 +0100 marked best answer What happened to Tools > Options > LibreOffice > Colors?

I'm running Version: 5.4.3.2 (x64) and noticed that Tools > Options > LibreOffice > Colors is no longer there. It use to be between "Paths" and "Fonts.

I've added over 10 custom colors I use as background colors in one of my spreadsheets. Which still show up when I click the paint can. However, can't find a way to add any more.

I really don't want to use the provided colors because I need small variations that aren't available. I suppose I can leave version 5.2.2.2 (x64) I have on a second computer there and use it to modify my color palettes, but, that's a real pain.

2019-01-05 01:51:56 +0100 received badge  Famous Question (source)
2018-11-03 05:00:43 +0100 received badge  Famous Question (source)
2018-03-04 19:29:24 +0100 received badge  Famous Question (source)
2018-02-18 01:17:08 +0100 received badge  Notable Question (source)
2018-02-17 22:51:59 +0100 commented answer What happened to Tools > Options > LibreOffice > Colors?

This does work but, it a lot more work than the old way.

2018-02-17 21:54:36 +0100 received badge  Student (source)
2018-02-17 21:53:46 +0100 received badge  Popular Question (source)
2018-02-17 18:38:48 +0100 asked a question What happened to Tools > Options > LibreOffice > Colors?

What happened to Tools > Options > LibreOffice > Colors? I'm running Version: 5.4.3.2 (x64) and noticed that To

2017-11-18 23:25:11 +0100 received badge  Notable Question (source)
2016-12-20 05:11:27 +0100 received badge  Notable Question (source)
2016-12-16 00:38:34 +0100 commented answer Calc: Referencing a directory/file name with an apostrophe in it

@Lupp I'm aware of naming nomenclature in Windows. This is the first time I'm had a problem with an apostrophe that I wasn't able to figure out on my own.

2016-12-16 00:34:39 +0100 commented answer Calc: Referencing a directory/file name with an apostrophe in it

@robleyd LO changes the %27 to a double apostrophe. However, I do thank you for this and will keep it in mind if I ever have similar problems in the future.

2016-12-16 00:25:25 +0100 commented answer Calc: Referencing a directory/file name with an apostrophe in it

@Lupp I'm sure the external reference is correct. Also it isn't a bug Pierre-Yves answer works. Also I'm using 5.2.3.3 sorry I forgot to put that in my question.

2016-12-16 00:21:07 +0100 received badge  Supporter (source)
2016-12-15 16:31:15 +0100 received badge  Popular Question (source)
2016-12-14 23:07:47 +0100 asked a question Calc: Referencing a directory/file name with an apostrophe in it

I use 1 file per year with 14 28 day sheets (over lap of months). I'm trying to copy the data from one file to the next.

However, since the directory they are in is called RED's (with the apostrophe) I get Err.508 in the cell. On the formula bar I see:

=SUM('file:///d:/data/red's/misc_2016.ods'#$'16-12-26'.r30)

I tried putting double quotes " around the directory and file name i.e.

=SUM('file:///"d:/data/red's/misc_2016.ods"'#$'16-12-26'.r30)

But that didn't work. As a test I renamed the directory to REDs and it worked. Other programs/computers reference RED's so I'd rather not rename permanently it if possible.

2016-12-14 22:50:32 +0100 received badge  Popular Question (source)
2016-12-14 22:37:39 +0100 answered a question err:508 Copying from one file to another

I have discovered what the problem is. The name of the directory the files are in has an apostrophe in it "RED's".

=SUM('file:///d:/data/red's/misc_2016.ods'#$'16-12-26'.r30)

So, smilingfrog was right but it doesn't fix my problem.

2016-12-14 22:36:07 +0100 received badge  Scholar (source)
2016-12-12 14:46:47 +0100 asked a question err:508 Copying from one file to another

Hi,

I use 1 file per year with 14 28 day sheets (over lap of months). I'm trying to copy the data from one file to the next.

This is what I'm doing with both files open:

  • click in R2 of 2017 and type "=SUM(" (if I use the closing ")" i get other problems see below.)
  • then click in R30 of 2016
  • go back to 2017 and press "Enter"

I get Err.508 in the cell. On the formula bar I see:

=SUM('file:///d:/data/reds/misc_2016.ods'#'16-12-26'.r30)


If I use "=SUM()" with the cursor between the parentheses on the formula bar I get:

=SUM('file:///d:/data/reds/misc_2016.ods'#'16-12-26'.r30))

which according to help.libreoffice.org would be:

508 | Error: Pair missing | Missing bracket, for example, closing brackets, but no opening brackets.

I'm using: LibreOffice Version 5.2.3.3 (x64) on Windows 10 (1607 build 14393.447)

Bobby

2015-11-04 17:22:20 +0100 received badge  Notable Question (source)
2015-11-04 17:22:20 +0100 received badge  Famous Question (source)
2015-08-26 13:37:55 +0100 received badge  Enthusiast
2015-08-22 00:38:49 +0100 received badge  Popular Question (source)
2015-08-21 03:36:44 +0100 received badge  Editor (source)
2015-08-19 10:01:03 +0100 asked a question In calc the column width changes after I save a file.

Every time I have saved a spreadsheet when I reopen it the columns are thinner. It's not consistent either. I set the Date column to 1.20" and when I reopen the doc it might be 1.19 (I could live with it) or it might be 1.13 which gives me hash marks instead of dates.

I don't want to have to lock the sheet (if that would fix it) because I can be in it several times in a day. I'm not a typist I get tired of typing passwords all day. In the few days I've been playing with LO I've come to like it. So I don't want to go back to OO but this would be a deal breaker.

Edit I was playing with my spreadsheet today because of m.a. riosv's comment.

Cell A1 = "Date" - Font = Arial 9 - Width = 1.20"

Cell A2 = "Mon 2015-07-20" - Font = Arial 10 - Formated = Date - ddd yyyy-mm-dd

See a picture at web.newsguy.com/redwdc/forum_images/spreadsheet_2015-08-20.png

When I save as .xlsx the column width will is set to 1.20" then the next time I open it the column is thinner. If thin enough the date looks like "####".

When I save as .xls it saves the column widths correctly.

Also both formats (.xls and .xlsx) don't save cell padding (Format > Cells > Borders > Spacing to Contents). I set it to 0.00" and when I re-open it's back to 0.02" However, if I save as .ods it stays at 0.00".

2015-08-17 06:33:37 +0100 answered a question why won't libreoffice 5 install with windows 10

I had no problem installing LO 5.0.0.5 on Windows 10. However I do have UAC (User Account Control) turned off.

2015-08-17 04:31:31 +0100 commented answer How can I disable autocomplete in calc?

Thank you for the answer to this one.