Re: [libreoffice-users] Basic Calc Question

2015-04-14 Thread Piet van Oostrum
. If not you have to change the E$2 accordingly. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

2015-04-23 Thread Piet van Oostrum
the empty cells? -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color

2015-04-20 Thread Piet van Oostrum
with one row more, and then deleting the last row. If you would have striped columns, I guess the same will happen in the other direction, but I haven't tried. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users

Re: [libreoffice-users] RESIZING BULLETS IN WRITER

2015-04-21 Thread Piet van Oostrum
and Numbering style is for numbers, but they basically belong together. And then, of course, to make the confusion even worse, in the Format menu they are called Bullets and Numbering. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4

Re: [libreoffice-users] Libre Calc - moving text in cell + comparison chart

2015-04-26 Thread Piet van Oostrum
Word you can acclimate easier. Thanks so much! Charles. On my Mac it works with Cmd-Enter. Which is kind of strange as Cmd-Enter inserts a page break in Writer, whereas in Writer both Ctrl-Enter and Shift-Enter insert a newline, even in table cells. -- Piet van Oostrum p

[libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

2015-04-24 Thread Piet van Oostrum
that the exporter misses for some reason. I also tried this with a small file and there it did optimize it. I guess if you do this for all the sheets the file may become much smaller. That still leaves improvement possibilities in the exporter. -- Piet van Oostrum p...@vanoostrum.org WWW: http

Re: [libreoffice-users] Function names with primes

2015-04-19 Thread Piet van Oostrum
. x'' = x' + y. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-24 Thread Piet van Oostrum
. Where is the week number? How is the series represented? What do you want to do with the result? -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-24 Thread Piet van Oostrum
) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

2015-04-29 Thread Piet van Oostrum
. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

2015-05-04 Thread Piet van Oostrum
give unopkg --help The difference between sudo and running as root is that with sudo you get root privileges, but you are still running in the user's environment. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail

[libreoffice-users] Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

2015-04-28 Thread Piet van Oostrum
). Then for Database access you can use Andrew Pitonyak's AndrewBase document that you can download from http://www.pitonyak.org/database/. It has examples of accessing Forms, and it uses Basic. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4

Re: [libreoffice-users] Find Replace first character broken?

2015-05-07 Thread Piet van Oostrum
for the first character ^. was only advancing through each character after finding the the first character. Can some else confirm? Your description is not very clear. Do you happen to have 'regular expressions' selected in the Find and Replace dialog? -- Piet van Oostrum p

[libreoffice-users] Re: styles and formatting

2015-04-15 Thread Piet van Oostrum
Andreas Sager wrote: The stylist is accessible through the side bar only. Don't ask me why. On Mac OS X there still is Format - Styles and Formatting (Cmd-T). -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail

Re: [libreoffice-users] Drawing arrows in Writer.

2015-04-16 Thread Piet van Oostrum
... you can select arrow heads and tails. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Libre Office 4.2.0 as windows service on windows server 2008 R2 Server Issue

2015-04-16 Thread Piet van Oostrum
--nofirststartwizard --accept=. Single - is OpenOffice Speak. I would also add --nologo myself. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Piet van Oostrum
James Knott wrote: For example, I am posting this at 2005 04 13 12:37. There is absolutely no doubt as to when that is. Except for the time zone :) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users

Re: [libreoffice-users] include images into spreadsheets, texts or reports

2015-04-07 Thread Piet van Oostrum
) print(image.Graphic.SizePixel) # You can try to guess the size from Size100thMM or SizePixel if they are defined. image.Size = Size(1200, 400) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail

Re: [libreoffice-users] Alignment in heading-styled numbered-paragraphs text

2015-06-05 Thread Piet van Oostrum
stop' and 'Aligned at' should be big enough to accomodate the numbering. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Copying text from one document to another with different formatting

2015-06-05 Thread Piet van Oostrum
often I have it on Alt-Command-V (on a Mac). -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Adding a image to a gridcontrol row using BASIC

2015-06-06 Thread Piet van Oostrum
,1,2,1.3}) translates to Array(xGraphic,1,2,1.3) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] cannot select multiple words in impress

2015-05-22 Thread Piet van Oostrum
one word by double clicking. Dragging doesn't do anything. Just clicking (not double clicking) and dragging works for me. Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] cannot select multiple words in impress

2015-05-22 Thread Piet van Oostrum
but not in Impress. I didn't know that. You are never too old to learn. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Paragraph styles in lists

2015-08-13 Thread Piet van Oostrum
is associated with each level. steve Hi Steve, Did you read my answer to your question? I think that solves it. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] Verification problem with OSX and GB language pack

2015-08-16 Thread Piet van Oostrum
the language pack. This also applies to other LO versions and later versions of OS X. The proper way for LO to solve this (IMHO) would be to put the language packs outside the application. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4

Re: [libreoffice-users] LibreOffice 5.0 Review Rating | PCMag.com

2015-08-19 Thread Piet van Oostrum
, a little out of date :-) When I click on it, it says 5.0. But I don't agree with this: Clunky interface. Confusing menu options. Actually I find the new MS Office interface quite confusing, and the LO menu's much easier to use. Maybe I am just a bit too old-fashioned :) -- Piet van Oostrum p

Re: [libreoffice-users] Re: Verification problem with OSX and GB language pack

2015-08-16 Thread Piet van Oostrum
. It is no longer used for LibreOffice. I think they should indicate that somehow. The new one is https://bugs.documentfoundation.org/ -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Verification problem with OSX and GB language pack

2015-08-16 Thread Piet van Oostrum
/show_bug.cgi?id=93331 -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more

RE: [libreoffice-users] WordPad

2015-08-17 Thread Piet van Oostrum
. Set the time interval for whatever you want and check the box to save the document along with the recovery information. LO 5.0, at least on OS X, does not have the option 'Automatically save the document too', although it is described in the help documentation. -- Piet van Oostrum p

Re: [libreoffice-users] Re: Save UNO state?

2015-08-22 Thread Piet van Oostrum
many times — the check that in backtrace wasn't the current element is ensures only that it wouldn't fall in an infinite cycle. You can get an infinite cycle at any level, so only checking at the top level is not good enough. You will have to check at each node. -- Piet van Oostrum p

Re: [libreoffice-users] table with offset between rows

2015-07-30 Thread Piet van Oostrum
Properties Columns, select 'Adapt table width'. This causes the table width to follow the sum of the column widths instead of being fixed. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] table with offset between rows

2015-07-30 Thread Piet van Oostrum
. Select the middle row and with Table Properties Borders select only the top and bottom borders. With the same row selected: Format Paragraph Indents Spacing, select Line Spacing Fixed and enter a small size, for example 5pt. With kind regards, -- Piet van Oostrum p...@vanoostrum.org WWW

Re: [libreoffice-users] Paragraph styles in lists

2015-08-11 Thread Piet van Oostrum
for example Nested List, make it a conditional style, and couple the Numbering levels to Numbering 1, Numbering 2, or List 1, List 2, etc. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] [OT] Operating Environment Survey [Kubuntu Linux]

2015-07-23 Thread Piet van Oostrum
used to say, years later: First we had computers filling a whole cabinet, with the documentation on a card. Now we have computers on a card, with the documentation filling a cabinet. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4

Re: [libreoffice-users] Open LO files via IE Explorer

2015-07-14 Thread Piet van Oostrum
dialog gets focus and finish it. Then the opened file can be worked on. I think LO should always give focus to the recovery dialog, even if there is a file opened. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread Piet van Oostrum
Patterns. I had previously added D/M/Y and 16/07/2015 (without the quotes) was perfectly recognized as a date. To keep the formatting you must also adapt the cell formatting. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread Piet van Oostrum
they would not move with the sorting but stay where they are. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/

Re: [libreoffice-users] Corrupt file restoration

2015-09-03 Thread Piet van Oostrum
this class. > Please find attached a copy of the corrupt file. Please help me fix it. This mailing list does not allow attachments. Please put it somewhere on a web site and send a link. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4]

Re: [libreoffice-users] How to change date format in Calc?

2015-09-06 Thread Piet van Oostrum
ling which one has preference, or always give the Date acceptance pattern option preference. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http:

Re: [libreoffice-users] double brackets

2015-12-13 Thread Piet van Oostrum
quot; applies to searching for "," and replace that by "." > (of course, none of these searches uses the ") Make sure that "Entire cells" and "Regular expressions" are deselected. With that I have no problem with both searches. -- Piet van Oostrum &l

Re: [libreoffice-users] How to display text using a research function

2016-06-13 Thread Piet van Oostrum
word > 'transportation and Logistics'. > > I don't know which function to use > > Thanks in advance for your help > > Regards Something like this (in B1 and copying down): =IF(OR(ISNUMBER(SEARCH("trans";A1));ISNUMBER(SEARCH("sped";A1)));"Transp

Re: [libreoffice-users] Calc - Count a "similar sequence"

2016-06-06 Thread Piet van Oostrum
---- Now you can use in a cell, e.g. =CountEquals(A5:A10) -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/ge

Re: [libreoffice-users] a question about libreoffice writer:

2016-05-30 Thread Piet van Oostrum
e details. Maybe it has to do with the language and/or script in which the document was written? -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://

Re: [libreoffice-users] Sorting in Writer

2016-05-31 Thread Piet van Oostrum
the regular find and replace as you can't specify a paragraph mark in the replace. At least i don't know how to. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Libre Writer - Windows - Title Case

2016-05-27 Thread Piet van Oostrum
e Separate Properties. > > Under Change Case there is Toggle (just capitalizes), All caps. small > case but no Title case listed. > My LibreOffice (5.1.3.2 on Mac OS X) also has a Capitalize Every Word in that submenu. -- Piet van Oostrum <p...@vanoostrum.org>

Re: [libreoffice-users] undo functionality

2016-06-01 Thread Piet van Oostrum
gt; Expert Configuration > org.openoffice.Office.Common > Undo The default is 100 steps which should be enough for normal use. But you can increase it if you want. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To u

[libreoffice-users] Re: Thank goodness for opening legacy formats

2016-06-01 Thread Piet van Oostrum
ation.org/libreoffice/old/ > > So you are covered either way :-) Until your current O.S. no longer supports these old releases, or your current hardware no longer supports the relevant O.S. releases, or the relevant older hardware is no longer available :) -- Piet van Oostrum

Re: [libreoffice-users] Sorting in Writer

2016-06-01 Thread Piet van Oostrum
Piet van Oostrum wrote: > As far as I know, steps 4 and 6 cannot be done with the regular find and > replace as you can't specify a paragraph mark in the replace. At least i > don't know how to. Well, in the meantime I found that \n in the Replace field with the regular Find an

Re: [libreoffice-users] Problem with Document- Bad Behavior

2016-02-05 Thread Piet van Oostrum
(It was uploaded as PDF) as .docx . > > Tested on: > - LibreOffice 5.0.3.2 (Fresh) on Linux Ubuntu > - LibreOffice 4.4.7.2 (Still) on Windows 7 64-bit > > Thanks for your Help. No problem with LO 5.1.0.3 (RC3) on Mac OS X 10.10.5 -- Piet van Oostrum <p...@vanoostrum

Re: [libreoffice-users] Uninstalling incompatible extension

2016-02-04 Thread Piet van Oostrum
ic runtime errors), but when I don't use it, it doesn't do any harm for me. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

Re: [libreoffice-users] UNSUBSCRIBE

2016-02-10 Thread Piet van Oostrum
Steve Gifford wrote: > PLEASE UNSUBSCRIBE ME > See the bottom of each message: To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ -- Piet van Oostrum <p...@vanoostrum.org&g

Re: [libreoffice-users] badly formed open document format file

2016-01-31 Thread Piet van Oostrum
Piet van Oostrum wrote: > My Scrivener (2.7 on Mac OS X) does export the with > s inside it, but it also puts its own bullet before > each paragraph so that they now have 2 bullets each in the ODT > file! It appears that the Scrivener 2.7 situation is different than I though

Re: [libreoffice-users] badly formed open document format file

2016-01-30 Thread Piet van Oostrum
adly made. The bulleted paragraphs are in the file as a , but they are not inside a element as required. My Scrivener (2.7 on Mac OS X) does export the with s inside it, but it also puts its own bullet before each paragraph so that they now have 2 bullets each in the ODT file! -- Piet van Oostrum <p...@v

Re: [libreoffice-users] minimum window size

2016-02-25 Thread Piet van Oostrum
eb page from a > browser. Is there a way to change the preferences so I can make the > window smaller? It was not a problem with the previous version of > LO. I don't know about 5.0.5.2, but on 5.1 on Mac OS X 10.10.5 I can make it as small as I want (actually up to the title bar+0.3mm). --

Re: [libreoffice-users] footnotes numbering problem

2016-01-21 Thread Piet van Oostrum
opy of your file, not on the original (or have a copy saved). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-l

[libreoffice-users] Verifying LO 5.1 on Mac OS X takes a long time

2016-02-18 Thread Piet van Oostrum
it warrants a bug report if more people experience this. I also tried LO 5.0.5, and its verification took about 5 minutes (still quite long I think), with kernel_task going up to about 4GB. But at least the system continued to work normally. So what can be the problem with LO 5.1? -- Piet van Oostrum &l

Re: [libreoffice-users] Calc: background color in cells invisible

2016-02-20 Thread Piet van Oostrum
1124mars wrote: > Hi, > In Calc the background color feature of cells is not working. > Who can give me any advice in which LO version the background formating is > working properly. > LO V5.0.4.2 on Win7. > Thanks for any ideas, > mars LO 5.1 on Mac OX S 10.10.5 jus

Re: [libreoffice-users] LO 5.1 Presentation can't find system browser on OSX 10.11

2016-03-10 Thread Piet van Oostrum
s, for example with a link like "htp://www", i.e. a wrong protocol identifier. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? htt

Re: [libreoffice-users] anyone knows how to find/replace not-printable glyphs?

2016-03-15 Thread Piet van Oostrum
parators, but as you correctly observe, they are additional blank paragraphs. The proper way to get spacing between paragraphs is to set additional space after the paragraph with Format > Paragraph. To get rid of the blank paragraph, use Edit > Find and Replace, Click Other options, and ch

Re: [libreoffice-users] Save/Store files

2016-03-19 Thread Piet van Oostrum
Regards > H. Stoellinger > Salzburg I remember that there had been a discussion in the recent past to always enable File > Save regardless of the document change status. Some people had been complaining about the function being disabled on a non-modified file. I can't find this in the re

Re: [libreoffice-users] 'Sheet' menu for DEB version of LO 5.1 Calc

2016-03-12 Thread Piet van Oostrum
en fiddling with your menus in the past, the Sheet menu may not appear. The solution then is to reset the menus to the default. In a Writer document: Tools > Customize... > Menus > Reset. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DA

Re: [libreoffice-users] calc application

2016-03-12 Thread Piet van Oostrum
. It is only for developers communication about the development. Bugs can be communicated in the bug tracker, see https://wiki.documentfoundation.org/QA/BugReport -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-m

Re: [libreoffice-users] Re: about libreoffice and tables:

2016-04-08 Thread Piet van Oostrum
breoffice versions > which i tested. > Which means you should switch to version 5. LO 5 is much better, especially in the area of compatibility with MS office documents. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubsc

Re: [libreoffice-users] Flat XML ODF Spreadsheet (fods) and human-readable diff of content changes

2016-03-07 Thread Piet van Oostrum
ht help (but no guarantee): (1) Load the .fods and save it again before putting it in the version control system. I.e. start from the .fods file and not from the .xlsx file. (2) Give your columns (and cells) named custom styles. I.e. define your own cell styles and apply them to your spreadshe

Re: [libreoffice-users] LibreOffice 5.1.1.3 Writer new bug?

2016-03-04 Thread Piet van Oostrum
with the third fake arrow ("->") you will get: >conoscenza dei processi -> semplificazione -> semplificazione -> > semplificazione -> riduzione dei costi; >with all four arrows correctly auto-corrected with the right arrow > character (but with

Re: [libreoffice-users] Programming guide for LibreOffice 4.1

2016-03-06 Thread Piet van Oostrum
John Meyer wrote: > I'm trying to write a macro for LibreOffice 4.1. Which programming > guide should I use? > OpenOffice.org Macros Explained (OOME) by Andrew Pitonyak. OpenOffice.org is not the same as LibreOffice, but for most uses they are close enough. -- Piet van O

Re: [libreoffice-users] Select/copy content of a comment

2016-04-01 Thread Piet van Oostrum
nto the browser.) The page on inserting and editing comments doesn't > seem to address this function. > Cmd-A Cmd-C on a Mac Ctrl-A Ctrl-C on eWindows/Linux -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscrib

Re: [libreoffice-users] Math Symbols get corrupted

2016-04-01 Thread Piet van Oostrum
Formula with Tools > Symbols. (or Catalog, depending on the LO version). Choose symbol set Special, and click Edit. You should get the same table. See if it is there, and then Cancel. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4]

Re: [libreoffice-users] Awkward behaviour of LO Calc

2016-03-29 Thread Piet van Oostrum
> > Ouch! Quite contrary to expectation. Here lie monsters :-) The ODF specification explicitly says that the unary - has higher precedence than ^, which is compatible with Excel. So it is not a bug. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/

Re: [libreoffice-users] very slow loading of a ods file

2016-04-30 Thread Piet van Oostrum
ted deleting columns, doing the same test > (save/test). No change all the way to the date column alone-no change. > Could you post a copy of that last file with only the date column somewhere so that others can test it? -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pie

[libreoffice-users] Re: justification issues

2016-04-30 Thread Piet van Oostrum
uch an ugly line does not justify the line. But the best thing in my opinion (besides the TeX algorithm) would be if you could just switch off letter spacing completely. I hate it and I haven't found an option to disable it. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoo

RE: [libreoffice-users] Re: The Save Tool could not be dimmed

2016-05-18 Thread Piet van Oostrum
rk if the document is not modified and a red star if it is modified (this may depend on your theme). You can even save the document by double clicking on that icon, and it won't do that if the document is not modified. Much easier than checking the menu. -- Piet van Oostrum <p...@van

RE: Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed

2016-05-20 Thread Piet van Oostrum
ion that the icons in the status bar are theme-independent. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Piet van Oostrum
. > -- The mailing list doesn't accept attachments. You could use Nabble for that (http://www.libreoffice.org/get-help/nabble/) The simplest explanation would be that your "numbers" are entered as text. Check your cell format. -- Piet van Oostrum <p...@vanoostrum.o

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Piet van Oostrum
first number is in cell B2. Then copy this down for all numbers in the original column. Now you have a copy of your numbers, and they are really formatted as numbers. Now Copy this column with Edit > Copy and do a Edit > Paste Special over the original "text numbers", select

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

2016-05-05 Thread Piet van Oostrum
nk we were talking about. It is normal text, that has been formatted with Format > Character > Font Effects > Hidden. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr..

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

2016-05-05 Thread Piet van Oostrum
Luuk wrote: > > Are you saying that there are still 'hidden formated text' things in the > textfile that is created when one does do 'File/SaveAs/.txt' ?? > Save as .txt des save all text, including hidden text. Just try it out. -- Piet van Oostrum <p...@vanoostrum

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

2016-05-05 Thread Piet van Oostrum
ything. You would have to look up the style definition of "P2" and see if it has a text:display="none" in it. And there can be more than one of these styles, depending on the other character attributes, like font, size or color. -- Piet van Oostrum <p...@vanoost

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt

2016-05-04 Thread Piet van Oostrum
Walther Koehler wrote: > Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum: > > Walther Koehler wrote: > > > Thank you. > > > Your procedure is principally what I need. > > > However, quite complicated for routine work. > > > > > &

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

2016-05-04 Thread Piet van Oostrum
nd Find extension, however, did work. There you choose [:::CharColor=8388736::] as search criterium (colors are given in decimal). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.li

[libreoffice-users] Re: Numbers and Pages files

2016-08-10 Thread Piet van Oostrum
> Only older versions of these can be imported. Apple seems to keep the document structure of newer versions secret. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffic

Re: [libreoffice-users] Problem Installing Dictionaries

2016-08-10 Thread Piet van Oostrum
ies so that the > spell-check and thesaurus options start working? I have seen that happen also on Mac OS X. When opening a .oxt file, LO hangs. Better go to Tools > Extension Manager > Add. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [

Re: [libreoffice-users] How to NOT turn (c) into a symbol

2016-06-27 Thread Piet van Oostrum
rrect options and there you delete that specific replacement. BUT: you have to do it for the language that your text is in. Apparently your text is not English (USA), because that has the (C) [Capital C] replaced by ©, not the lowercase (c). So check the language setting of your document (or tha

Re: [libreoffice-users] Data Range in Calc

2016-07-08 Thread Piet van Oostrum
ifferent menus depending on what's been clicked (background, grid, > point, trend line), but they /all/ finish with chart type, data ranges, > copy, paste. > If you double-click on the chart, then there is Format > Data Ranges in the normal menu (and a lot more). -- Piet

[libreoffice-users] Re: about libreoffice fonts and persian and arabic diacritics.

2016-07-05 Thread Piet van Oostrum
CVAlkan wrote: > I know for a fact that there are others on this list who are familiar with > and have accomplished what he is trying to do, so if we can get him squared he -> she, him -> her -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key:

Re: [libreoffice-users] Re: How to NOT turn (c) into a symbol

2016-07-06 Thread Piet van Oostrum
m ".*(c)", but that is > NOT what I am typing. .*(c) looks like a regular expression. I don't know exactly what the interpretation of it is when doing autocorrection but I would suspect that these should also be deleted. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://

Re: [libreoffice-users] python macros article

2016-08-08 Thread Piet van Oostrum
such an article? > > Thanks, Jim https://conference.libreoffice.org/assets/Conference/Aarhus/Slides/MatthewFrancisPyUNO.pdf http://nabble.documentfoundation.org/PyUNO-usability-improvements-td4151556.html -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/

[libreoffice-users] Re: How to NOT turn (c) into a symbol

2016-06-29 Thread Piet van Oostrum
uding the example you point to above). Option + command + x -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Creating a thick line in Libre Draw and Writer

2016-07-02 Thread Piet van Oostrum
xcept when I click OK there > is no line in the Libre Draw document. You first have to draw a line, in the same way as I described above by clicking on the line icon in the drawing toolbar. Then drag a line across the page. > > Thanks so much for your help. > > Charle

Re: [libreoffice-users] Creating a thick line in Libre Draw and Writer

2016-07-03 Thread Piet van Oostrum
es and you have an handy reference to look things up. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Creating a thick line in Libre Draw and Writer

2016-07-03 Thread Piet van Oostrum
Kruno wrote: > > 03.07.2016 u 00:36, Piet van Oostrum je napisao/la: > > The line actually is the bottom border of a paragraph. So you can change > > the thickness by positioning the cursor just above the line and then > > Format > Paragraph > Borders > W

Re: [libreoffice-users] Creating a thick line in Libre Draw and Writer

2016-07-03 Thread Piet van Oostrum
don’t see how you can make that line thicker? > > Use styles and there find paragraph style 'Horizontal line'. Right click > it and choose 'Modify'. > I had not noticed that there is a special paragraph style for Horizontal Line. Never too old to learn. -- Piet van Oostrum <

Re: [libreoffice-users] Creating a thick line in Libre Draw and Writer

2016-07-03 Thread Piet van Oostrum
Piet van Oostrum wrote: > Kruno wrote: > > > I find inserting horizontal line quite odd and I avoid it... > > > > So you write a paragraph and then go Insert → Horizontal rule and your > > paragraph font size shrinks to 6 pt. Why? > > > Ma

Re: [libreoffice-users] Creating a thick line in Libre Draw and Writer

2016-07-03 Thread Piet van Oostrum
t intended for > changing content's formatting? I would also have expected Insert Horizontal Line to start a new paragraph. Instead it changes the current paragraph to paragraph style Horizontal Line. Not nice. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoos

[libreoffice-users] Re: XML document

2016-08-17 Thread Piet van Oostrum
ontains 2 pages. (483 words) > > Both documents are substantially identical. > > Alex That was MY ODT file, which apparently reached the original folder :) -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4]

[libreoffice-users] Re: XML document

2016-08-17 Thread Piet van Oostrum
test for it in the build process. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ P

Re: [libreoffice-users] Tom Morton shared "Dissertation" with you

2016-08-17 Thread Piet van Oostrum
hidden or invisible text. So if this xml file is all you have, I am afraid the rest is lost. I saved it as ODT in the folder but I don't know if that will reach you also or if it is just a local copy for myself. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.c

Re: [libreoffice-users] Default font in LO calc

2017-02-20 Thread Piet van Oostrum
> still comes up!! > > I don't want or need a Template I just want the Font and size that I > selected to be the Default for all new Spreadsheets!! > If you want to change the default font, and setting the default template is the way to do it, why would you not want that? --

Re: [libreoffice-users] Default font in LO calc

2017-02-20 Thread Piet van Oostrum
sary. Just File > New > Spreadsheet will create a new spreadsheet based upon the template. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http:

Re: [libreoffice-users] Default font in LO calc

2017-02-20 Thread Piet van Oostrum
(e.g. Default), select category "My Templates", check "Set as default template" > Save In other versions you might have to do File > Templates < Manage Templates, Filter Spreadsheets, to set the template as default. -- Piet van Oostrum <p...@vanoostrum.org> WW

  1   2   >