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
.
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
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
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
-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 archive: https
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
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
/!\ 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
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
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
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
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
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
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
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
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
"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
---
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
-- >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
- >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
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
-
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 archive:
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
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
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
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:
-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 archive: https://listarchives.libreoffice.org
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
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
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
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
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
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
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
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
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
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
).
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
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
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
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
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
-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
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
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
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
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
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
(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
:
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
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
-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
) 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
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
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
-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://listarchives.libreoffice.org
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
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
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
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
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
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
---
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
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
%
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
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
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
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
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
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
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
/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
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
-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://listarchives.libreoffice.org
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
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
.
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
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
: 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
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
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
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
(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
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
the Fontwork tool. There, do *not*
use the upper rounded shapes. Instead, use directly one of the four
tools just below to setup the text along the line you drew.
You should achieve what you're looking for.
--
Jean-Francois Nifenecker, Bordeaux
--
To unsubscribe e-mail to: users+unsubscr
select both the
text box and the line at the same time. Could you give me a detailed step by
step what works on your system? Thanks.
see above.
HTH,
--
Jean-Francois Nifenecker, Bordeaux
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org
you've got the right tool to get going.
Usage:
1. draw a line or a shape.
2. enter the associated text to the line/shape, as usual
3. click the Fontwork button and enjoy!
HTH,
--
Jean-Francois Nifenecker, Bordeaux
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http
and I never had a Mac to test :(
Any Apple-maniac suggestion would be fine :)
--
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
\hsqldb-2.2.8.\lib)
(2) Add a file
Point to the above \lib subdir
You should be up and running.
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
) and configure ActiveSetup to go
and copy these settings to the new user profile. And that's 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
) and configure ActiveSetup to go
and copy these settings to the new user profile. And that's 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
which introduces a donation
before the download, I can see no problem. Or am I mistaken?
--
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
-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://listarchives.libreoffice.org
ooops! forgot to specify the first step:
1. select the column to set as numbers first.
Le 11/11/2013 07:03, Jean-Francois Nifenecker a écrit :
2. do that:
Call the menu Data / Numbers as text (freely translated from my FR
install) then just click OK in the window that opens without
Le 11/11/2013 07:44, Brian Barker a écrit :
At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote:
Call the menu Data / Numbers as text (freely translated from my FR
install) ...
In English, that's Data | Text to Columns... .
thanks!
--
Jean-Francois Nifenecker, Bordeaux
]
:-)
--
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
Brian's idea about using VLOOKUP() through a 3 lines set of data.
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
have to print the form. Obviously, Adobe wants us to
purchase their tools g
Using third-party tools (eg FoxItReader under MS Windows, many tools
under GNU/Linux), you may save the filled form, and even change the data
afterwards if necessary.
Is this tutorial ok ;) ?
--
Jean-Francois Nifenecker
. (Abraham Maslow)
--
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
on dedicated areas to add features.
--
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
1 - 100 of 247 matches
Mail list logo
