Stel uw vraag

Rugslug's profiel - activiteit

2017-12-27 02:19:49 +0200 badge ontvangen  Mooi Antwoord (bron)
2017-05-22 21:57:01 +0200 badge ontvangen  Mooi Antwoord (bron)
2017-05-14 12:01:07 +0200 koos een beste antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait
Windows 7 LO 4.4.3.1
Windows 8.1 LO 4.3.5.2 both are English Locale EN_CA

My 26 page document is set to have the page orientation as follows:

Page 1 to 4 are Portrait: Default Page Style
Inserted Landscape Page Style: Page 5 is Landscape
Recalled Default Page Style: Page 6 to 26 are Portrait

When Exported To PDF the document appears as formatted as per the above. And as shown in image 1.

Exported to PDF

When it is printed to a printer or printed to PDF Creator, Pages 1 to 4 are Portrait, Page 5 to 26 are Landscape, but only half the page is shown as if it is a portrait page printed on landscaped paper.

Printed to PDF

It one case when printed to PDF Creator, all pages are landscape.

When I am in the print dialog, the preview shows Pages 1 to 4 portrait, Page 5-26 in landscape.

Has anyone had a similar situation occur? Can this be repeated? Have I set up the file correctly?

2017-05-14 12:00:58 +0200 beantwoorde een vraag Printing a Landscape Portrait writer document that doesn't switch back to portrait

A solution was discovered in another thread. Either @floris-v or @owenp or someone else? figured out that if the sheet w

2016-12-11 16:51:24 +0200 reageerde op een vraag My master document won't switch back to portrait after a landscape page when printing to pdf

I found Bug 92190 A fix that worked for me was to change the page size to 8.49 x 11.48 (a wee bit smaller) and I do not have the problem in my test documents.

2016-12-11 16:47:34 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

I found this bug report bug 92190.

I made the adjustments mentioned in comment 14, workaround 2. And it worked. Suggestion is to adjust the page size smaller by .01 inches. Instead of 8.50 x 11.00 I have 8.49 x 11.48. I wonder if @floris v and @ROSt52, you use A4 paper and it doesn't affect it?

2016-12-03 23:12:49 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

The latest test was on a separate computer outside of my house with the default printer settings. I still believe it is some kind of persistent bug since 4.2.8 as I have no problems on that version.

2016-12-03 23:12:31 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

The latest test was on a separate computer outside of my house with the default printer settings. I still believe it is a persistent bug since 4.2.8 as I have no problems on that version.

2016-12-01 15:43:07 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

I created a new file on a separate computer with Portable Apps v5.2.3.3. PPPLPLP. It results in the same issue. The preview in the print dialog switches everything to landscape; a print to a PDF file has all pages after the first 3 in landscape; Exporting to PDF results in the correct layout.

2016-12-01 15:17:31 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

My file is a single file.

2016-12-01 10:50:40 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

It is saved in odt format.

2016-12-01 10:12:19 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

Yes. 5233 and 5300beta1 on Windows 10.

2016-12-01 00:43:42 +0200 reageerde op een vraag My master document won't switch back to portrait after a landscape page when printing to pdf

Can you use Portable Apps and use v4.2.8 to print your document? Might be worth a try. This was the last version I found where it worked correctly.

2016-12-01 00:39:46 +0200 reageerde op een antwoord My master document won't switch back to portrait after a landscape page when printing to pdf

I still have the issue. Once my file goes from portrait to landscape, the remaining pages stay in landscape. In the Print dialog, as I scroll through the pages, again, once it switches to a landscape page, all pages are displayed in landscape -- even the initial pages that were in portrait. If I Export to PDF, it works great, but when printed to paper or PDF Creator, the bug persists.

2016-12-01 00:22:45 +0200 reageerde op een antwoord Printing a Landscape Portrait writer document that doesn't switch back to portrait

I still have the issue. Once my file goes from portrait to landscape, the remaining pages stay in landscape. In the Print dialog, as I scroll through the pages, again, once it switches to a landscape page, all pages are displayed in landscape -- even the initial pages that were in portrait. If I Export to PDF, it works great, but when printed to paper or PDF Creator, the bug persists.

2016-09-10 00:13:59 +0200 reageerde op een antwoord Better name handling in template manager

I was going from the Start Centre, Templates Button.I like to pick my templates from that display in the start centre rather than the "Manage Templates". And when in the start centre, File, Templates does not exist (conveniently removed by default?). It is present with an open/blank document. To be clear, definitely organize the templates into folders. I was adding the extra information as a caveat. It will depend on how the user access their templates.

2016-09-09 23:18:24 +0200 beantwoorde een vraag Better name handling in template manager

I just noticed this as I was working on the comment above.

This is in version 5.2.2.1. Under File, Properties, Description Tab, Edit the Title field in your .ott template file and this field is displayed when clicking on the Template Menu from LibreOffice Start Centre. A tool tip pops up showing the entire field which is helpful if the name is long.

A new feature in 5.2 I see in comparing to 5.1, one can right click on the template (in the start centre) and either Open or Edit the template.

In 5.1.4, the tool tips are not popping up and the description is truncated.

However, in 5.2 the Templates are not broken down into the different categories/folders. Maybe that's just my machine.

2016-09-09 23:07:36 +0200 reageerde op een antwoord Better name handling in template manager

Excellent idea, however: Arranging Templates in folders worked in 5.1 however, that was changed (bug or intentional?) in 5.2. Now all the templates are displayed as if "All Categories" is a default view. Or is there a setting somewhere to display in Categories (and I am referring to the Templates not the managing of templates).

2016-04-02 04:40:18 +0200 beantwoorde een vraag Changing title and author for PDF creation

Try changing or resetting the properties in the Libreoffice .odt file before exporting to PDF. This will set your name from your settings. To set your name as the author, set the user data under Tools, Options, with your name. Then back under File, Properties, Reset User Data and your name should appear as the author. Still in Properties, switch to the Description Tab to set the Title, Subject and Key words as these too will appear in the PDF file.

2016-03-31 01:42:15 +0200 beantwoorde een vraag [FEATURE REQUEST] Enable Text Highlighting in Text Box for LibreOffice Writer

In LO 5.1.2.1, it is available, perhaps not on the toolbar.

Create a text box, place some text in the text box, right click on the menu (while the text is editable in the text box), customize toolbar, toolbar name at the top of the dialog should be Text Object, scroll down the list to "Font Color" (might not be there), click Add, Category: Format, Command: Highlight Color (the 2nd choice -- I have two Highlight Color, one worked for the textbox), Click Add, Close, Okay.

Highlight color should also show up on the Sidebar with the Character Formats.

2016-03-29 21:36:46 +0200 reageerde op een antwoord How to convert column in $ to other column in euro?

Thanks for this info. That's a unique way around the European currency system to Euros. When I buy USD from CAD, 3 years ago was equal, today's it costs 1.30 to buy a USD. And 1.47 for a Euro. So the monetary units in the EuroConvert are not trade value dependent.

2016-03-29 21:18:40 +0200 beantwoorde een vraag How to convert column in $ to other column in euro?
2016-03-25 11:57:18 +0200 reageerde op een vraag Calc - The accuracy of the calculation?

Bug 98844 was created. Bug 98844

2016-03-24 21:06:13 +0200 beantwoorde een vraag Calc - The accuracy of the calculation?

I agree with @Grey_md 's statement.

11.8913
11.7535
11.8765
4.0325
8.0689
-------
47.6227

I set Precision As Shown = True. No matter what # of decimals I show, the sum still = 47.6227. What should happen, is that as I decrease the # of decimals shown for the summed numbers, the sum should become 47.6240 then 47.6200 then 47.7000. But it does not change. I tried this on Win7 with the same incorrect result.

I went backwards through Portable Apps versions and it appears to last work at 4.1.6. When I re-open it in 5.1.2.1, it stops working and displays 47.6227

Win 10 / Win 7
5.1.2.1
5.0.4 Portable Apps -- no
4.4.7 Portable Apps -- no
4.3.7 Portable Apps -- no
4.2.8 Portable Apps -- no
4.1.6 Portable Apps -- it works
4.0.6 Portable Apps -- it works
3.6.5 Portable Apps -- it works
2016-03-20 18:36:09 +0200 reageerde op een antwoord Libre Office gui has wrong font. Bug?

I see your problem. I should have clued in with the GUI part. Impact is not a fun font.

2016-03-20 14:45:12 +0200 beantwoorde een vraag Libre Office gui has wrong font. Bug?

LO 5.1.2 (and Windows)(Mac should be the same):

Tools Options +LibreOffice Writer Basic Fonts Set all Fonts to the same and your preferred choice.Okay out. Exit LO and restart.

F11 (Styles and Formatting) Check that Default Style Heading etc are the new font. If they are the Font you chose in the options, then you are good.

If they are still the same, perhaps a default template is setting them. See Reset to Default Template. Or you can edit your default template.

2016-03-20 13:33:54 +0200 beantwoorde een vraag Table of Contents Format messy!

I found two ways to do it. The first one is probably better.

Right click on the ToC, Edit Index ToC, Entries Tab, add in a space between the chapter# code and Entry code. This will need to be done for each level. Click on All to apply the current setting to All Levels (so long as the other levels are not individually configured). Watch the preview to see the way it changes.

image description

Under Tools, Outline Numbering, set the Separator, After, with a space. This will also affect the heading in the document (this is why I prefer the first method). Set it for each level required.

image description

2016-03-20 13:09:32 +0200 beantwoorde een vraag Adjusting toolbars, good idea or not?

Create a customized tool bar and store it in the file.

Right click on the tool bars, Customize.

In the Customize dialog, "New".

Add the buttons/commands.

Save in. Specify the filename of the document to only have it saved in that file. Choose LibreOffice Calc to have it globally available.

Not sure how to hide your regular menus. Possibly create a macro that runs when the spreadsheet is opened? That is under the Events tab.

image description

2016-03-20 12:42:22 +0200 beantwoorde een vraag How do I get rid of this grey box around my text?

In LO 5.1.2, one possibility that may have occurred:

Insert / Section

If you click on the text in the boxed area, the status bar at the bottom of LO will indicate the section #. Or could have a name if it was renamed during the set up.

See the picture. Double click on the Section name to bring up the Section Dialog. There is a remove button. In my test, only the section was removed, not the text. As a precaution, make sure you save the file before removing the section.

image description

2016-03-20 12:24:29 +0200 beantwoorde een vraag How do I truly delete rows and columns, like in Google Sheets?

IMO, the functionality of a cloud based spreadsheet is different than a spreadsheet program that runs on a computer. With Google Spreadsheets, the rows are deleted and appear to be (and probably are) removed from the spreadsheet. I would guess this means less data needs to be transferred from the server to your browser. Perhaps even blank rows/columns have some information, or perhaps ARE the information to be transmitted.

With LO on your computer, the file size isn't affected with one million empty rows.

In Excel online in an empty spreadsheet, as I page down there is a “WORKING” displayed in the bottom left of the window. So it must be transferring data even with empty rows.

As for LO, I concur with the other two answers, right clicking on the header for the row/column, delete row/column, deletes everything in the row/column including the formatting and the contents.

2016-03-17 00:52:27 +0200 reageerde op een vraag Assigning "paste unformatted text" prevents pasting pictures

Would CTRL-SHIFT-V do the same thing in Ubuntu? In Windows, that brings up the Paste Special Dialog and will give you different paste choices depending on what's in the clipboard. Then you can keep CTRL-V as the default paste function.

2016-03-16 01:31:12 +0200 beantwoorde een vraag The text of my Libre Office Document flashes on and off the screen continually. Why is that and how can I fix it?

Select the flashing text, Format, Character, Font Effects Tab, Uncheck Blinking. This would only fix the selection and not necessarily other styles.

So it may be part of the Font Style.

Press F11 for Styles and Formatting, Click in the general area of the flashing text. The side bar, usually on the right, will highlight the text style (possibly Default), right click on it, select Modify, Format, Character, Font Effects Tab, Uncheck Blinking.

The second choice would be more likely if all your text styles (headings, etc) are flashing. Setting the Default propagates to all dependent styles setting all of them to non blinking text.

2016-03-15 00:54:06 +0200 reageerde op een antwoord Hide Whitespace

@LibreTraining have you tried my suggestion above? Curious to know if it works for more than the two of us. Thanks.

2016-03-13 15:25:06 +0200 beantwoorde een vraag Hide Whitespace

In the bottom right hand corner there are three page views: single, multi, book view.

If multi view or book view is selected, hide whitespace is grayed out.

click the single-page view and the hide whitespace should work.

Works for me LO 5.1.1.3 and W10

image description

2016-03-08 00:30:37 +0200 reageerde op een antwoord Can I open Writer to the last page?

This issue was corrected somewhere around v4.4.2 and continues to work in 5.1

2016-03-08 00:29:37 +0200 reageerde op een vraag How do I get the newer version of Writer to open on the last page I worked on.

This issue was corrected in v4.4.2 and continues to work in 5.1

2016-03-08 00:17:11 +0200 reageerde op een antwoord Creating a date column with 2 weeks added to each previous date cell

Incidentally: in v 5.1 "Fill Cells" moved from the Edit Menu (in v 5.0) to the Sheet Menu.

2016-03-08 00:13:36 +0200 beantwoorde een vraag Creating a date column with 2 weeks added to each previous date cell

Two more ways:

Have your first two dates in the first two cells. Select them both. Then left click on the little black square in the bottom right of the bottom cell. Drag it down as necessary. It will increment based on the difference between the two cells.

Cell A1 is your date. in cell A2, use the formula:

=A1+14

Then copy/drag it down as required.

2016-02-21 21:21:02 +0200 badge ontvangen  Goeroe (bron)
2016-02-21 16:05:06 +0200 koos een beste antwoord Mean Value Line Not Shown on Line Graph

I've inserted a Trend Line and a Mean Value Line on an X-Y Scatter graph without a problem. When I create/switch the chart to a Line graph, the Mean Value Line is not shown, although it shows up in the legend and it can be formatted as if it were there.

Is this an anomoly? Is it me? Can anyone duplicate this discrepancy (to confirm or rule out me)?

X-Y Scatter Graph

Line Graph

Windows 7 / LibreOffice 4.3.5.1 and 4.2.6 Portable

2015-11-17 23:16:47 +0200 beantwoorde een vraag How to Create Portable App for LibreOffice.

This is expanding on what JKEngineer suggested. This is to run a LO portable app without using the PortableApp program in Windows:

Create a batch file in the root directory of your USB Drive. Say, LO Writer.bat

Paste the following code into the LO Writer.bat file.

@echo off
cd\
cd\PortableApps\LibreOfficePortable
LibreOfficeWriterPortable.exe

Edit the paths to be the same as you have it installed on your USB Drive. I _think_ mine uses the default installation files.

Save and exit. Double click the LO Writer.bat file and it should run LO Writer. Create other files for Calc, Base, Impress based on the .exe filename.

This will run LO Portable regardless of the drive letter assigned to the USB Drive. Or even C-Drive if that is where it is installed.

2015-11-04 23:05:33 +0200 beantwoorde een vraag [calc] How do I get the current sheet number?

I used

=SHEET()

and it worked for me.

I used

=SHEET(Sheet2.A1)  (Or whatever sheet name you've used)

and it returned the sheet number of Sheet2 cell A1.

Make sure you have an equals sign before the function. Double check that the formula is calculating correctly. Try

=1+1

for a result of 2 of course. If it stays as =1+1 then the cell may be a text format.

Under Tools, Options, +LibreOffice Calc, View, make sure Display Formulas is unchecked. You can check Value Highlighting to show different colours for different formats. Formulas: green; Numbers: blue; Text: black.

2015-08-29 15:16:35 +0200 badge ontvangen  Beroemde vraag (bron)
2015-08-20 22:39:33 +0200 badge ontvangen  Opvallende Vraag (bron)