Re: [libreoffice-users] paragraph style

2024-03-27 Thread Jean-Francois Nifenecker
Hi, I meet this behavior from time to time. To fix the ill-behaved paragraph, I do this: 1. Ctrl+M to clean the possible manual formatting 2. Set Body Text style 3. Set the wanted style again. To-date, this has always worked here. YMMV. Best, -- Jean-Francois Nifenecker, Bordeaux Le 27/03

Re: [libreoffice-users] Wizard vs Custom spreadsheet

2024-03-01 Thread Jean-Francois Nifenecker
. Then you protect the sheet. According to the source value, the target cell is protected or not. HTH, -- Jean-Francois Nifenecker, Bordeaux Le 01/03/2024 à 12:10, Radocea Andrei a écrit : Dear all, I have the following problem to solve: In a spreadsheet in one cell, the calculation table

Re: [libreoffice-users] optimal width always

2023-07-09 Thread jean-francois
to adjust to their contents. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Question on getting a list of all the macro commands

2020-11-29 Thread Jean-Francois Nifenecker
o document is a collection of predefined macros, while his book is more elaborated. Both are highly recommended reads! For a quick start, you might also find the 9 reference sheets available from the LibO extension pages handy: https://extensions.libreoffice.org/?Tags%5B%5D=173 HTH, -- Jean-Francois

Re: [libreoffice-users] Copying data from Calc to Base...

2020-07-23 Thread jean-francois
is unique to the table) must be set as the Primary Key. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https

Re: [libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread jean-francois
rah style. You set its font DejaVu Sans 14. If you click the button, the underlying Text Body style is set accordingly, thus every paragraph with this style is immediately updated. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Strange question on Macro?? (in Spreadsheet)

2020-07-07 Thread jean-francois
" " If (l_Sec > 0) Or (pSeconds = 0) Then l_Str = l_Str & CStr(l_Sec) & " " & l_SecSym 'remove the possible trailing space If (Right(l_Str, 1) = " ") Then l_Str = Left(l_Str, Len(l_Str) - 1)

Re: [libreoffice-users] Localized Basic macros

2020-05-10 Thread jean-francois
into English could be of use. I'm using po files with a Basic adapted gettext() function I had written for that (well, it's a little more convoluted but you get the idea). https://www.gnu.org/software/gettext/ https://www.gnu.org/software/gettext/manual/gettext.html My 2 (euro)cents. Best, -- Jean

Re: [libreoffice-users] filter bank transactions and then sum

2020-01-13 Thread jean-francois
up the interest I got. check the SUMIF() function which should give the answer you're looking for. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Re: PaletteMaker v.1.0 is out

2019-09-12 Thread jean-francois
_MAX constant value to whatever you see fit. Then adjust the four named ranges accordingly: colors, definitions, names and samples. Finally, expand accordingly the colored range at sheet Palette. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@gl

Re: [libreoffice-users] Ask help about recent directories

2019-08-28 Thread jean-francois
Dave, Le 28/08/2019 à 06:25, jean-francois a écrit : do you know of LibreOffice dialogs selection option? See Tools > Options > LibreOffice > General, Open/Save dialogues, Use LibreOffice dialogues checkbox. This option replaces the OS Open/Save dialogues with LibreOffice

Re: [libreoffice-users] Ask help about recent directories

2019-08-27 Thread jean-francois
Open/Save dialogues with LibreOffice own ones. These have a Preferred Listbox on the left which should be what you're looking for. My two euro-cents, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.o

Re: [libreoffice-users] Re: PaletteMaker v.1.0 is out

2019-08-19 Thread jean-francois
implemented in the v.1.5 I've got here). For your suggestion #1, I can't find any API entry that would help creating the RGB2HSV values. I guess I've overlooked something... Can you give any pointer here? Thanks and all the best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail

Re: [libreoffice-users] Class name for certain LO Impress objects in macro

2019-07-18 Thread jean-francois
: https://berma.pagesperso-orange.fr/index2.html (2) MRI: https://extensions.libreoffice.org/extensions/mri-uno-object-inspection-tool Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help

Re: [libreoffice-users] Re: PaletteMaker v.1.0 is out

2019-07-17 Thread jean-francois
s for your kind words and ideas. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette Li

[libreoffice-users] PaletteMaker v.1.0 is out

2019-07-15 Thread jean-francois
/PaletteMaker-une-macro-qui-genere-des-palettes Of course, any remark, criticism or suggestion is welcome. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Re: Draw changes font when opening pdf text file.

2019-03-18 Thread jean-francois
that embedding fonts is required by the PDF/A format. This makes PDF/A files larger than ordinary ones. The standard PDF format doesn't require font embedding, with the drawback you mention. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] edit autocorrection options

2019-03-14 Thread jean-francois
e last operation (ie, the autocorrection). Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Net

[libreoffice-users] Extension de gestion des champs d'utilisateur Writer

2019-03-11 Thread jean-francois
en LibO Basic qui y trouveront comment insérer dynamiquement des widgets "TableGrid", actuellement non disponibles dans la barre d'outils des dialogues (un jeu de primitives est fourni). Si vous êtes intéressés pour tester cet outil (ou simplement curieux), merci de me contacter en

Re: [libreoffice-users] Icons in message box

2018-12-17 Thread Jean-Francois Nifenecker
Le 17/12/2018 à 21:09, Luuk a écrit : I do see the question mark. So do I. If I change the MB_ICONQUESTION constant for the MB_ICONSTOP, I see the Stop icon as well. Official (TDF) LibreOffice 5.4.6.2 under Linux Lint 18.x Cinnamon. HTH, -- Jean-Francois Nifenecker, Bordeaux

Re: [libreoffice-users] Auto-closing user dialogue (macro, Basic)

2018-12-15 Thread Jean-Francois Nifenecker
at that page: https://documentation.libreoffice.org/en/english-documentation/macro/ get the Dialogs RefCard (https://documentation.libreoffice.org/assets/Uploads/Documentation/en/MACROS/RefCards/LibOBasic-6-Dialogs-Flat-A4-EN-v103.pdf). The Non-Modal dialog part might give you some ideas. HTH, -- Jean

Re: [libreoffice-users] corrupt letter on display

2018-11-28 Thread Jean-Francois Nifenecker
all: https://wiki.documentfoundation.org/Documentation/Install/Linux (look at the Debian / Ubuntu / Mint section) Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscrib

Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-22 Thread Jean-Francois Nifenecker
anchoring them to cell. Do you save as PDF using the UI or through a macro? Given your first paragraph, I'd suppose you're using a macro, aren't you? If so, how do you process the export? Cheers, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Personas

2018-09-27 Thread Jean-Francois Nifenecker
/!\ this should read: /home/dave/.config/libreoffice/4/user/gallery/personas/MyPersona/MyHeader.png -> "personas" with a lower case initial and with a final S my bad /o\ Should work on your side now. Sorry for the misleading. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsub

Re: [libreoffice-users] Personas

2018-09-27 Thread Jean-Francois Nifenecker
is example would give: MyPersona/MyHeader.png;MyPersona/MyHeader.png;#00;#F5F5F5 Once validated, the new theme is propagated to new documents (the current file environment is not changed yet). To get to these grips, I read a blog article that I'm totally unable to find right now. Too bad I coul

Re: [libreoffice-users] side by side tables

2018-09-26 Thread Jean-Francois Nifenecker
Hello Gary, an alternative to Brian's suggestion: nesting tables! Say you want three side-by-side tables: -- Insert a 3 column/1 row table. -- In each cell of this table, insert a new table, fit as you need. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users

Re: [libreoffice-users] Issues with macro recorder??

2018-09-20 Thread Jean-Francois Nifenecker
ted place (for quick moves you may try using the cell name field). HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: ht

Re: [libreoffice-users] How to access ConvertToURL from automation?

2018-09-10 Thread Jean-Francois Nifenecker
function to do the task but I would like to know if it is possible to access the OpenOffice version. What is VFP? Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Basic pseudo object code no reachable when defined into a basic library...

2018-07-20 Thread Jean-Francois Nifenecker
the actual difference between both approaches. So I need to add a specific modul in pseudo object library with factories ... Don't you think that having an object factory in each class module would be easier to maintain? Or is this impractical? Best regards, -- Jean-Francois Nifenecker, Bordeaux

Re: [libreoffice-users] Basic pseudo object code no reachable when defined into a basic library...

2018-07-20 Thread jean-francois . nifenecker
Hi Patrick, typo spotted in the Initialize sub : Private Sub Class_Initialize() _valute = 1 End Sub instead of Private Sub Class_Initialize() _value = 1 End Sub Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Jean-Francois Nifenecker
fice > Advanced, Enable macro recording. Ahem. Yes, I stand corrected /o\ Anyway, Robert's solution is much faster! Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Jean-Francois Nifenecker
ot;Save". Now you could insert the current date with Ctrl+7. OMG! How did I overlook that? Many thanks Robert! All the best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/maili

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Jean-Francois Nifenecker
"Content" args1(3).Value = "0" args1(4).Name = "Format" args1(4).Value = 10036 ' args1(5).Name = "Separator" args1(5).Value = " " dispatcher.executeDispatch(document, ".uno:InsertField", "", 0, args1()) end sub ---

Re: [libreoffice-users] Re: How do I use a singleton in LibO basic?

2018-02-28 Thread Jean-Francois Nifenecker
thingy. Then when you asked about a singleton I remembered I had met one once :) From the other side of the pond, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] How do I use a singleton in LibO basic?

2018-02-28 Thread jean-francois . nifenecker
-- >8 the above example is working here in this context. HTH, -- Jean-Francois Nifenecker, Bordeaux - Mail original - De: "ptoye" <l...@ptoye.com> À: users@global.libreoffice.org Envoyé: Mercredi 28 Février 2018 12:51:50 Objet: [libreoffice-us

Re: [libreoffice-users] writer vs calc behaviour in LO 6.0.1.1

2018-02-24 Thread Jean-Francois Nifenecker
- >8 2. Set the shortcut (as shown above) to the said macro, with category: select LibreOffice Macros > MyMacros > (your macro library) > (your macro module) function: your macro name Now Ctrl + ; inserts todays date at the cursor position. HTH, -- Jean-Francois Nifenecker, Bor

Re: [libreoffice-users] Automatically generating and updating many similar documents

2018-02-14 Thread Jean-Francois Nifenecker
quot; (see "Hiding with sections", p187 sqq) http://designingwithlibreoffice.com/ HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posti

Re: [libreoffice-users] Automatically generating and updating many similar documents

2018-02-10 Thread Jean-Francois Nifenecker
ng its formatting. Note that the new section in Target.odt may be password protected. This might be of interest when manipulating legal documents for instance. From now on, any change in the source RefDoc.odt sections text will be propagated to the linked section of the target documents. HTH, -

Re: [libreoffice-users] avoiding recalculate on loading of Calc files

2018-02-10 Thread Jean-Francois Nifenecker
set and others without. Best Regards -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org

Re: [libreoffice-users] Window corruption in macro editor

2018-02-09 Thread Jean-Francois Nifenecker
editor heavily under Windows 7 and Debian Linux 8.1 without any problem (using LO 4.3.x, 5.4.x and 6.0.0. No problem so far). BTW, what is the version of LibO? Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https

Re: [libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?

2018-01-23 Thread Jean-Francois Nifenecker
d to as MyArray(i)(j), NOT as MyArray(i, j) HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfou

Re: [libreoffice-users] Macros : ByVal doesn't work with parameters in a class object modul ...

2018-01-08 Thread Jean-Francois Nifenecker
ved as Optional but never test for its presence or not in the method body. This might lead to strange results, don't you think? [BTW, BTW, shouldn't the method be called "_Expand" instead of "_Expend"?] HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to:

Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?

2017-12-26 Thread Jean-Francois Nifenecker
for their contributions. And I've seen many of the contributors happy and proud with their stickers, there is a fair collection of their feedback on the social media. Glad if people are glad! Obviously the YMMV is really variable. But I stand with my own opinion ;-) All the best, -- Jean

Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?

2017-12-24 Thread Jean-Francois Nifenecker
ed for TDF to lose time and energy in this area. YMMV Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoun

Re: [libreoffice-users] Help with VLOOKUP requested

2017-07-22 Thread Jean-Francois Nifenecker
t2.$A$2:$B$690,2,0) Note that, when entering a formula, the F4 key (newer versions of LO) or Shift+F4 combination (older versions) could help. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.or

Re: [libreoffice-users] [macros] How to create a timer ?

2017-07-21 Thread Jean-Francois Nifenecker
Maurizio, Andrew, thanks for the pointers you posted. This will help me finding out. I guess the "simplest" way would be to call a Python script from Basic. Thanks again to both of you. You've put me on the way. Greetings from the other side of the pond, -- Jean-Francois Nifenecker

[libreoffice-users] [macros] How to create a timer ?

2017-07-21 Thread Jean-Francois Nifenecker
expires (eg 2 hrs). In fact I'm in need of several timers for the same document to handle as many different delays/tasks. Can anyone point me to some direction as I'm currently in the dark? Thanks in advance. Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail

Re: [libreoffice-users] Can LO build a TOC from a PDF file?

2017-07-09 Thread Jean-Francois Nifenecker
Writer is possible but you'll have to fix a lot of things (eg. useless carriage returns) and apply heading styles by hand. On a 400+ pages document this a big PITA. Hopefully someone else will come with brighter ideas. Bien cordialement, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe

Re: [libreoffice-users] [calc] Get a list of conditional formattings

2017-07-09 Thread Jean-Francois Nifenecker
in Italy are (dunno many of them but I appreciated all the ones I visited so far). All the best, -- Jean-Francois Nifenecker, Bordeaux -- 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] [calc] Get a list of conditional formattings

2017-07-09 Thread Jean-Francois Nifenecker
his is the aim. BTW, as documenting is a key point of spreadsheets develepment, I think this conditional formatting listing could/should be made available somewhere in the UI, à-la range names insert. Thanks again, Cheers from France, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mai

Re: [libreoffice-users] [calc] Get a list of conditional formattings

2017-07-09 Thread Jean-Francois Nifenecker
about Regina's hints which seem to do what I need. All the best, -- Jean-Francois Nifenecker, Bordeaux -- 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

[libreoffice-users] [calc] Get a list of conditional formattings

2017-07-08 Thread Jean-Francois Nifenecker
overlooked smthg. TIA. Best regards, -- Jean-Francois Nifenecker, Bordeaux -- 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://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

2016-10-16 Thread Jean-Francois Nifenecker
one. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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://wiki.documentfoundation.org/Netiquette List archive: h

Re: [libreoffice-users] New LibreOffice Book

2016-03-25 Thread Jean-Francois Nifenecker
). Thanks, thanks, thanks, Keep on the very good job! Greetings from the other side of the pond, -- Jean-Francois Nifenecker, Bordeaux -- 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] linking cells between different calc books.

2016-02-14 Thread Jean-Francois Nifenecker
Hi, I'd add the following option which might help as well: o Edit > Links, Update -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guideli

Re: [libreoffice-users] CHanger le chemin des modeles

2015-01-20 Thread Jean-Francois Nifenecker
solution to your question. HTH, -- Jean-Francois Nifenecker, Bordeaux 07.52.63.25.54 -- 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://wiki.documentfoundation.org

Re: [libreoffice-users] LOBase connected to SQLite3

2014-12-16 Thread Jean-Francois Nifenecker
to configure the ODBC driver to point to the directory where your database resides. Now, start LibreOffice Base and select ODBC HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] mongodb and base

2014-11-22 Thread Jean-Francois Nifenecker
Le 22/11/2014 16:34, Rob Jasper a écrit : I used to work for Bell Labs, and they had as standard (!) perforation the US 3 + the US 4 holes, and we just added Europe's 4 holes, so in total there were 11 holes... hole-y cow! -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail

[libreoffice-users] [Base] Can we connect a macro to a report?

2014-11-14 Thread Jean-Francois Nifenecker
got a macro that does just that, translating numbers into letters. But, to date, I haven't found any mean to connect a report field to a macro. I've looked at custom functions and can't find any option anywhere. So my question is: is this possible? And, if it is, how? Thanks in advance, -- Jean

Re: [libreoffice-users] Re: [Base] Can we connect a macro to a report?

2014-11-14 Thread Jean-Francois Nifenecker
when the group column value changes. -- Jean-Francois Nifenecker, Bordeaux -- 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://wiki.documentfoundation.org

Re: [libreoffice-users] Re: LibreOffice Still?

2014-09-30 Thread Jean-Francois Nifenecker
website inception. Cheers, -- Jean-Francois Nifenecker, Bordeaux -- 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://wiki.documentfoundation.org/Netiquette List archive

Re: [libreoffice-users] rtf files

2014-09-29 Thread Jean-Francois Nifenecker
there). Let me know if we are on the same page. FYI, the older versions are available here: http://downloadarchive.documentfoundation.org/libreoffice/old/ -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Convertir csv en ods

2014-09-28 Thread Jean-Francois Nifenecker
Le 28/09/2014 13:19, Jean-Francois Nifenecker a écrit : Bonjour, sorry, this message was intended for the FR users list. Please discard. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get

Re: [libreoffice-users] Calc - combobox in a cell?

2014-09-22 Thread Jean-Francois Nifenecker
or Cell range. List: enter the items you want displayed Range: enter the wanted items list in a cell range on any sheet, the select this range. You may use named ranges as well. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re:[libreoffice-users] set different header/footer for even/odd pages

2014-09-18 Thread Jean-Francois Nifenecker
(let's call it evenpage). Its next property will have to be set to the oddpage style above. Once these exist, dealing with subsequent pages is a breeze: the next properties take care of the page changes. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Open the file where you finished

2014-09-18 Thread Jean-Francois Nifenecker
: Tools Options LibreOffice, User Data. Just setting your intials should suffice. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] Footnotes

2014-09-08 Thread Jean-Francois Nifenecker
other footnotes: you may have to resort to manual numbering of those. Very clever! I've tested this hint and it works very nicely (I've added the DT autotext for testing the footnote contents). The other footnotes numbering stays normal. Great hint! Thanks a lot! -- Jean-Francois Nifenecker

Re: [libreoffice-users] shortcut keys for LibreOffice under Linux

2014-08-13 Thread Jean-Francois Nifenecker
+Function key combination which I found annoying. Fortunately, this behaviour may be toggled in the Thinkpad BIOS, which I did. Now, pressing a function key alone gives me the normal function result and to get any of the extended functionalities I have to press the Fn+Function key combination. -- Jean

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread Jean-Francois Nifenecker
) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread Jean-Francois Nifenecker
difficulty lies in the backup of these settings (config dir and RegistryModifications.xcu and the .odb file), so that you may change PC without hassle. Unless I'm missing the obvious, it is not the case currently. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Intermittent Calc Issues

2014-08-04 Thread Jean-Francois Nifenecker
symptom seems related to the shift key being seen as pressed), I'm wondering if your laptop keyboard has no problem. Did you test LO and your spreadsheet on some other hardware? -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] Base questions

2014-07-31 Thread Jean-Francois Nifenecker
and mailing lists messages (EN and FR) that I reviewed, rephrased and assembled. If anyone is interested in translating from FR, it's ok by me (there are 39 pages in all and there remains one or two draft paragraphs). The current license is CC-BY-SA. Feel free to contact me in PM. HTH, -- Jean

Re: [libreoffice-users] Base questions

2014-07-31 Thread Jean-Francois Nifenecker
that could become excellent, if the devs where to focus on that (I've got no information here). The main question is how to switch from embedded mode to file mode? which I had a hard time figuring out. Fortunately, the web is you friend ;) -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e

Re: [libreoffice-users] Text in an IF function

2014-07-29 Thread Jean-Francois Nifenecker
as a month name (namely ), then: =IF(MONTH(A1)=8;doYes;doNo) HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Trouble with LO Writer templates

2014-07-26 Thread Jean-Francois Nifenecker
when in the document I attempt to produce a new paragraph? Your screenshots would be more readable if you'd set the unprintable characters as visible (Ctrl+F10). -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Trouble with LO Writer templates

2014-07-26 Thread Jean-Francois Nifenecker
Le 26/07/2014 18:44, Jean-Francois Nifenecker a écrit : Your screenshots would be more readable if you'd set the unprintable characters as visible (Ctrl+F10). Well, yes and no. I read way too fast. Is it possible to download a copy of your document? -- Jean-Francois Nifenecker, Bordeaux

Re: [libreoffice-users] Compatibility issue opening an .xlsx file with calc: Err:509

2014-06-30 Thread Jean-Francois Nifenecker
attachments. Please upload your file to some repository so that others here can reach it. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] How to ensure all new text entered into a document is different font, without changing the old font settings of the document?

2014-06-07 Thread Jean-Francois Nifenecker
text, just select this text and double-click the Answer character style to set the newly entered text. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Spell Check Dictionary

2014-05-20 Thread Jean-Francois Nifenecker
--- Have you ticked the following checkbox: Tools Options, Language Settings Writing Aids, User-defined dictionaries, Standard [All]? This done, LibO should behave --- 8 HTH, -- Jean-Francois Nifenecker, Bordeaux

Re: [libreoffice-users] ignore all during spellcheck

2014-05-18 Thread Jean-Francois Nifenecker
Settings Writing Aids, User-defined dictionaries, Standard HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Which components do you use most?

2014-05-12 Thread Jean-Francois Nifenecker
% Calc:40% Draw:15% Impress: 10% Base:10% Math: 0% That's more than 100%? Probably because I'm working more than that as well ;-) -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get

Re: [libreoffice-users] Draw problems

2014-05-10 Thread Jean-Francois Nifenecker
the Selection checkbox. And you're done! Your new image is now without any white space clutter. Note: the Selection checkbox doesn't retain its state. You'll have to check it again when exporting another drawing. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users

Re: [libreoffice-users] Imported document becomes corrupted, when edited.

2014-05-03 Thread Jean-Francois Nifenecker
from Writer do Draw: you haven't lost anything :) HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] OST to PST Conversion Recovery software.

2014-05-02 Thread Jean-Francois Nifenecker
Le 02/05/2014 12:38, DavidMabery a écrit : Caught up with unusable OST files and looking for ways to convert it to PST spam -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Re: Upgrade Problem on Windows

2014-04-29 Thread Jean-Francois Nifenecker
in the Internet. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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://wiki.documentfoundation.org/Netiquette List archive: http

[libreoffice-users] Manifeste

2014-04-15 Thread Jean-Francois Nifenecker
Bonjour, suite à des échanges en privé, j'ai actualisé et amélioré mon manifeste, joint en version 1.7. En particulier j'ai ajouté un paragraphe à propos du support. Merci à Nicolas Abel. Toutes les remarques, critiques et suggestions sont appréciées. Amicalement, -- Jean-Francois Nifenecker

Re: [libreoffice-users] Re: Modifying Styles

2014-04-05 Thread Jean-Francois Nifenecker
the document is not modified On your installation, is that box checked or unchecked? On my PC, this is unchecked, as it is by default after LibO install. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] MSO for iPad, big deal or big yawn

2014-04-02 Thread Jean-Francois Nifenecker
/office-for-ipad-big-deal-or-big-yawn/10137467/ I haven't got any smartphone, so I'm just wondering: what use for office software on such a small screen as a smartphone one? Is the software usable at all? -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Modifying Styles

2014-03-30 Thread Jean-Francois Nifenecker
without changing text. LibO v.4.1.4 (from TDF) under Debian Wheezy I can't reproduce this behaviour: Writer save button is activated after I import page styles from another document. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] Master Documents, Office Suites, and the Underwood

2014-03-26 Thread Jean-Francois Nifenecker
Le 26/03/2014 04:48, Brian Barker a écrit : Your history as a programmer is relevant - but leads me to an opposite conclusion. +1 Styles are another way of separating data and presentation which is a long standing programming mantra. A programmer should be interested in that. -- Jean

Re: [libreoffice-users] Master Document

2014-03-26 Thread Jean-Francois Nifenecker
formatted using that style - you've found the last word. And that's it. Well, I'm completely unable to write any such piece of code but no doubt this can be done, though the devil might be in some details. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Calc: limit number of columns and rows

2014-03-15 Thread Jean-Francois Nifenecker
for the current used cells. IOW, unused cells cost nothing. -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: limit number of columns and rows

2014-03-15 Thread Jean-Francois Nifenecker
. I'm fond of keystrokes because, among other qualities, they don't break the workflow... YMMV. -- Jean-Francois Nifenecker, Bordeaux -- 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] averaging with missing values

2014-02-15 Thread Jean-Francois Nifenecker
Le 15/02/2014 16:59, william drescher a écrit : Can anyone suggest a way of getting the average without needing to manually count the values ? Create your own averageif() function with a formula: SUMIF() / COUNTIF() -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-15 Thread Jean-Francois Nifenecker
: you select A1:B2 and name it my_array You may write formulae using the $A$1:$B$2 or the my_array syntax (note that you must not use quotes when dealing with array names in formulae). That is: =SUM($A$1:$B$2) or =SUM(my_array) give the same result HTH, -- Jean-Francois Nifenecker, Bordeaux

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-15 Thread Jean-Francois Nifenecker
Le 15/02/2014 21:14, Pikov Andropov a écrit : Data Define Range There, you define a dataset which can be further managed for data retrieval, sorting, filtering, mailing... -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-15 Thread Jean-Francois Nifenecker
Le 15/02/2014 22:06, Jean-Francois Nifenecker a écrit : Le 15/02/2014 21:14, Pikov Andropov a écrit : Data Define Range There, you define a dataset which can be further managed for data retrieval, sorting, filtering, mailing... The column headers are seen as field names and the other

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-14 Thread Jean-Francois Nifenecker
sort the array, be sure to set sort order to 0 or FALSE. +1 to all of these. The 0 (FALSE) parameter is the one I always use by default for the reason you stated (getting an error when no match is found). -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Error

2014-02-13 Thread Jean-Francois Nifenecker
(international) website is: http://www.libreoffice.org/download Some languages have a dedicated download page/website. EG for French: http://fr.libreoffice.org/telecharger/ HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Fit Text to Contour

2014-02-11 Thread Jean-Francois Nifenecker
the S-y tool. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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://wiki.documentfoundation.org/Netiquette List archive

  1   2   3   >