We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Donaithnen's profile - activity

2019-10-10 13:15:12 +0200 received badge  Student (source)
2018-02-21 17:09:25 +0200 commented question calc column and row headers - grid lines and shading have disappeared

If you ever find out an answer to this I'd love to hear about it. I'm trying to get kind of the opposite effect. I don't

2018-02-20 23:07:49 +0200 commented question Calc row/column header shading

Cross-referencing a similar question: https://ask.libreoffice.org/en/question/55821/how-do-i-modify-columnrow-header-col

2018-02-20 23:07:34 +0200 commented question How do I modify column/row header color?

Cross-referencing a similar question: https://ask.libreoffice.org/en/question/61022/calc-rowcolumn-header-shading/#

2018-01-09 02:31:46 +0200 received badge  Famous Question (source)
2017-11-01 02:06:47 +0200 received badge  Notable Question (source)
2017-11-01 02:06:47 +0200 received badge  Famous Question (source)
2017-11-01 02:06:47 +0200 received badge  Popular Question (source)
2017-03-15 21:26:29 +0200 received badge  Notable Question (source)
2017-02-07 17:14:36 +0200 received badge  Popular Question (source)
2017-02-03 17:18:33 +0200 received badge  Organizer (source)
2017-02-02 21:01:13 +0200 answered a question How to convert conditional formatting to static/permanent formatting

Since i couldn't find an answer here i ended up perusing several Excel and OpenOffice forums. I found multiple answers, but most of them involved running complicated macros to copy the formatting. However there was one slightly awkward but brilliantly simple solution. Just save the spreadsheet as an html document, then open up that html document in LibreOffice. The formatting will have been applied directly to the cells but the conditional formatting will not be present. You can then copy that data to whatever final location you want.

2017-02-02 20:59:04 +0200 asked a question How to convert conditional formatting to static/permanent formatting

This was first asked several years ago (https://ask.libreoffice.org/en/questi...) but apparently closed because it never got an answer.

The question is, given a set of data with conditional formatting, how to you copy that data to another sheet or another document while keeping the visible formatting but _without_ copying the conditional formatting rules. The intent is to "freeze" or "flatten" the formatting onece you've achieved the desired results and don't want any further changes to the data to be reflected by changes in the conditional formatting.

2017-02-02 19:24:46 +0200 commented question How to convert conditional formatting to static and formatted cells with formulas to plain text?

How is this question "not relevant or outdated"? I have the exact same question, this is the first page that came up in Google, and yet it's unanswered and marked as irrelevant.

2017-02-02 19:23:15 +0200 received badge  Enthusiast
2017-01-30 16:17:25 +0200 edited question How do you reference Text in a Pivot Table Data Field?

I'm currently using LibreOffice and am trying to consolidate some data.

What i'm starting with is (very) roughly in the format

Identifier, Name, ID
A, Adam, 1 
B, Bob,  2
D, Doug, 4
E, Eve,  5
Identifier, Amount1, Amount2
A, 2, 1
B, 1, 1
B, 2, 7
C, 4, 0
C, 0, 2
E, 1, 3

I want to combine that all together. The ideal end result would be something like

Identifier, ID, Name, Amount1, Amount2
A, 1, Adam, 2, 1 
B, 2,  Bob, 3, 8
C,  ,     , 4, 2
D, 4, Doug, 0, 0
E, 5,  Eve, 1, 3

A Pivot Table seems like the obvious way to do so, but I can't get it to deal with the text value for the Name.

The ID is easy, i can just select the Max for that, but none of the functions I've tried return anything for text values, except the first Count, which just results in a 1 for all text values. And of course if i add the "Name" value to the Row Fields it then creates two rows for each Identifier, one with the Name and ID but no Amounts, and one with Amounts but no Name or ID.

I realize that applying some of the functions to text wouldn't make any sense, but I would have thought "Max" would have done _something_, and since i know there's only one value for each Identifier in that column it ought to have worked out fine. Failing that why isn't there a "First encountered value" or something like that? Or have i just not found the right option yet?

This seems like such a simple task, but I've been trying to figure it out off and on for over a year, so I figured I would finally give up and ask for some help.


2016-05-25 00:50:15 +0200 received badge  Notable Question (source)
2016-05-25 00:50:15 +0200 received badge  Famous Question (source)
2015-09-09 13:36:17 +0200 received badge  Popular Question (source)
2015-08-10 18:22:02 +0200 commented answer How to return null/empty from function in calc

I can't upvote you because of karma, but this solved my identical problem perfectly! Thank you!

2015-08-07 11:17:12 +0200 asked a question How do I modify column/row header color?

Back in OpenOffice 2.1 the column and row headers had a nice solid dark grey color. However by the time 3.4.1 came along someone had decided it would be cool to add a color gradient. They left the interior portion (right side on row headers, bottom side on column headers) dark grey but made the other part light grey.

I find the visual clutter distracting, to the point that it sometimes makes it hard to focus on the letters/numbers in the headers. I'm sure it doesn't bother most people, but for me this aesthetic quirk is interfering with the primary reason for the existence of those headers in the first place.

When LibreOffice forked off of OO this was one of the many "features" that got carried along, and years later it still bugs me.

I would like to change the background color of the column and row headers back to a solid color. Preferably dark grey. Is there any way to do this?



Windows 7 Enterprise