Ask Your Question

JimM's profile - activity

2019-07-12 10:38:31 +0200 marked best answer Does LibreOffice have a convert from pdf to .csv or .ods function?

I often download data in .pdf files that must be converted to .csv or .ods formats for subsequent analysis. Does LibreOffice have a native function or existing utility (would this be called an extension?) that performs such a function? I am aware of and have used multiple online pdf -> csv converters, the plethora of which attest to the need, so this function built into LibreOffice would be welcomed by many, I suspect.

Thank you.

Jim Martin

2019-07-12 10:37:00 +0200 marked best answer Possible to change color of the find highlighting?

When using the Find function in Writer to search for something, the results are highlighted. The highlight color is a pale, almost translucent green (that's the color I see). This color is difficult to see, particularly when the highlighted result is swimming in a sea of words on a page.

The question: Is it possible to change the color with which Find highlights found items?

Note: I am asking about the color the Find function uses to highlight a result. I am not asking about changing the highlight color that users choose and apply directly to selected text.

2019-07-12 10:36:12 +0200 marked best answer calc comparative column line chart

LibreOffice: Version: 6.1.2.1 Build ID: 65905a128db06ba48db947242809d14d3f9a93fe CPU threads: 4; OS: Mac OS X 10.14.5; UI render: default; Locale: en-US (en_US.UTF-8); Calc: group threaded

I have occasion to prepare a chart that has the following qualities: 1. It is a column and line chart. 2. Each column represents one variable. 3. Each column is partitioned into sections. 4. Sections represent one measurement for one category variable. 5. Sections are stacked in the same order. 6. A line connects one section in one column to the corresponding section in the next column. 7. The line represents the end value of one category measurement and the begin value of the succeeding category. 8. Lines do not cross; they follow the section pattern the stacking order dictates.

Describing this need using 1,000 words is no match for one picture, so one is attached. Connecting lines are drawn in, not embedded. Lines are grouped; they retain relative position to one another when the grouped unit is moved. However, and this is the problem, when the chart is moved or zoomed in / out, the line group does not move or zoom. How would a user go about making the position of the line unit relative to the chart stable? Is embedding the line unit as an OLE object in the chart possible, in lieu of a native capacity to create such charts?

LO Chart documentation is silent regarding this topic. Neither does such appear among questions in this forum.

Thank you for considering this issue.

Jim Martin

image description

2019-07-12 10:33:31 +0200 marked best answer Create an updatable link from within Writer to a Calc Chart?

Because my original question seems to have been unclear to experienced users, I am once again asking it, but with revisions rendering it more clear. Thank you to the people who responded the first time.

Context: 1. I have a Writer document; 2. I have a Calc document (spreadsheet); 3. Within the Calc document is a chart; 4. The chart is created from data in that same spreadsheet.

Desired outcome: 1. Insert into the Writer document the chart in the Calc document; 2. The inserted chart is to possess two qualities: a. It is to be linked to the Calc document; b. Updates made in the Calc document appear also in the Writer document.

Process outlined in LibreOffice user guides: 1. Perform these steps in Writer: Insert->Object->OLE object->Create from file->Link to file->Search->(select target file)->Open->OK

Discussion: At no step in this process is a Calc chart defined as an entity. At no point is such an entity identified as an OLE candidate to be inserted, linked, and possessed of the quality of updatablility in a Writer document. The Writer Insert ->...->...->...-> OK process selects a file. At no point in the Writer Insert process are there instuctions or options allowing selection of an entity (the Calc chart) in the Calc document.

Question: What do I need to do so that the Writer Insert -> link to file -> Search -> OK series of commands results in: 1. A Calc chart in a Writer document that a. Is identifiable from within Writer using the Insert Object...OK command series as an OLE candidate; b. Is selectable using the Writer Insert Object...OK command series; c. Is inked, once inserted in the Writer documenrt, to the source Calc document; and d. Can be updated in Calc so that the updates also appear in Writer.

In other words, how do I insert a defined Calc entity such as a chart into a Writer document as a linked, updatable OLE object?

I hope the question is now clear.

Thanks for your insights and instructions.

2019-07-12 10:33:31 +0200 received badge  Scholar (source)
2019-07-12 10:32:21 +0200 commented question calc chart template

The answer that Cabill provided works. In the future, I will know to click on the check mark that is to the left of the

2019-06-17 19:20:46 +0200 commented answer calc comparative column line chart

Catbill, Thank you for making the suggestion. I shall attempt to create such a chart. if it conveys the information I

2019-06-06 13:12:00 +0200 received badge  Notable Question (source)
2019-06-06 09:45:43 +0200 commented answer calc comparative column line chart

Hello Grantler. The idea you provide is useful. That the ability to update the chart by updating the data in it is los

2019-06-06 09:38:21 +0200 commented answer calc comparative column line chart

Thank you, Lupp. Your responses to questions are illuminating, and usually point toward a solution if one exists.. I ha

2019-06-06 09:37:28 +0200 commented answer calc comparative column line chart

Thank you, Lupp. Your responses to questions are illuminating, and usually point toward a solution if one exists.. I ha

2019-06-06 05:10:44 +0200 received badge  Famous Question (source)
2019-06-01 07:31:07 +0200 answered a question calc chart template

A definitive answer to my question has surfaced. It is: "All features in a chart are editable, but LibreOffice supplie

2019-06-01 05:41:29 +0200 received badge  Popular Question (source)
2019-05-31 12:25:04 +0200 asked a question calc comparative column line chart

calc comparative column line chart LibreOffice: Version: 6.1.2.1 Build ID: 65905a128db06ba48db947242809d14d3f9a93fe CPU

2019-03-29 11:20:51 +0200 commented answer Create an updatable link from within Writer to a Calc Chart?

I thank Lupp for the clarification regarding a broken "link" between a Calc chart and its copy in a Writer document. Co

2019-03-29 11:19:19 +0200 commented answer Create an updatable link from within Writer to a Calc Chart?

I thank Lupp for the clarification regarding a broken "link" between a Calc chart copied to a Writer document. Contrary

2019-03-25 07:39:30 +0200 commented answer Create an updatable link from within Writer to a Calc Chart?

After some months without a need to re-visit the original subject, I now find Lupp's response from 11/22/18. The critic

2019-03-11 20:50:13 +0200 received badge  Notable Question (source)
2019-03-10 06:06:36 +0200 received badge  Notable Question (source)
2019-03-02 17:12:43 +0200 commented answer Possible to change color of the find highlighting?

Thank you, RGB-es, for the information. It makes sense that Writer would use the OS setting rather than complicate the

2019-03-02 12:42:55 +0200 received badge  Popular Question (source)
2019-03-02 07:43:29 +0200 asked a question Possible to change color of the find highlighting?

Possible to change color of the find highlighting? When using the Find function in Writer to search for something, the r

2019-02-08 17:23:18 +0200 answered a question remove file password protection

The response Lupp made 06/16/2018 is correct. 1. Open the password-protected file. Of course, you must enter the correc

2019-02-06 05:27:32 +0200 received badge  Enthusiast
2019-02-01 02:16:25 +0200 received badge  Popular Question (source)
2019-01-25 03:47:33 +0200 asked a question calc chart template

calc chart template A template in a simple sense is an existing format object into which novel content repeatedly can be

2019-01-07 14:24:27 +0200 received badge  Famous Question (source)
2018-12-27 19:37:50 +0200 received badge  Notable Question (source)
2018-12-27 12:29:50 +0200 received badge  Popular Question (source)
2018-12-27 03:05:17 +0200 asked a question Does LibreOffice have a convert from pdf to .csv or .ods function?

Does LibreOffice have a convert from pdf to .csv or .ods function? I often download data in .pdf files that must be conv

2018-12-05 08:38:05 +0200 answered a question Create an updatable link from within Writer to a Calc Chart?

Thanks to Ratslinger for a most complete and thoughtful answer to the question. Given the opportunity of time to do so,

2018-12-03 23:16:29 +0200 received badge  Famous Question (source)
2018-12-03 17:34:42 +0200 commented question Create an updatable link from within Writer to a Calc Chart?

Mr. Kaganski is correct in all but one detail, although it may be unimportant. Writer, not Impress, is the module I want

2018-12-03 17:34:07 +0200 commented question Create an updatable link from within Writer to a Calc Chart?

Mr. Kaganski is correct in all but one detail, although it may be unimportant. Writer, not Impress, is the module I want

2018-12-03 17:31:19 +0200 edited question Create an updatable link from within Writer to a Calc Chart?

Create an updatable link from withing Writer to a Calc Chart? Because my original question seems to have been unclear to

2018-12-03 17:30:32 +0200 edited question Create an updatable link from within Writer to a Calc Chart?

Create an updatable link from withing Writer to a Calc Chart? Because my original question seems to have been unclear to

2018-12-03 17:30:32 +0200 received badge  Editor (source)
2018-12-03 16:08:17 +0200 edited question Create an updatable link from within Writer to a Calc Chart?

Is it possible in calc to name a chart, not a chart's data range, as a named range? That is, is it possible to name a c

2018-12-03 16:05:12 +0200 commented question Create an updatable link from within Writer to a Calc Chart?

Mr. Kaganski is correct in all but one detail, although it may be unimportant. Writer, not Impress, is the module I want

2018-12-03 15:31:02 +0200 commented question Create an updatable link from within Writer to a Calc Chart?

Lupp is right. First time users such as I was ought to be more careful to differentiate between the question title area

2018-11-22 14:48:32 +0200 received badge  Notable Question (source)
2018-11-22 11:36:27 +0200 received badge  Popular Question (source)
2018-11-22 05:49:21 +0200 asked a question Create an updatable link from within Writer to a Calc Chart?

Is it possible in calc to name a chart, not a chart's data range, as a named range? That is, is it possible to name a c