Ask Your Question
0

Issues with Text overlapping and Images in Headers

asked 2020-05-09 15:29:43 +0200

Ahsan gravatar image

updated 2020-05-11 07:37:18 +0200

The below image is from MS Office. I want to achieve the same result for official documents. the heading in the center and the logo on the left side are part of Headers. This is very easily doable in Excel but seems impossible in Libre Office

C:\fakepath\Untitled.png

I was using LIbre Office as a side product beside MS Office. Recently I decided to uninstall MS Office and shift to LO completely. The immediate thing I started having trouble is with Calc. Some of very important sheets created in MS Excel are not displaying correctly and text seems overlapping in print preview. Also in headers I am unable to add images, which just a matter of clicks in MS Office. This is proving to be a disaster as images in headers are a prime requirement. I am sure your team would be able to solve this issue immediately. Thanks.

edit retag flag offensive close merge delete

Comments

1

The image shows a letter. This is the job of Writer rather than Calc. In Writer, you'll find all tools and features you need for a letter, even with logos, images and tables.

If your tables are complex spreadsheets, make them in Calc and insert them in the Writer document. You'll benefit the best of both applications.

ajlittoz gravatar imageajlittoz ( 2020-05-11 08:10:48 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2020-05-11 13:19:59 +0200

ajlittoz gravatar image

Since my comment seems to get some attention, I make it in aa answer so that it can be more easily upvoted.

The image shows a letter. A letter is an elaborate piece of writing where important elements follow each other in logical argumentation trying to demonstrate some quality of convince the reader about the relevancy of the message. This is the job of Writer rather than Calc.

In Writer, you'll find all tools and features you need for a letter, even with logos, images and tables. Writer manages paragraphs with a flexible layout not hindered by the rigid structure of cells. Conflict between adjacent objects are elegantly resolved with their wrap property.

In Calc, unless you struggle with cell properties which are usually irrelevant if the cells contain only numbers, any cell text overflow will extend at right of cell boundary (in left-to-right writing). But if cell at right contains data, it will overwrite the overflow, taking precedence on it. This may be what you call overlapping text.

Composing a letter with Writer does not prevent you from presenting facts or data in tabular form. Writer tables are primarily intended for text. They have a limited spreadsheet capability but you can anyway insert a Calc spreadsheet (with full Calc capabilities, even the most complex) in your Writer document.

Using the adequate component for your various "objects", you'll benefit the best of both applications.

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

In case you need clarification, edit your question (not an answer) or comment the relevant answer.

edit flag offensive delete link more
0

answered 2020-05-09 17:42:51 +0200

ebot gravatar image

updated 2020-05-09 17:45:55 +0200

In LibreOffice Calc, images cannot be inserted in the header and footer area.

image description

Describe what you want to achieve or upload a sample file here.

To upload, edit your initial question.

Do not post an answer if it is not a solution to your question. Thank you.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-09 15:29:43 +0200

Seen: 145 times

Last updated: May 11