Fwd: [libreoffice-users] Chart Range Entire Column

[Gabriele Ponzo]

I forgot to Reply All, I'm sorry.
---
Gabriele Ponzo



-- Forwarded message --
From: Gabriele Ponzo gpo...@gmail.com
Date: 2012/12/5
Subject: Re: [libreoffice-users] Chart Range Entire Column
To: Joel Madero jmadero@gmail.com


What You seem to be looking for is an auto-scaling feature which I
don't believe has been yet implemented.

Scientifically is correct that if you specify a range of x rows, the
graphic makes room for all af them, even if empty, because if they are
in the range, their data has to be considered (even null).

By the way it's an interesting point of view and could be suggested as
a new feature to be added as an option for instance, I think, because
it could be useful as well.

What I can tell You to solve this, for the moment, is to double click
into the graphic to go editing it, and then double click the Date's
axis. Now You can specify in the first Tab (Scale) the Maximum Value,
avoiding the Automatic Option. In this way it will render just the
portion of Data You'll need.

It still requires to edit the graphic, but I think it's surely better
and faster than having to modify the Data Values Area. And I think You
could do this once a quad, leaving not too much blank space at the end
of the graphic.

I really hope to have been useful for You and all people reading, and
also to have aimed a good solution without forgetting other ones which
could have been simpler.
---
Gabriele Ponzo


2012/12/5 Joel Madero jmadero@gmail.com:
 Hi All,

 I want to know if there's a way to make a chart range be an entire column
 so that if I add data I don't have to manually alter the range. For
 instance, every month I do expenses and the new row would be MM/ then
 there's expenses and income listed, every time I add a new entry I have to
 manually update the data range which is a hassle. If I select the entire
 column as a data range it automatically adjusts to the last row with data.
 Furthermore, if I just do a range that has like 10,000 extra rows (Maybe
 A1:A1) the chart is squished (it doesn't auto adjust according to logic
 of where last cell contains data and then update when new data is entered).

 Many thanks as always,
 Joel

 --
 *Joel Madero*
 LibO QA Volunteer
 jmadero@gmail.com

 --
 For unsubscribe instructions e-mail to: users+h...@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/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base Form behavior.

[Gabriele Ponzo]

And a (dirty) workaround could be putting a move last and then a move first
by code, on form open, isn't it?
Il giorno 06/dic/2012 08:06, Alex Thurgood alex.thurg...@gmail.com ha
scritto:

 On 12/06/2012 05:08 AM, Hank Alper wrote:

 Hi Hank,

 ith the same result. Is this a bug? Has anyone noticed this  type of

 behavior ? Base seems to start out handling records in increments of
  about
 40 records until it finds the end of the file. Strange.
   Hank Alper


 This is the programmed behaviour. Whether, as a UI experience, it is
 normal, is a matter of debate ;-)

 The result set is cached, and the window display also caches part of the
 result set to avoid performance penalties by not having to redraw all
 elements of the window, hence the misleading information. Some work was
 done recently in 3.6/3.7/4.0 development to improve this handling, but it
 was mainly around the window refresh area from what I recall, as other
 changes to the code had caused this bit to be even slower, and not refresh
 at all, or at best take so long about it that the user got a blank screen
 :-/

 So, at the moment, your best bet is probably to put in a request for
 enhancement, after having tested on LO 3.6.x to see if there's any
 difference when compared to 3.5.x.


 Alex



 --
 For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
 org users%2bh...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Bug report for LibreOffice 3.6.4.3 on Mac OS X 10.6.8

[Gabriele Ponzo]

I've tried and it happens the same to me (on MacOs 10.6.8 - LO 3.6.3.2)
---
Gabriele Ponzo


2012/12/10 NoOp gl...@sbcglobal.net:
 On 12/09/2012 12:13 PM, Marc Grober wrote:
 With 3.6.3.2 and OSX 10.8.2 selecting two odt files from Finder and
 directing Finder to open both with LO results in a graphic message that
 file1file2 does not exist (suggesting it is concatenating the file
 name?)
 HOWEVER - using the LO menu to open the same multiple odt files works
 without issue.
 ...

 Ah, thanks for clarifying. Being a linux user I wasn't aware of what
 Finder is, I do now: https://support.apple.com/kb/ht2470. So I was
 testing directly from the LO menu  that works fine.

 So for a correction:

 If I try the same (select two files in the system file manager and
 double-click) on linux using 'Nautilus' (GNOME file manager), only one
 file will be opened  no error message. I suspect that this is more an
 issue with my 'clicking' than the file manager, as when I select the
 files, and use the 'Enter' key on the keyboard, both files open in two
 LO windows.

 This is not the case with the KDE file manager 'Dolphin'. Trying the
 same with 'Dolphin' results in LO opening one file, and the following
 error message for the second file:

 KDEInit could not launch 'libreoffice':
 Could not find 'libreoffice' executable.

 The issue is with the file manager, not LO.




 --
 For unsubscribe instructions e-mail to: users+h...@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/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Bug report for LibreOffice 3.6.4.3 on Mac OS X 10.6.8

[Gabriele Ponzo]

While it works perfectly with LO 3.5.6.2 (still on MacOs 10.6.8).

I have both installed and now I tried with the older one.
---
Gabriele Ponzo


2012/12/12 Gabriele Ponzo gpo...@gmail.com:
 I've tried and it happens the same to me (on MacOs 10.6.8 - LO 3.6.3.2)
 ---
 Gabriele Ponzo


 2012/12/10 NoOp gl...@sbcglobal.net:
 On 12/09/2012 12:13 PM, Marc Grober wrote:
 With 3.6.3.2 and OSX 10.8.2 selecting two odt files from Finder and
 directing Finder to open both with LO results in a graphic message that
 file1file2 does not exist (suggesting it is concatenating the file
 name?)
 HOWEVER - using the LO menu to open the same multiple odt files works
 without issue.
 ...

 Ah, thanks for clarifying. Being a linux user I wasn't aware of what
 Finder is, I do now: https://support.apple.com/kb/ht2470. So I was
 testing directly from the LO menu  that works fine.

 So for a correction:

 If I try the same (select two files in the system file manager and
 double-click) on linux using 'Nautilus' (GNOME file manager), only one
 file will be opened  no error message. I suspect that this is more an
 issue with my 'clicking' than the file manager, as when I select the
 files, and use the 'Enter' key on the keyboard, both files open in two
 LO windows.

 This is not the case with the KDE file manager 'Dolphin'. Trying the
 same with 'Dolphin' results in LO opening one file, and the following
 error message for the second file:

 KDEInit could not launch 'libreoffice':
 Could not find 'libreoffice' executable.

 The issue is with the file manager, not LO.




 --
 For unsubscribe instructions e-mail to: users+h...@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/global/users/
 All messages sent to this list will be publicly archived and cannot be 
 deleted

-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Bug report for LibreOffice 3.6.4.3 on Mac OS X 10.6.8

[Gabriele Ponzo]

Upgraded to last available version to download and it still gives the
same error :(
---
Gabriele Ponzo


2012/12/12 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 The 3.5.6 is on the equivalent of Service Pack 6 while 3.6.3 is only on it's
 Service Pack 3.  Oddly the 3.5.6 is older, it was released around 19th Aug,
 whereas the 3.6.3 was around 4th November.  Both have been superseded by
 more recent releases in their respective branches
 3.6.4 (equiv of Sp4) on   9th Dec
 3.5.7 (equiv of Sp7) on 14th Oct

 It is good to try different versions so it's good to know the problem is not
 in the 3.5.x branch and is just a fairly recent regression.  If you are
 happy to settle with the 3.5.6 that is fine but it would be helpful to know
 if the bug is still in the 3.6.4.  (There's no point in testing the 3.5.7)

 Regards from
 Tom :)


 
 From: Gabriele Ponzo gpo...@gmail.com
 To: NoOp gl...@sbcglobal.net
 Cc: users@global.libreoffice.org
 Sent: Wednesday, 12 December 2012, 10:25
 Subject: Re: [libreoffice-users] Re: Bug report for LibreOffice 3.6.4.3 on
 Mac OS X 10.6.8

 While it works perfectly with LO 3.5.6.2 (still on MacOs 10.6.8).

 I have both installed and now I tried with the older one.
 ---
 Gabriele Ponzo


 2012/12/12 Gabriele Ponzo gpo...@gmail.com:
 I've tried and it happens the same to me (on MacOs 10.6.8 - LO 3.6.3.2)
 ---
 Gabriele Ponzo


 2012/12/10 NoOp gl...@sbcglobal.net:
 On 12/09/2012 12:13 PM, Marc Grober wrote:
 With 3.6.3.2 and OSX 10.8.2 selecting two odt files from Finder and
 directing Finder to open both with LO results in a graphic message that
 file1file2 does not exist (suggesting it is concatenating the file
 name?)
 HOWEVER - using the LO menu to open the same multiple odt files works
 without issue.
 ...

 Ah, thanks for clarifying. Being a linux user I wasn't aware of what
 Finder is, I do now: https://support.apple.com/kb/ht2470. So I was
 testing directly from the LO menu  that works fine.

 So for a correction:

 If I try the same (select two files in the system file manager and
 double-click) on linux using 'Nautilus' (GNOME file manager), only one
 file will be opened  no error message. I suspect that this is more an
 issue with my 'clicking' than the file manager, as when I select the
 files, and use the 'Enter' key on the keyboard, both files open in two
 LO windows.

 This is not the case with the KDE file manager 'Dolphin'. Trying the
 same with 'Dolphin' results in LO opening one file, and the following
 error message for the second file:

 KDEInit could not launch 'libreoffice':
 Could not find 'libreoffice' executable.

 The issue is with the file manager, not LO.




-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] FDF forms

[Gabriele Ponzo]

If FDF means editable PDF,  then it should be enough to put widgets from
the form toolbar into a writer document. Then export it in PDF.

Hope to have understood and given a correct answer.

Il giorno 18/dic/2012 14:57, Malcolm Moore st-malcolm.mo...@whsg.info
ha scritto:

 Is there a guide somewhere to making FDF forms with Writer ?
 I know how to export a document to an FDF but how do I add
 editable fields to the document. ( is this actually possible )


 Ta


 M

 --
 For unsubscribe instructions e-mail to: users+h...@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/global/users/
 All messages sent to this list will be publicly archived and cannot be
deleted


-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: Printing Labels From Google Address Book

[Gabriele Ponzo]

The first thing it comes to my mind is to export from Google in CSV
format, and then re-open it in Calc. From there You should be able to
easily convert it into a LO DB.

Regards.
---
Gabriele Ponzo


2012/12/19 Keith Bates ke...@new-life.org.au:


 Hello,

 Having just finished my annual Christmas card mail out and mastering the
 arcane wizardry of producing labels from a database, I realised that my
 address list is greatly out of date.

 It occurred to me that rather than trying to maintain a separate
 database which I use exactly once a year, it would be more useful to
 import addresses from my Google contact list.

 Is there any simple way of importing a selection of Google contacts into
 Libre Office?

 Thanks

 Keith




 --
 For unsubscribe instructions e-mail to: users+h...@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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
For unsubscribe instructions e-mail to: users+h...@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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [Base] Ready-to-use solutions to manage membership + inventory?

[Gabriele Ponzo]

But... in Base there are several ready examples of tables and fields when
you go creating a new table via wizard.

Out of LibreOffice, instead, I could suggest CiviCRM.

Google it and give it a try, if you deem it suitable for their
requirements.
Il 17/mag/2015 22:51, toki toki.kant...@gmail.com ha scritto:



 On 17/05/2015 19:35, Gilles wrote:
  Which is why I asked about templates so that person can just download,
 install, and be on his way.

 Database templates will almost always have to be modified by the user,
 for their specific requirements. Consequently, there is very little
 impulse to create and upload generic database templates.

 jonathon

 --
 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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: [Base] Ready-to-use solutions to manage membership + inventory?

[Gabriele Ponzo]

Ok, I didn't know that. Even if you could still install it in his LAN or on
the very same machine he (or she)  uses :)

Good luck!
Il 18/mag/2015 00:35, Gilles codecompl...@free.fr ha scritto:

 Thanks, but the user wants a desktop application, so a web-based CRM won't
 do
 (and is overkill).

 The search goes on.



 --
 View this message in context:
 http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774p4148805.html
 Sent from the Users mailing list archive at Nabble.com.

 --
 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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] base + mailmerge difficulty

[Gabriele Ponzo]

The list doesn't allow attachments. Could you keep them on a xloud and link
here?

What i see is that you should prepare a query where you already have 14
results (even null) in a single record.
Il 26/giu/2015 18:06, Ed Beroset bero...@mindspring.com ha scritto:

 I'm trying to print out schedules for students using mailmerge and have
 encountered a problem that I haven't yet been able to solve.  Here's what
 I've done so far.

 I have created a simple embedded database (named school) in base and I
 have three tables named Classes, Students and Schedules.  Classes has three
 fields: ClassID (which is the index), ClassTitle and CreditHours.  The
 Students table has StudentID (the index), LastName and FirstName.  The
 Schedules table has PairID (the index) and StudentID and ClassID.

 Students and Classes are just what you'd expect.  Each record in the
 Schedules table links one student and one class.  A schedule is the
 collection of all classes for a particular student.  I have created a
 simple query for the Schedules table:

 SELECT Schedules.StudentID StudentID, Students.LastName
 LastName, Students.FirstName FirstName, Schedules.ClassID
 ClassID, Classes.ClassTitle ClassTitle, Classes.CreditHours
 CreditHours FROM Schedules Schedules, Students Students,
 Classes Classes WHERE Schedules.StudentID = Students.StudentID
 AND Schedules.ClassID = Classes.ClassID ORDER BY StudentID,
 ClassID

 All of that works just fine and I've also created a simple report that
 uses the query, which also works as expected.

 Now what I want to do is to create a separate schedule document for each
 student.  I'm attempting to use mailmerge to do that.  I have a simple .ott
 file which has Schedule for FirstName LastName in the header and then
 a table in the body of the document.  It has a header and about 14 rows
 (the maximum number of classes I expect) and then a final row which has a
 formula which calculates the total number of credit hours.

 When I select and filter one individual student, the schedule prints just
 fine, but if I try to generate all of them, it doesn't work as I want.
 Specifically, it picks up the first student's name but then it populates
 the table with the next 14 classes in the query, whether or not this
 *particular* student is taking that class or not.  Each page is filled with
 14 classes until we get to the end of the list.

 Each row of the table includes the three fields and then a Next record
 which is probably where my problem lies.  The condition is set to TRUE.
 Somewhat schematically, each line looks like:

 school.Query_Schedules.ClassID school.Query_Schedules.ClassTitle
 school.Query_Schedules.CreditHours Next record:school.Query_Schedules

 Any clues would be most welcome.  I'm quite new to LibreOffice and my SQL
 skills are very rusty, but I'd love to learn more about both if it helps me
 solve this problem!

 Also, attached is a small zip file with both the database and template if
 you'd like to try.

 Thanks!

 Ed

 --
 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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: base + mailmerge difficulty

[Gabriele Ponzo]

Mail merge is a Writer feature, but also Base reports rely on Writer!

So I guess for both cases it's just about arranging a proper report.

By the way I hope to have soon some spare time to do some attempts.
Il 28/giu/2015 01:00, Andreas Säger ville...@t-online.de ha scritto:

 Mail merge can not do this. For the same reasons we can not print any
 invoices where many orders belong to one client.


 --
 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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Gabriele Ponzo]

I've always believed that PC Mag is in M$'s payroll and this article just
confirms my thoughts.
Il 19/ago/2015 01:24, Steve Edmonds steve.edmo...@ptglobal.com ha
scritto:

 Hi. Is this a review for LO 4? When I click on the link I get a review for
 4.0
 Steve

 On 2015-08-19 06:22, James Knott wrote:

 I just came across this article.


 http://www.pcmag.com/article2/0,2817,2418419,00.asp?mailing_id=1431647mailing=whatsnewnowmailingID=E2768DCC83E0602F9C1DB70A73032992




 --
 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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Importing csv files from the bank

[Gabriele Ponzo]

Indeed I believe this should be the problem.

To solve just select english/us on the amounts columns when you import
CSV.

In this way it should consider and replace decimal dots with your country's
decimal separator (comma).
Il 24/lug/2015 10:42, James Wilde james.wi...@sunde-wilde.com ha
scritto:

 I see your name is Nielsen, which could indicate that you are Danish or
 Norwegian.  Can it be that you have one of these two languages/regions
 as your default, which means, amongst other things that the decimal
 separator is a comma.  If you are importing from an english or american
 bank, the decimal separator will be a dot.

 James

 On 2015-07-23 11:22, Vicki Nielsen wrote:
  Hi,
  I am having troubles importing  csv files from the bank. When I import
 the files, they do not include decimal figures, only whole numbers, so the
 system won't balance. Any ideas as to how to get the whole figures imported?
 
  Best regards,
  Vicki Nielsen


 --
 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/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] lost opportunity

[Gabriele Ponzo]

Marianne, it's really strange since I use to install LO on a daily basis on
M$ Windows as well, and not having any issue.

I don't know if it's a mirrored files issue or if it's something on -that-
computer, as it happens now and then that Windows has strange (at least)
behaviors.

My suggestion is to to have a Pen Drive dedicated to software installations
and deployments with tested files on which you can rely on. This way gives
you the sureness that the problem is on the customer's computer side.

Anyway I believe it's not all lost since at least she'll be using ODF
format and whenever You'll want to try convincing her to migrate to LO, the
impact will be much softer. The most is done when leaving M$O.

I hope to have been helpful somehow, at least for the future.

Bye.

---
Gabriele Ponzo

2015-11-05 12:03 GMT+01:00 Charles-H. Schulz <
charles.sch...@documentfoundation.org>:

> Hello Marianne,
>
>
> Le 05.11.2015 08:42, marianne-x a écrit :
>
>> A minor tale of woe:
>>
>> I have been trying for years to convince a young lady friend to break
>> away from slavish dependence upon Micro$oft, and at least give LO, et.
>> al,, a try.
>>
>> Her Curtains machine, running on Vista, finally got so clogged with
>> untraceable trash that a complete system reload seemed the only
>> remedy.
>>
>> That meant re-authorizing the bundled M$ office suite and Bill,
>> apparently continuing his unholy lust for revenue, refused to accept
>> her utterly legitimate "product key".
>>
>> What a chance to gain a convert but, alas, LO queered the deal once again.
>>
>> I downloaded the software at least 6 times, mostly from the Clarkson
>> U. mirror where TDF sends one by default, but from at least one other
>> mirror as well.
>>
>> 4.4.6 three times, 218,736 KB each; 4.4.5 at 219,300 KB; 5.0.3 twice
>> at 215,632 KB each. None of these would install, or give any
>> indication of why they wouldn't.
>>
>> Readers may assume that my procedure is at fault, and it may well be,
>> but after these failures I had no trouble fetching and successfully
>> installing AOO, Abiword, Jarte, HexEdit, Foxit, Firefox, Thunderbird,
>> Audacity, 
>>
>> I have a number of LO .msi files, going back to 3.5.4, on my own
>> machines (all Curtains 7), and can try transporting them to the target
>> via an external drive, in case there is actually something squirrelly
>> about today's downloads.
>>
>> But, after this experience, the would-be client - fearful of change in
>> any case - can be excused for looking askance at LO, and may be a lost
>> cause.
>>
>> For my own edification, even if there's no salvaging today's fiasco,
>> does anybody have any suggestions as to how such a supposedly
>> foolproof process can go so far awry?
>>
>
>
> It's a shame indeed. I don't know if it's really lost though: perhaps you
> could reinstall LibreOffice for her if there's a working mirror - few
> people experience what your have gone through and I don't really know what
> went wrong with this particular server.
> My personal suggestion would be to ping us (this list,
> http://ask.libreoffice.org or even our twitter account (@libreoffice or
> @tdforg) or directly try a different mirror.
>
> Also, I'm curious to know what operating system you replaced her existing
> system with. It looks like you didn't want to migrate the person on Linux.
> If this had been the case, you would probably not have had to download all
> these software for her - but a migration to Linux may cause issues as well.
>
> Thank you for helping out this person!
>
> Best,
>
> Charles.
>
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LEBRE VERSION STILL

[Gabriele Ponzo]

This is really strange… Please try using "evince" as reader and let us know.

---
Gabriele Ponzo

2015-11-05 18:03 GMT+01:00 Philip Jackson <philip.jack...@nordnet.fr>:

> Sure, the whole of my LO document is style based and the TOC links work
> great inside the LO document. But not in the exported pdf document. So I
> probably didn't understand something.
>
> Philip
>
> On 05/11/15 14:52, Gabriele Ponzo wrote:
> > Maybe, but make sure using styles to have a result ;)
> >
> > ---
> > Gabriele Ponzo
> >
> > 2015-11-05 14:17 GMT+01:00 Philip Jackson <philip.jack...@nordnet.fr>:
> >
> >> On 05/11/15 04:21, Steve Edmonds wrote:
> >>> I use an external PDF writer for some documents where LO fails to
> >>> convert vector formats correctly.
> >>> That said, if I use the external converter I loose all my cross
> >>> referencing and TOC links that LO does very well in my opinion.
> >>> Steve
> >>
> >> I have used export to pdf in LO Writer and always had a good pdf copy
> >> but the TOC links never work in the pdf version.  I've tried the
> >> different options under the links tab in the export to pdf dialogue but
> >> can't find any difference whatever the options selected.
> >>
> >> I'm using LO 4.2.8.2 as supplied by UbuntuStudio 1404.  For reading the
> >> pdf's, I use Okular.
> >>
> >> Does the use/performance of TOC links in the pdf depend on the reader ?
> >>
> >> Philip
> >>
> >> --
> >> 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/global/users/
> >> All messages sent to this list will be publicly archived and cannot be
> >> deleted
> >>
> >
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] lost opportunity

[Gabriele Ponzo]

>
> […]
>
> Besides, if I failed to pull off a
>> simple install of LO on a virgin-system machine,
>
>
It was not a virgin system, because OEM images are full of "suggested"
softwares…


> what chance would I have with Linux?
>
>
Many more, since it installs flawless and brings LO along with the system,
and also keeps it updated like every other software distributed with it
(that's why Linux Distributions are called so ;).

[…]

>
> As said, if the fault is truly in all the many downloads of yesterday,
> then transporting by external drive one or more of the 21
> earlier-edition installers still available on this Curtains 7 machine
> should work. However, I suspect that some negative synergy twixt LO
> and Vista has reared its ugly head here.
>

As written, more than a Vista & LO issue (which can happen anyway) I tend
to believe to some LO & some other vendor's bundled stuff issue.

>Yes indeed. I just checked the mirrors you mentioned. I clicked on each of
them, and each of them worked, and worked well.
>Maybe there's an issue with the browser? At least today, right now, these
mirrors are fully working.

Or, indeed, maybe also some malware or virus is corrupting images
downloaded.
Did you try MD5 checksum? And what about downloading via Torrent?

By the way, just for curiosity, what was the error returned by the
installer?
---
Gabriele Ponzo

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LEBRE VERSION STILL

[Gabriele Ponzo]

2015-11-05 17:20 GMT+01:00 Ken Springer <snowsh...@q.com>:

> I don't have money to pay to have it fixed (one of the reasons I try to
> use open source/free software),
>

That should be the last reason to choose Open Source Software… I can
understand it, since it was the same for me in the far 90's, but sooner or
later you should go deeper and try understanding the principles behind OSS.

I'm not anyone's beta tester.   
>
> So you'd want a perfect product, without paying money nor time to commit
somehow (just like beta testing or translating or whatever else commitment)?


> Which is why I've just started trying FreeOffice from Softmaker.  Do I
> know for a fact it will do what I need?  No, that's why I'm trying it out.
>If FreeOffice doesn't do it, there are others to try.   :-)
>

Well, maybe you'll find a free "product" that suites your needs, possibly
not open, so that you'll be locked in its own encoding cage.

Please respect people of the community and avoid insulting with your
requirements about taking without giving anything back.
---
Gabriele Ponzo

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: Undeliverable: introducing my self and a gift for appreciation to you:

[Gabriele Ponzo]

As you correctly wrote, I've been able to reply to him (or her) without any
error received back. So either you didn't copy that address correctly or
it's been disabled just today :)

By the way I've not checked what you have as recipient with the one I've
been using, since I'm using the smartphone at the moment.

Cheers.
Il 07/ott/2015 20:10, "James Wilde"  ha scritto:

>
> On 07 Oct 2015, at 19:31, Brian Barker  wrote:
>
> > At 18:52 07/10/2015 +0200, James Wilde wrote:
> >>> *From:* Postmaster 
> >>> 
> >>> The email account that you tried to reach does not exist.
> >>
> >> How embarrassing!  :*(
> >
> > What's embarrassing - that you simply got the address wrong?
> >
> > Brian Barker
>
> Problem is, Brian, that I copied it from the OP's message.  Or thought I
> did.
> >
> > --
> > 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/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> deleted
> >
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Libre Writer - Line Spacing - not appearign as single space

[Gabriele Ponzo]

I couldn't catch exactly what are you trying to do.

Did you mean the vertical spacing among lines or the horizontal among
characters?

If you started with "plain text" why doors it have such a (double?) spacing?

What font are you using?
Il 15/ott/2015 00:29, "charles meyer"  ha scritto:

> Hi Folks,
>
> In Libre Writer 4.3.5.2, I wanted to change the plain text to single
> spacing for all lines of text in all paragraphs. I highlighted all the
> lines and then I followed both of these suggestions but it still
> appears double-spaced although it says it's single spaced but isn't
>
> How do I truly secure single spacing?
>
> 1. Select the paragraph and then go to Format, Paragraph, Indents &
> Spacing tab, Line Spacing .
>
> 2. Right click to open the context menu > Line Spacing.
>
> Thank you.
>
> Charles.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Though I sent the email, [Please read this too because I am worrying about you misunderstand my mind]

[Gabriele Ponzo]

What is unclear is if you don't want to receive mails about your question
or if you don't want to receive mails at all.

Because you may have not understood that this is a mailing list. So you'll
receive every message from very each sender about every topic, unless you
decide to unsubscribe.

In that case, you may find instructions for that at botom of each message.

I hope to have been clear and helpful.

All the best.

---
Gabriele Ponzo

2015-10-13 19:37 GMT+02:00 Alexander Y Lee <lovesic73...@naver.com>:

> Though I request not to reply to me, I appreciate you your help and
> kindness from the bottom of my heart, but actually, before I ask question
> via email, I was not familiar with the system of Libre Office's QA
> system that hundreds to thousands people receive my letter and reply to me.
> I thought that like other company, one specific main officer replies to me
> later. But I was astonished by receiving too many emails and constant email
> alarming. It continued. So, I just really express my gratitude to all
> people trying to help me. I appreciate that sincerely. And, different from
> it, I just want to ask you with sincere politeness because constant
> alarming has been continued. I just mean to ask about that. I really wish
> that you will not get my lines crossed. if it bothers you, I apologize in
> advance.
> In conclusion, my question was solved your help already. I appreciate it
> very much!
>
> Thanks,
>
> Have a nice day.
>
> Alexander
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Liberation fonts vs Google croscore fonst

[Gabriele Ponzo]

I'm not informed on that specifically, but usually forks are made for
license issues, so that may be the "problem".

Try comparing Google and Liberation Fonts licenses if you wish, and if
you'll do please report to us as well.

I'd appreciate, at least  ;)

---
Gabriele Ponzo

2015-10-05 22:40 GMT+02:00 Bastián Díaz <diaz.bast...@openmailbox.org>:

> Hi, this must be an old topic but I wonder why LibreOffice does not use
> the full set of google croscore fonts.
>
> Currently, LibreOffice includes Caladea and Carlito replacing Cambria and
> Calibri fonts. However, LibreOffice does not include the fonts Arimo, Tinos
> and Cousine (replacing Arial, Times New Roman and Courier), from my point
> of view and testing, google fonts do a better job than the liberation
> fonts: better visualization, metric gauge more compatible with microsoft
> fonts, increased support glyph, etc.
>
> From what I've read, since version 2.0 of Liberation Fons is a fork of
> google croscore fonts ... but in practice do not appear.
>
> Is there any reason to prefer Liberation fonts over google croscore fonts?
>
> --
> Bastián Díaz
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Liberation fonts vs Google croscore fonst

[Gabriele Ponzo]

Thank you.

I guess the suggestion should have arrived at destination (devs) as (some
of) they also should read this list as well.

---
Gabriele Ponzo

2015-10-06 11:58 GMT+02:00 Bastián Díaz <diaz.bast...@openmailbox.org>:

> El 06-10-2015 05:50, Gabriele Ponzo escribió:
>
>> I'm not informed on that specifically, but usually forks are made for
>> license issues, so that may be the "problem".
>>
>>
> Liberation fonts 2.0 (SIL open font license1.1) is a fork of google
> croscore fonts, due to the initial license of "liberation fonts" (GPL v2):
> https://fedorahosted.org/liberation-fonts/
>
> Try comparing Google and Liberation Fonts licenses if you wish, and if
>> you'll do please report to us as well.
>>
>> I'd appreciate, at least  ;)
>>
>>
> Google croscore fonts they are licensed under ASL 2.0 (LibreOffice
> supports). Currently the google crosextra fonts are included with
> LibreOffice.
>
> From my point of view, it is not a licensing issue, however, the superior
> quality of the google fonts think they should be included as standard in
> LibreOffice for the benefit of their users.
>
> .cheers
> --
> Bastián Díaz
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Bugs

[Gabriele Ponzo]

Thank (all of) You for Your commitment.

Once you'll get used to that (let's say within 6 months), please consider
applying for membership as well.

http://www.documentfoundation.org/foundation/application-for-tdf-community-membership/
Il 01/set/2015 01:18, "jorge"  ha scritto:

> Hi V Stuart Foote and all:
>
> Thank you very much for this information ... I haven't known about
> it.
> I will start to read your links to learn more about this project (LO)
> and to try to understand too to give then if I can my little
> contribution.
>
> Regards,
>
> Jorge Rodríguez
>
>
>
> El lun, 31-08-2015 a las 05:47 -0700, V Stuart Foote escribió:
> > jorge-2 wrote
> > > ...
> > >
> > >How we can help with this ?
> > >
> > >We, the users can make one example to each topic of the menu of
> > > LibreOffice can do. Then when coming new version before out we can
> probe
> > > each example during one week and make a report to programers. With this
> > > reports, just following the menu, they can fix the bugs that apear
> before
> > > freeing the new version.
> > >
> > >The other way is to make a macro to probe each topic of the menu to
> do
> > > it automatically.
> >
> > It is already there.
> >
> > LibreOffice "Regression Testing," both automated and manual, is continual
> > and ongoing:
> >
> > https://wiki.documentfoundation.org/QA/Testing/Regression_Tests
> >
> > Individuals, please note that the LibreOffice project runs a MozTrap
> based
> > test suite for performing exactly this manual testing--with guided test
> > cases--but it is woefully underutilized by the broader user community. If
> > you are interested, check it out:
> >
> > https://wiki.documentfoundation.org/MozTrap/User_Guide
> > http://manual-test.libreoffice.org/results/runs/?
> >
> > The learning curve is a little steep for folks to get registered and get
> a
> > test case open, but is worth the effort as the results ARE reviewed and
> > integrated into the QA process.  The Engineering Steering Committee
> reviews
> > results bi-weekly.
> >
> >
> >
> > --
> > View this message in context:
> http://nabble.documentfoundation.org/Unable-to-Protect-Unprotect-cells-in-Libreoffice-5-tp4158473p4158876.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
>
> --
> Atentamente,
>
> Jorge Rodríguez
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[Gabriele Ponzo]

http://www.libreoffice.org/get-help/professional-support
Il 11/set/2015 07:11, "Joel Madero" <jmadero@gmail.com> ha scritto:

> You mean a paid professional? I could ask one or two people - if you're
> instead asking for a volunteer to assist, best bet is to just asked
> around on the email thread and maybe the OOo forum (there are a few
> great macro people over there).
>
> Best,
> Joel
>
> On 09/10/2015 09:39 PM, David Johnson wrote:
> > Dear Joel & Tim,
> > Thanks for your valuable inputs, appreciate it. Is there any
> > professional, whom you know, could help me to redevelop the same in
> > Libre Calc.
> > --
> >  Thanks ,
> > *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> > Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> > Bangalore - 560027*|***|***www.janalakshmi.com**|*
> > *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> > 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*
> > On 11-09-2015 04:20, Joel Madero wrote:
> >> That is a true statement - LibreOffice does not support the
> >> proprietary Microsoft VBA (it may in a very very limited way but not
> >> enough for most test cases that I've seen) - you'll have to rewrite
> >> it in Basic.
> >>
> >> Best,
> >> Joel
> >>
> >> On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd <tim.ll...@gmx.com
> >> <mailto:tim.ll...@gmx.com>> wrote:
> >>
> >> Hi David,
> >>
> >> my understanding is that macros in excel and calc are written in
> >> different languages so need to be rewritten.
> >>
> >> Maybe one of the more learned members of the forum can confirm or
> >> otherwise.
> >>
> >> Cheers
> >>
> >>
> >> On 10/09/15 19:48, David Johnson wrote:
> >>
> >>
> >> Dear Gabriele and Tim,
> >> PFA; This is the Excel Macro sheet we are trying to convert.
> >> Could you please help me.
> >>
> >> --
> >> Thanks ,
> >> *|David Johnson|***|***H**O* - Technology &
> >> Process*|**|**Janalakshmi Financial Services
> >> Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore -
> >> 560027*|***|***www.janalakshmi.com
> >> <http://www.janalakshmi.com>**|*
> >> *|**Phone :* +91 080-42595100
> >> <tel:%2B91%20080-42595100>/700*|**|**Ext*-242*|**|**Mobile*:
> >> +91 95-38-455118 <tel:%2B91%2095-38-455118>*||**E-Mail *:
> >> david.john...@janalakshmi.com
> >> <mailto:david.john...@janalakshmi.com>*|*
> >> On 10-09-2015 12:17, Tim Lloyd wrote:
> >>
> >> Hi David,
> >>
> >> as noted below. It could just work! Which version were
> >> you think of using? I think there is some consensus that
> >> 5.0 may be a little too "fresh" for an enterprise
> >> environment. So the still version of 4.4.5 may be a good
> >> base. Download this version and give it a go:
> >>
> >> http://www.libreoffice.org/download/libreoffice-still/
> >>
> >> There may also be some value having a hunt around the
> >> bugzilla to see if any issues are relevant to yourselves.
> >>
> >> https://bugs.documentfoundation.org/
> >>
> >> Cheers
> >>
> >> On 10/09/15 16:24, Gabriele Ponzo wrote:
> >>
> >> What's your problem specifically?
> >>
> >> Unless there are macros, usually it's enough to open
> >> LibreOffice Calc and
> >> let it open the excel file. Then save it in odf
> >> (.ods) format.
> >>
> >> Let is know of there are troubles with these steps,
> >> and please report
> >> specific problems.
> >>
> >> All the best.
> >> Il 10/set/2015 07:16, "David Johnson"
> >> <david.john...@janalakshmi.com> ha
> >> scritto:
> >>
> >> Dear Users,
> >> I'm David Johnson, from the Technology team from
> >> 

Re: [libreoffice-users] LibreOffice Damaged

[Gabriele Ponzo]

You mentioned 4 LO versions. From what I know on Windows it's not possible
to install more than one unless you use a specific software which name i
can't recall at the moment.

So the question is: why do you have so many version installed? And how did
you install them?
Il 12/set/2015 00:15, "Taang Zomi"  ha scritto:

> I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1)
> repaired, and when I got it back, I found that my LibreOffice (4.4.4) could
> not be used. I got a message:
>
> ==
>
> LibreOffice 4.4.4  -- Fatal Error
> ---
> The program cannot be started.
>
> The service manager is not available.
>
> ("premature end of file:///C:/Users/
>
> Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")
>
> Start setup application to repair indtallation from CD, or the folder
> containing the installation packages.
>
> [OK]
>
> ==
>
> I did not understand what the message meant.
>
> Thinking that I could repair it, I went to the folder where I saved the
> program, and I clicked the program twice.   When the the time came for
> installation, I clicked "repair",  and it was successfully installed. But
> when I clicked LibreOffice 4.4.4 twice,  the same message appeared.
>
> Every time I clicked LibreOffice 4.4.5,  5.0.0 and 5.0.1, I got the same
> message, except for the heading, which changed to
>
>
> LibreOffice 4.4.5  -- Fatal Error
> LibreOffice 5.0.0  -- Fatal Error
> LibreOffice 5.0..1 -- Fatal Error
>
> How can I use my LibreOffice again? What do I need to do?
>
> Sincerely,
>
> Taang Zomi
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[Gabriele Ponzo]

What's your problem specifically?

Unless there are macros, usually it's enough to open LibreOffice Calc and
let it open the excel file. Then save it in odf (.ods) format.

Let is know of there are troubles with these steps, and please report
specific problems.

All the best.
Il 10/set/2015 07:16, "David Johnson"  ha
scritto:

> Dear Users,
> I'm David Johnson, from the Technology team from Janalakshmi Financial
> Services, Bangalore based NDFC. Currently we are migrating our excel based
> application to Libre office; hence I need Help on the same. We have been
> using a survey kind of tool which is developed in Excel to be converted in
> to Libre office. Can anybody advice us how we go about it. It has to work
> on all the platforms. Please advice.
>
> If there is anybody (a consultant) in around Bangalore. Who can support us
> are welcomed. Look forward for your support at the earliest.
>
> --
> --
> Thanks ,
> *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> Bangalore - 560027*|***|***www.janalakshmi.com**|*
> *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Need urgent support in Libreoffice writer integration

[Gabriele Ponzo]

It is possible via the command line with --headless option.
What you found should be still valid today.

By the way, as Pedro said, this is community mailing list. Thus help is
given on a volunteer basis.
If you need professional and quick support you should consider a paid
service indeed.

There are also other businesses and professionals available, as CIB or
Studio Storti for example.

You can get a list of certified people and companies here:
https://www.documentfoundation.org/certification/migrators/
https://www.documentfoundation.org/certification/developers/

---
Gabriele Ponzo

2015-11-18 13:03 GMT+01:00 Pedro <pedl...@gmail.com>:

> Harpreet Singh wrote
> > I am working in High Court of Punjab and Haryana at Chandigarh (India).
> > High Court Punjab and Haryana, Chandigarh is a statuary and
> Non-profitable
> > organization of India.
> >
> > We need to integrate Libreoffice Writer with Web Browser (ie. in PHP).
> >
> > I personally have searched for online help to run Libreoffice Writer in
> > Server Mode. I found the last updated article on this concern was in
> 2013.
>
> I think that currently it is not possible to run LibreOffice in Server
> Mode.
>
> However if you need it urgently you could get this paid service from
> Collabora
> https://www.collaboraoffice.com/
>
> Hope this helps...
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Need-urgent-support-in-Libreoffice-writer-integration-tp4166646p4166657.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [BUG] Problem manifesting in sum function

[Gabriele Ponzo]

This list doesn't allow attachments, so please put it on some temporary
internet storage service.

I guess that all the values in the formula are stored in cells like let's
say:
A1 stores t1
A2 stores t2
A3 stores t
A4 store c
A5 stores k
Would it be correct?

By the way please remember to always supply the operating system you are
working on, the bits of it and of LibreOffice (may differ in Windows).

I'd like to try but I'll have to find a LO 4.4.3.2 (which probably is still
the default for Ubuntu 14.04?)
Il 10/giu/2016 07:12, "Alec Teal"  ha scritto:

> Hello there,
>
> I have a problem with a brand new spreadsheet, v 4.4.3.2, the sum version
> isn't recalculating, even if I press f9 (to force a recalculation)
>
> Any blank cells are just that, blank, the values I expect to be summed are
> numeric, weirdly it works when the left-most column is positive. The
> leftmost column and the sum columns are being graphed.
>
> Yet for the left column being greater than zero, all works fine.
>
> I think there may be a dodgy optimisation in play and I'm happy to help
> you find it, first though has anyone ever dealt with it?
>
> Reproducing:
> The value cells are of the form:
>
> if(t1+t2/60 < t, 0,  c e ^ -k(t-t1-t2/60) )
>
> This is the result of solving the differential equation dThing / dt = -k
> Thing, where the thing happens instantaneously at time t1:t2 (t2 in minutes)
>
> I'm then trying to sum over multiple events, but the sum column isn't
> updating for negative time, BUT the value column is.
>
> Alec
>
> Screenshot for proof.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem

[Gabriele Ponzo]

This list doesn't allow attachments. So we couldn't see anything.

From what you write it sounds like a virus… but I have really little to no
clues.

---
Gabriele Ponzo

2016-01-15 16:58 GMT+01:00 Doreen Howes <doreen_ho...@btinternet.com>:

> I am not sure whether this is the correct address to use but, if not,
> perhaps you could forward it on to somebody who can help me sort out my
> problem.  I attach a screenshot of an error message I am getting when
> trying to open a number of my documents with various endings, e.g. odt,
> htm, eml.  C directory is of course the one normally used so I cannot
> understand what is going wrong.  Any advice would be much appreciated.
>
> Doreen Howes
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice git repository!

[Gabriele Ponzo]

In not (yet) a developer, but I'm sure we'll have our good reasons :)

Anyway you'd probably have to write on Dev list for such topics.

I'll try to forward your message to someone who knows those reasons better
than me.
Il 12/feb/2016 08:30, "Mihuleac Sergiu"  ha
scritto:

> Hi!
>
> I wanted to know why LibreOffice doesn't uses GitHub to maintain their
> source code. I personally wanted to start contributing but after I saw
> it wasn't on GitHub i started to think twice. I believe this is a
> serious drawback.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Selection list

[Gabriele Ponzo]

What's the question?

---
Gabriele Ponzo

2016-01-28 10:23 GMT+01:00 RB <radio...@mtu-net.ru>:

> Hi!
>
> How to edit selection list in the LibreOffice Calc cell
> which contains previously entered values by the right mouse button.
>
>
> Mic
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Impress Congratulations

[Gabriele Ponzo]

Hi Jorge, I'm not a developer but I want to say thank you because it's
always appreciated when people gives such positive feedback.

Gracias muchissimas.
Il 17/apr/2016 18:42, "jorge"  ha scritto:

> Hi all:
>
> In my actuals labors I haven't used frecuently Impress to make a
> presentation, ... but I run Impress 5.1.2.2 on Ubuntu Beta 16.04 to know
> how is at this momment and find that the people (Specially programmers)
> has made  (Has or have made ?) a great and finest job to improve it.
>
> I really grateful with them, thank you so much !
>
> --
> Atentamente,
>
> Jorge Rodríguez
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Date field in a spreadsheet

[Gabriele Ponzo]

Il 27/lug/2016 17:52, "Mike Scott"  ha scritto:
>[...]
> Is there any (good) reason Calc doesn't have the same "Insert|Field" menu
as Writer? I do dislike inconsistencies like this.
>
Just because in a spreadsheet EVERYTHING is a field and there are so many
values you can recall that it's impossible to list them in a contextual
menu.

As reported you may insert them easily in heading or bottom of printing
area, where makes more sense to have such common fields as the current date.
>
>
> --
> Mike Scott (unet2  [deletethis] scottsonline.org.uk)
> Harlow Essex England
> "The only way is Brexit" -- anon.
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] no middle dots

[Gabriele Ponzo]

Il 19 feb 2017 8:17 PM, "Ann Must" <forannm...@gmail.com> ha scritto:


  if i open a page, i don't see anything that
says Tools.


As said by the other user, preferences are under LibreOffice menu, close to
the Apple symbol. I suppose you know that in MacOs the menu bar is on the
very first line on the top of the screen, detached from the program window.
I also suggested shortcut CMD + , to get there quickly and check what's
selected to be visible.

just pictures--well markings of the function. i'm so new i
can't make a screenshot here, what a pity.


The shortcut for screenshot is SHIFT + CMD + 4 (if I'm not wrong, I'm still
on mobile phone :)


there r lot of those functions,
one fancier than other--i think i don't need 4/5 of them. yes, the
function-marker looks like P in mirror--the same it was in Linux-LO,
Windows and everywhere else.


Well, it was just to understand if we were talking about the same thing.





annmust.com

On 19 February 2017 at 21:13, Ann Must <forannm...@gmail.com> wrote:

> it's LibreOffice_5.3.0_MacOS_x86-64.dmg , so it claims on the file.
> downloaded it from https://www.libreoffice.org/get-help/install-howto/os-
> x/ and did everything it instructed. if i open a page, i don't see
> anything that says Tools. just pictures--well markings of the function.
i'm
> so new i can't make a screenshot here, what a pity. there r lot of those
> functions, one fancier than other--i think i don't need 4/5 of them. yes,
> the function-marker looks like P in mirror--the same it was in Linux-LO,
> Windows and everywhere else.
>
>
>
>
> annmust.com
>
> On 19 February 2017 at 15:47, Gabriele Ponzo <gpo...@gmail.com> wrote:
>
>> That's what I was meaning, but I'm on mobile phone and just have to rely
>> in
>> my memory ;)
>>
>> Il 19 feb 2017 2:41 PM, "Robert Funnell" <robert.funn...@mcgill.ca> ha
>> scritto:
>>
>> > Interesting. I didn't know about the option of turning off the display
>> of
>> > some of the non-printing characters. Thanks. I found it under Tools
>> >
>> >> Options > LibreOffice Writer > Formatting Aids > Display of.
>> >>
>> >
>> > On Sun, 19 Feb 2017, Gabriele Ponzo wrote:
>> >
>> > I guess the button you pressed is the mirrored P one.
>> >>
>> >> In this case it looks really a weird behavior.
>> >>
>> >> What version of LO are you using?
>> >>
>> >> Sometimes I had such problems too, but with Tab symbol...
>> >>
>> >> Another thing you could try to check is on the settings (CMD + ,):
>> there
>> >> is
>> >> a section where you can specify what to see and what not when you
>> activate
>> >> the "non printable symbols" functionality.
>> >>
>> >> Il 19 feb 2017 12:58 PM, "Ann Must" <forannm...@gmail.com> ha scritto:
>> >>
>> >> hi!
>> >>
>> >> i'm a (very) new macbook user & as such ignorant. also, i've to
>> complete a
>> >> book of mine before handing it over to publisher. in TextEdit, there
>> seems
>> >> not to be a shorter-than-paragraph highlighting possibility (confirmed
>> by
>> >> lots of comments), so i downloaded .DMG file from
>> >> https://www.libreoffice.org/get-help/install-howto/os-x/ site. now i
>> can
>> >> highlight whatever i want, but i can't activate the so-called 'middle
>> >> dots'--empty-spaces-marker between words and other units. but i badly
>> need
>> >> to see them because the book will be published from the
manuscript-file
>> >> and
>> >> i wouldn't count on editor to do such fine work. when i press the icon
>> >> that
>> >> i know to be for that purpose, it only displays the enter-marks.
>> >> i've been using LibreOffice for years while on my old Linux-based
>> laptop
>> >> (and was in this list too, now subscribed anew), and that manuscript
>> was
>> >> written in LibreOffice Writer. i mention it to illustrate i know a
>> thing
>> >> or
>> >> two about LOWriter.
>> >> i trust it's something easy that just doesn't leap to mind!
>> >>
>> >> regards
>> >> 
>> >>
>> >
>> > --
>> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> > ubscribe/
>> > Posting guidelines + more: http://wiki.documentfoundation
>> .org/Netiquette
>

Re: [libreoffice-users] no middle dots

[Gabriele Ponzo]

I guess the button you pressed is the mirrored P one.

In this case it looks really a weird behavior.

What version of LO are you using?

Sometimes I had such problems too, but with Tab symbol...

Another thing you could try to check is on the settings (CMD + ,): there is
a section where you can specify what to see and what not when you activate
the "non printable symbols" functionality.

Il 19 feb 2017 12:58 PM, "Ann Must"  ha scritto:

hi!

i'm a (very) new macbook user & as such ignorant. also, i've to complete a
book of mine before handing it over to publisher. in TextEdit, there seems
not to be a shorter-than-paragraph highlighting possibility (confirmed by
lots of comments), so i downloaded .DMG file from
https://www.libreoffice.org/get-help/install-howto/os-x/ site. now i can
highlight whatever i want, but i can't activate the so-called 'middle
dots'--empty-spaces-marker between words and other units. but i badly need
to see them because the book will be published from the manuscript-file and
i wouldn't count on editor to do such fine work. when i press the icon that
i know to be for that purpose, it only displays the enter-marks.
i've been using LibreOffice for years while on my old Linux-based laptop
(and was in this list too, now subscribed anew), and that manuscript was
written in LibreOffice Writer. i mention it to illustrate i know a thing or
two about LOWriter.
i trust it's something easy that just doesn't leap to mind!

regards


--
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/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] no middle dots

[Gabriele Ponzo]

That's what I was meaning, but I'm on mobile phone and just have to rely in
my memory ;)

Il 19 feb 2017 2:41 PM, "Robert Funnell" <robert.funn...@mcgill.ca> ha
scritto:

> Interesting. I didn't know about the option of turning off the display of
> some of the non-printing characters. Thanks. I found it under Tools
>
>> Options > LibreOffice Writer > Formatting Aids > Display of.
>>
>
> On Sun, 19 Feb 2017, Gabriele Ponzo wrote:
>
> I guess the button you pressed is the mirrored P one.
>>
>> In this case it looks really a weird behavior.
>>
>> What version of LO are you using?
>>
>> Sometimes I had such problems too, but with Tab symbol...
>>
>> Another thing you could try to check is on the settings (CMD + ,): there
>> is
>> a section where you can specify what to see and what not when you activate
>> the "non printable symbols" functionality.
>>
>> Il 19 feb 2017 12:58 PM, "Ann Must" <forannm...@gmail.com> ha scritto:
>>
>> hi!
>>
>> i'm a (very) new macbook user & as such ignorant. also, i've to complete a
>> book of mine before handing it over to publisher. in TextEdit, there seems
>> not to be a shorter-than-paragraph highlighting possibility (confirmed by
>> lots of comments), so i downloaded .DMG file from
>> https://www.libreoffice.org/get-help/install-howto/os-x/ site. now i can
>> highlight whatever i want, but i can't activate the so-called 'middle
>> dots'--empty-spaces-marker between words and other units. but i badly need
>> to see them because the book will be published from the manuscript-file
>> and
>> i wouldn't count on editor to do such fine work. when i press the icon
>> that
>> i know to be for that purpose, it only displays the enter-marks.
>> i've been using LibreOffice for years while on my old Linux-based laptop
>> (and was in this list too, now subscribed anew), and that manuscript was
>> written in LibreOffice Writer. i mention it to illustrate i know a thing
>> or
>> two about LOWriter.
>> i trust it's something easy that just doesn't leap to mind!
>>
>> regards
>> 
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] middle dots

[Gabriele Ponzo]

If I'm not wrong, this mailing list shouldn't accept attachments.

So you should put it on some server and then share the link :(

Il 19 feb 2017 9:58 PM, "Ann Must"  ha scritto:

> i don't know if i sent the screenshot of the open LOWriter i managed to
> take only to Brian or to the list, so i attach it here once more to be sure
>
>
>
> ann
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] no middle dots

[Gabriele Ponzo]

By the way, the menu bar changes upon the window selected ;)

Il 19 feb 2017 10:12 PM, "Ann Must"  ha scritto:

> it begins to seem like something serious  now
>
>
>
>
> annmust.com
>
> On 19 February 2017 at 23:09, Ann Must  wrote:
>
> > new development: there was LibreOffice in the top bar when my work was up
> > open! jeez, it comes and goes, i may swear it wasn't there B4. sadly, it
> > doesn't solve my problem, as in the Preferences -- Formatting Aid the
> Space
> > dot was already checked. i unchecked it, then checked again--no change!
> >
> >
> >
> >
> >
> > On 19 February 2017 at 22:45, Ann Must  wrote:
> >
> >> i was notified of a new message but can't find it! managed to make a
> >> screenshot:
> >>
> >>
> >>
> >>
> >> annmust.com
> >>
> >> On 19 February 2017 at 22:20, Ann Must  wrote:
> >>
> >>> there are System Preferences under Mac, but no LibreOffice there.
> >>>
> >>>
> >>>
> >>>
> >>> annmust.com
> >>>
> >>> On 19 February 2017 at 22:16, Ann Must  wrote:
> >>>
>  no, it's not there. no LibreOffice there.
> 
> 
> 
> 
>  annmust.com
> 
>  On 19 February 2017 at 22:13, Brian Barker  >
>  wrote:
> 
> > At 21:53 19/02/2017 +0200, you wrote:
> >
> >> not that i see of :)
> >>
> >
> > Not in the LibreOffice window but at the top of the screen. Do you
> not
> > see "LibreOffice" there, as in this picture?
> > http://3.bp.blogspot.com/-_ytCD_uIoeE/T7JI0t88ZqI/DB
> > s/2KMCorY4sxk/s320/calc_macosxppc%255B2%255D-712094.png
> >
> > Click that: do you not see "Preferences"?
> >
> > Otherwise, is it in the Apple menu??
> >
> > If you choose to use a peculiar Mac, you have to get used to its
> > peculiarities!
> >
> > Brian Barker
> >
> 
> 
> >>>
> >>
> >
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: limited undo.

[Gabriele Ponzo]

To be honest, I believe that a proper use of Writer could avoid this
"problem".

What I mean is that probably it could be enough to delete word by word,
using CTRL key together with BackSpace or Delete key. In this way it should
take one step of undo per each word, instead of a single character.

Also consider selecting and THEN delete. For example you could use Shift
with Home and End keys or with CTRL and arrows keys...

Word processing IS NOT exactly like using a typewriter ;)

Il 03 set 2016 17:16, "m.a.riosv"  ha
scritto:

> Since 5.1 undo step are available only into the expert configuration
> Menu/Tools/Options/LibreOffice/Advanced -  TOpen expert configuration.
> Verify if steps value is enough, default value is 100.
>
> 
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> limited-undo-tp4192509p4192514.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: limited undo.

[Gabriele Ponzo]

2016-09-03 20:02 GMT+02:00 Xen <l...@xenhideout.nl>:

> […]
> They are not grouped together like in other applications.
>
> Ok, I got it now.

Sorry for my misunderstanding :)
---
Gabriele Ponzo


>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] dsum

[Gabriele Ponzo]

This list is meant to be written in English ;)

Il 26/ago/2016 08:45, "Istvan Toth"  ha scritto:

> Guten Morgen,
> ich kann die dsum Function nicht richtig Parameter geben, immer kann ich
> Fehler bekomman,
> Was kann ich nicht richtig eingeben?
> Mfg
> ti
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/dsum-
> tp4191752.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Version 5.2.1.2 Questions

[Gabriele Ponzo]

Il 1 dic 2016 5:07 PM, "Ricardo" <rgb.m...@openmailbox.org> ha scritto:

El 2016-12-01 00:02, Dave Liesse escribió:

> I'm noticing some behavior recently that I don't like.  When I
> installed v5.2.1.2, though, I seem to have eliminated all my existing
> profile information so I'm hoping that on the first item, at least,
> there's just a setting that I haven't been able to find.
>
> 1.  In Writer, I keep seeing "balloon" spelling suggestions. Can't
> click on them to do anything, so very annoying.  Any way to turn them
> off?  I haven't found anything in the options that does this.
>

This seems to be the "word completion" utility. See at Tools → Autocorrect
→ Autocorrect options and on the last tab disable the autocompletion.


By the way it can be a really useful feature. To use it, you just have to
press ENTER to confirm the suggested word or continue typing if that's not
what you need. (Or probably you can press ESC too,  I can't remember and
I'm on the smartphone now). Please consider learning the keyboard use:
you'll see that many more things can be done and about 10 times faster ;)





> 2.  Also in Writer, using an arrow to move up or down is not always
> placing the cursor in the correct place on the second line.  For
> example, I type a line and, at the end, press up-arrow; instead of the
> cursor being at the end of that (shorter) line, it's at a seemingly
> random location within the text.  For another example, if the cursor
> is in the middle a line and I press up-arrow the cursor is then at the
> end of the second (longer) line.  I haven't been able to discern a
> pattern.  Is this a known issue?  I'm not familiar enough with the bug
> reporting system to find it.
>

I've seen that behaviour too. AFAIK it is present on all 5.x versions.


I've never experienced such a behaviour in any platform (Linux, Mac or
Windows).

Have a nice Sunday,
Gabriele Ponzo.


Regards,
Ricardo




> Since it can make a difference, I'm working in Windows 7 Professional
> 64-bit.
>
> Thanks for any insight anyone can provide!
>
> Dave
>

-- 
Il mio blog in italiano: https://ilpinguinoscrittore.wordpress.com/
Mi blog en español: https://elpinguinotolkiano.wordpress.com/


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Problems exporting and importing a dialogue

[Gabriele Ponzo]

What do you mean with Dialogue?

I can't understand what are you talking about :(

It may be a feature unknown to me...

Il 3 gen 2017 5:16 PM, "ptoye"  ha scritto:

I don't think you can simply copy and paste an entire dialogue. I tried it
and it didn't work.



-
Peter
--
View this message in context: http://nabble.documentfoundation.org/
Problems-exporting-and-importing-a-dialogue-tp4204239p4204267.html
Sent from the Users mailing list archive at Nabble.com.

--
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/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Indendet paragraphs with names, hints or comments at the left side?

[Gabriele Ponzo]

What Ricardo reported is something I never miss to teach at my trainings.

I add that the tabulation is not required as the paragraph margin (3cm in
that example) is an implicit tabulation itself.

Lists function uses the same technique, since automation can't invent magic
solutions but just do something you could do manually.

Anyway the idea of customizing list to have a name for each level is really
interesting indeed.

In that way you could just switch among people with tabulations and avoid
to write their names every time.

I hope to remember it when I'll have some time to test it!

Il 15 ago 2017 7:29 PM, "Bruce Byfield"  ha scritto:

> On Tuesday, August 15, 2017 2:03:06 PM PDT Dennis Heuer wrote:
> > Hello,
> >
> > I am trying to write a protocol- or storyboard-alike document in which
> > the paragraphs are indented and a name is put before the paragraphs
> > (like a bulletin list with a text-field instead of the bullet.) I tried
> > several ways to make this work without using cumbersome tables...
> >
> > Actually I'd want indentions to be remembered across linebreaks. 
> > and - would hop over the division borders forth and back.
> > That would be easiest to use...
> >
> > ...Is there another way? At the moment I use tabs and push every new
> > line to proper position. But changing the text means reformating it :(
>
> The Marginalia frame style might help you. It will require some setup to
> get
> the indentation right.
>
> --
> Bruce Byfield 604.421.7189 (Pacific time)
> Writer of "Designing with LibreOffice"
> http://designingwithlibreoffice.com/
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Indendet paragraphs with names, hints or comments at the left side?

[Gabriele Ponzo]

Indeed this is the right and canonical way to do that (as I use to teach :)

Could you link a screenshot or the document somewhere to analyze your issue?

Il 16 ago 2017 12:47 AM, "Dennis Heuer" <
e...@verschwendbare-verweise.seinswende.de> ha scritto:

> Hello,
>
> On Tue, 15 Aug 2017 15:41:14 +0200
> Ricardo Berlasso  wrote:
>
> > You can always define tab stops on a paragraph style level. The
> > "trick" goes like this:
> >
> > 1- Define a paragraph style with "space before" at, say, 3cm, a
> > negative indent of -3cm (both under Space and and indenting) and a
> > left aligned tab stop at 3cm (under Tabs)
> >
> > 2- On a paragraph with that style applied, type the Name, press tab
> > (only once) and start typing :) You'll get something like this
> >
> > https://elpinguinotolkiano.files.wordpress.com/2016/12/tab-tabla.png
> >
> > Each time you start a new paragraph you only need one tab stop to get
> > the text aligned to the desired "margin".
> >
> > Regards,
> > Ricardo
>
> I tried this, and it works nice even with -. However,
> when (and only) the first line breaks, the whole paragraph slips two
> lines below the name
>
> regards,
> -
> Dennis Heuer
> e...@verschwendbare-verweise.seinswende.de
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Gabriele Ponzo]

From my experience Ubuntu Mate is really UNSTABLE (sadly!). That's why I
use to install Linux Mint MATE to my customers.

To install LibreOffice's official PPA follow this link, please.
https://wiki.ubuntu-it.org/Ufficio/LibreOffice

Just below: "Utilizzare versioni più recenti"

Cheers.

---
Gabriele Ponzo

2017-07-11 9:48 GMT+02:00 Paolo Del Romano <delrom...@gmail.com>:

> 2017-07-11 1:11 GMT+02:00 Steve Edmonds <steve.edmo...@ptglobal.com>:
> >
> >
> > There are some memory consumption bugs with LO but it might take some
> time
> > to notice it with 14GB RAM.
> > I have 32GB and it is usually a few weeks before I start noticing.
> >
> > There is this older thread similar.
> > http://nabble.documentfoundation.org/Slow-response-time-with-Calc-
> td4202227.html
> > You could try updateing to LO 5.2
> > steve
>
>
>
> Exact. The thread that you have shown shows just a case like mine. So
> I think the problem is in Ubuntu Mate
> Thank you
> Paolo
>
>
>
>
> --
> Paolo Del Romano
> delrom...@gmail.com
> PEC: paolo.delrom...@pec.commercialisti.it
> cell. 327-3504844
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Gabriele Ponzo]

I'm on the smartphone at the moment, but I'm quite sure the UI does list
the conditional formatting existing on a sheet or in a file.

It should be in a specific sub menu item to manage such feature.

I clearly remember from my last lessons (I'm a teacher of LO) that there is
a dialog window showing them all.

Isn't it enough for your need?

Il 8 lug 2017 10:57 PM, "Jean-Francois Nifenecker" <
jean-francois.nifenec...@laposte.net> ha scritto:

> Hi,
>
> (official LibO 5.x under win7 and Linux Debian 9)
>
> I'm developping in a corporate environment a number of spreadsheets using
> Calc. In many of those, I'm using conditional formatting, sometimes quite
> heavily.
>
> As I want to precisely document the ins and outs of the spreadsheets for
> the users and future maintainers, I'm looking for a way to list those
> conditional formattings.
>
> Any hint would be appreciated about a way to do this, which means with
> macros, of course, as the UI doesn't seem to give any other way. I haven't
> found any hint in the API but might certainly have 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-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Gabriele Ponzo]

Now I got what you meant, sorry.

And thanks to Regina for pointing out what I meant and the solution for
your need.



Il 9 lug 2017 8:37 AM, "Jean-Francois Nifenecker" <
jean-francois.nifenec...@laposte.net> ha scritto:


...


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.


Please consider filling it in bugzilla as feature request, after a quick
look if someone else already did it.


Thanks again,
Cheers from France,
-- 
Jean-Francois Nifenecker, Bordeaux


I've never been there, but I've been told it's a beautiful area.
Probably one of the few still missing to visit in France for me. Hope to
come sooner or later ;)




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Can I embed ODB Database file in Writer document?

[Gabriele Ponzo]

I haven't tested yet the embedding mail merge, but it could somehow be the
solution...

It's a matter of knowing better the requirements and do some testing.

Il 25 lug 2017 12:57 PM, "Alexander Thurgood"  ha
scritto:

> Le 24/07/2017 à 17:18, Joshua Kramer a écrit :
>
> Hi Joshua,
>
>
> > Is it possible to either have a small (less than 50 records) database
> > in a Writer document, or embed an ODB database right in the document
> > (instead of having it be in an external file)?
> >
>
> No and no, respectively.
>
> From what I understand, it is now possible to have a mailmerge Writer
> document that contains the data referenced by the mailmerge stored
> within the Writer document. Whether or not this successfully transfers
> over to another machine is something I haven't tested.
>
>
>
>
> > I have a document that has two different views of the same data.
> > Right now I'm doing everything by hand, which is error-prone and
> > inefficient.
>
> In what sense are you talking about views ? Do you mean actual database
> views in the classical DBA sense, or do you mean some graphical
> representation of the data in a formatted Writer document ?
>
> > portable, i.e. if I want someone else to edit this file I can just
> > send one file containing both the writer document and the database.
> >
>
> So unless I have really misunderstood what it is you are attempting to
> achieve, you can already do this with just a single ODB file.
>
> The ODB file can contain a series of queries, views (in the DBA sense of
> the word), Writer forms displaying data either obtained from views or
> queries, and even reports. This file can be sent to other users who can
> then edit it to their heart's content.
>
>
> Alex
>
>
>
>
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Book

[Gabriele Ponzo]

Consider also using master documents (.odm). Its styles overrides the one
on the single documents embedded in it.

Il 25 mag 2017 4:36 AM, "toki"  ha scritto:

> On 05/24/2017 11:56 PM, Brian Grawburg wrote:
>
> >There are several different type faces, including Greek, which may slow
> things down.
>
> The only slow down is from applying the appropriate styles.
> My recommendation is to use language specific styles.
>
> > I've also wondered about not using LibreOffice and using Scribus instead
> because the documents are so large.
>
> 177 pages isn't that many.
>
> The time lag is usually due to either insufficient RAM or an excessive
> number of styles - both character and paragraph, or both.
>
> jonathon
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Remembering last used template

[Gabriele Ponzo]

From what I can remember (I'm writing from smartphone), when the template
selector is open, the default type is the same of the file you were
editing, but in the combo box there are all other types, including a
specific "all" item at the top, if I'm not wrong.

Il 3 mag 2017 2:19 PM, "KT"  ha scritto:

> I recently upgraded from LO 5.2x to 5.3x and notice that it no longer
> remembers the last used template. It appears the behavior is now to default
> to the type of document currently open, e.g.:
>
> If I have a spreadsheet open, New->template only shows spreadsheet
> templates.
> If a text file is open, New->template shows text document templates.
>
> I prefer the old behavior because 99% of my template use is with text
> documents but I often have a spreadsheet open at the same time. This means
> I
> have to do extra clicks I didn't have to do before to get the list of text
> templates.
>
> Was this an intentional change and, if so, is there any way to get the old
> behavior back so it just remembers the last template I used and
> New->template defaults to that? Or is there an option to show all templates
> for all document types? That would work, too.
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> Remembering-last-used-template-tp4213606.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Query

[Gabriele Ponzo]

Sure, please have a look here:
http://tdf.io/joinus

And feel free to ask ;)

Il 13 feb 2018 6:27 PM, "Sourabh Pruthi"  ha
scritto:

> Hello I am new to LibreOffice can I be presented a guide to contribute to
> LibreOffice
>
> --
> 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/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Issue in refer footnote display

[Gabriele Ponzo]

It's really strange...

The quickest way I see could be applying apex formatting to the number, but
it's not a final solution.
What if you try with a new document?
---
Gabriele Ponzo


Il giorno lun 29 apr 2019 alle ore 12:56 Valdomiro  ha
scritto:

> The formatting of the footnote index was lost (not the formation of the
> footnote, but the index that refers to the footnote).]
>
> e.g. Inserting a footnote the number does not stay above the character as
> usually occurs.
>
> <
> http://document-foundation-mail-archive.969070.n3.nabble.com/file/t495763/erro_libre.jpg>
>
>
> How to solve?
> Thank you
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Issue in refer footnote display

[Gabriele Ponzo]

De nada :)

Il lun 29 apr 2019, 19:45 Valdomiro  ha scritto:

> Yes, it's really strange.
>
>
> I copied and pasted into a new document and the formatting was normal, no
> problem.
>
> Thanks you!
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] OpenFest 2019 - call for participation - call for volunteers

[Gabriele Ponzo]

If nobody else is willing to go, I could do it.

Please let me know if it's ok, so I can file a CfP.
---
Gabriele Ponzo


Il giorno lun 7 ott 2019 alle ore 13:55 Marina Latini <
marina.lat...@libreoffice.org> ha scritto:

> Dear community,
> the "OpenFest 2019" will take place on the 2nd and 3rd of November,
> 2019, in the "John Atanasoff" forum in Sofia Tech Park.
> https://www.openfest.org/2019/en/
>
> The call for participation will close tomorrow, October 8th 2019 but you
> can still submit your proposals here:
> https://cfp.openfest.org/?locale=en
>
> Our community will also have the possibility to share a booth with the
> openSUSE community.
> If you are planing to attend the conference and if you would like to
> represent our Project and Community at the event, please, let me know.
> I'll coordinate the activities with the openSUSE community.
>
> ATB,
> Marina
>
> --
> Marina Latini
> IRC: deneb_alpha on Freenode
> GPG key "ID" 0xF010C774 - DAEC 51E7 4316 5FAE EAE0  F256 3DB8 2837 F010
> C774
> Better use 64-bit 0x3DB82837F010C774 here is why: https://evil32.com/
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] OpenFest 2019 - call for participation - call for volunteers

[Gabriele Ponzo]

In the meanwhile I applied for the two lectures I gave at LibOcon, just to
be on time.
I guess I can still cancel them, if someone doesn't want me to go there :)
---
Gabriele Ponzo


Il giorno mar 8 ott 2019 alle ore 18:10 Gabriele Ponzo 
ha scritto:

> If nobody else is willing to go, I could do it.
>
> Please let me know if it's ok, so I can file a CfP.
> ---
> Gabriele Ponzo
>
>
> Il giorno lun 7 ott 2019 alle ore 13:55 Marina Latini <
> marina.lat...@libreoffice.org> ha scritto:
>
>> Dear community,
>> the "OpenFest 2019" will take place on the 2nd and 3rd of November,
>> 2019, in the "John Atanasoff" forum in Sofia Tech Park.
>> https://www.openfest.org/2019/en/
>>
>> The call for participation will close tomorrow, October 8th 2019 but you
>> can still submit your proposals here:
>> https://cfp.openfest.org/?locale=en
>>
>> Our community will also have the possibility to share a booth with the
>> openSUSE community.
>> If you are planing to attend the conference and if you would like to
>> represent our Project and Community at the event, please, let me know.
>> I'll coordinate the activities with the openSUSE community.
>>
>> ATB,
>> Marina
>>
>> --
>> Marina Latini
>> IRC: deneb_alpha on Freenode
>> GPG key "ID" 0xF010C774 - DAEC 51E7 4316 5FAE EAE0  F256 3DB8 2837 F010
>> C774
>> Better use 64-bit 0x3DB82837F010C774 here is why: https://evil32.com/
>>
>> --
>> 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/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Libre Office for older laptop and margin changes

[Gabriele Ponzo]

Il ven 21 ago 2020, 23:33 charles meyer  ha scritto:

> I wanted to install Libre Officce for an older laptop so I was considering
> ver 6.4.0.3 (I have on a W10 laptop with an iCore 7 - so it;s newer.
>
> But I couldn't find that version on the libre download page.
>
> I found this
>
> https://www.libreoffice.org/donate/dl/win-x86/6.4.6/en-US/LibreOffice_6.4.6_Win_x86.msi
>
> Would that be similar in look and function?
>

You didn't mention the Operating System present on the old laptop, but as
Italo wrote, if it's able to run 6.4.0 it will likely run 6.4.6 as well.

BTW here you can find all releases:
https://downloadarchive.documentfoundation.org/libreoffice/old/


> My older Libre Office version on that older laptop doesn't have Page Style
> on it so I wanted to adjust margins and have no idea how you do that on an
> older version and figured I 'd just install the one above which will
> hopefully have Page Style For Margin changes.
>
> Your thoughts/suggestions are appreciated.
>

This is really weird, because page styles are in LibreOffice (Writer, I
guess you meant) from its first version, if I'm not wrong (but I'm pretty
sure of that).

You should find them under Format menu, or pressing F11 key.

>
> Thank you!
>
> Charles..
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Libre Office for older laptop and margin changes

[Gabriele Ponzo]

---
Gabriele Ponzo


Il giorno mar 25 ago 2020 alle ore 22:54 charles meyer <
reachmepl...@gmail.com> ha scritto:

> Hi Gabriel,
>
> My bad.
>
> It's running W7 Pro.
>
> But, that Libre Writer displays no Page Style under Format so I'll try the
> F11 key.
>

Really strange, but, anyway, did it work with F11?

>
> On my laptop running W10 Pro and can use 64 bit I have Libre 6.4.0.3.
>
> Could that run on a 32 bit laptop running W7?
>

No, a 64bit version won't run on a 32bit O.S.

>
> That index page deosn;t differentiate between 32 bit versions -vs- 64 bit
> versions?
>

If you open "win" folder, you'll find "x86" and "x86_64" subfolders, where
the first is 32bit. For instance have a look here:
https://downloadarchive.documentfoundation.org/libreoffice/old/5.4.7.2/win/
https://downloadarchive.documentfoundation.org/libreoffice/old/6.4.6.2/win/
https://downloadarchive.documentfoundation.org/libreoffice/old/7.0.0.3/win/

>
> How do I ascertain which Libre version will run on a 32 bit laptop?
>

On this page you can find system requirements:
https://www.libreoffice.org/get-help/system-requirements/

So Win7 (if you applied SP1) should be fine even for the last version.

>
> Thank you.
>

Let us know, replying to the list please.
Cheers,
GabrielE :)

>
> Best,
>
> Charles.
>
>
>
> -- Forwarded message -
> From: Gabriele Ponzo 
> Date: Sat, Aug 22, 2020 at 2:57 AM
> Subject: Re: [libreoffice-users] Libre Office for older laptop and margin
> changes
> To: charles meyer 
> Cc: LibreOffice-list 
>
>
> Il ven 21 ago 2020, 23:33 charles meyer  ha
> scritto:
>
>> I wanted to install Libre Officce for an older laptop so I was considering
>> ver 6.4.0.3 (I have on a W10 laptop with an iCore 7 - so it;s newer.
>>
>> But I couldn't find that version on the libre download page.
>>
>> I found this
>>
>> https://www.libreoffice.org/donate/dl/win-x86/6.4.6/en-US/LibreOffice_6.4.6_Win_x86.msi
>>
>> Would that be similar in look and function?
>>
>
> You didn't mention the Operating System present on the old laptop, but as
> Italo wrote, if it's able to run 6.4.0 it will likely run 6.4.6 as well.
>
> BTW here you can find all releases:
> https://downloadarchive.documentfoundation.org/libreoffice/old/
>
>
>> My older Libre Office version on that older laptop doesn't have Page Style
>> on it so I wanted to adjust margins and have no idea how you do that on an
>> older version and figured I 'd just install the one above which will
>> hopefully have Page Style For Margin changes.
>>
>> Your thoughts/suggestions are appreciated.
>>
>
> This is really weird, because page styles are in LibreOffice (Writer, I
> guess you meant) from its first version, if I'm not wrong (but I'm pretty
> sure of that).
>
> You should find them under Format menu, or pressing F11 key.
>
>>
>> Thank you!
>>
>> Charles..
>>
>> --
>> 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/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Gabriele Ponzo]

But in that case, I think it won't let you fill (or paste) ID field anymore.

I'm not sure, just memory recall, hope to be wrong.

Il gio 23 lug 2020, 05:59 Alan B  ha scritto:

> Hello Zed,
>
> I haven't used 6.4 much yet except with already existing databases. With
> 6.0 (on Ubuntu) it was required that there be an auto incrementing index
> field or the import would fail with messages like you describe.
>
> If your ID field is not set to auto increment modify the field property so
> it auto increments then try the import again.
>
> On Wed, Jul 22, 2020 at 11:35 PM zed  wrote:
>
> > Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate
> > I am trying to copy and paste a LibreOffice Calc file from that program
> > to Base.  Here is what I have done so far.
> >
> > Calc - created spreadsheet
> > A = ID (Default format)
> > B = Name (Default format)
> > C = Location (Default format)
> > D = Date - First (Format as DD MMM )
> > E = Date - Last (Format as DD MMM )
> >
> > Base:
> > Created a database named Reactors and created fields:
> > ID Interger [INTEGER]
> > Name   Text [VARCHAR]
> > Location Text [VARCHAR]
> > Gender Text [VARCHAR]
> > No. Number [NUMERIC]
> > Date - First Date [DATE]
> > Date - Last Date [DATE]
> >
> > Opened spreadsheet and highlighted columns  (as listed above)
> > (as a test I chose only Rows 1-6)
> >
> > Chose Copy and navigated to Database and clicked to Paste
> >
> >  From Menu presented, chose Append data (the default option)
> > clicked Next and unticked ID
> > clicked Create and following error message was displayed
> >
> > Warning.  Wrong data type:java.lang.IllegalArgumentException.
> >
> > Searched both Internet (in general) and LibreOffice website (in
> > particular) but found nothing to help.
> >
> > Obviously I am doing something wrong but I am unable to find the
> > error.All help will be very welcome.
> >
> > Zed
> >
> >
> > --
> > 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/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy
> >
>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] days since beginning of year

[Gabriele Ponzo]

You already have the answer, as you have used the YEAR function in your
previous message.
So YEAR(cell) will give you just the year from the date expressed in "cell".
---
Gabriele Ponzo


Il giorno lun 5 apr 2021 alle ore 03:46 James  ha
scritto:

> How do I get the start date to be dynamically the current year?
>
> Apr. 4, 2021 19:30:53 cspi...@ieee.org:
>
> > I assume you're asking about how to get the days since the beginning of
> the year given an existing date and that you're using LibreOffice Calc.
> With this in mind, here is an example:
> >
> > =DATEDIF("2020-12-31","2021-01-27","d")
> >
> > The resulting value in the cell will be 27.
> >
> > The first parameter is the starting date.  Middle parameter is the
> current date in question (I used Jan 27th in my example).  The third
> parameter is the interval Calc should use, which is days here, hence "d".
> Note that if you use 2020-01-01 as the start date, then the 27th day of
> January would actually only be the 26th day since Jan 1st, so you need to
> use a starting date of the last day of the prior year.
> >
> > Hope this helps!
> >
> >
> > On Sun, Apr 4, 2021 at 3:59 PM James  wrote:
> >> How do I get the number of days since the beginning of year?
> >>
> >>
> >> --
> >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org[
> users%2bunsubscr...@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/global/users/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Low windows

[Gabriele Ponzo]

Please consider subscribing Italian Mailing List, by writing an empty email
to:
users+subscr...@it.libreoffice.org
(just like you did with this one)

Il giorno lun 22 mar 2021 alle ore 08:28 roberto vecchi 
ha scritto:

> Hi!
> I have a problem with some type of menu, in writer is paragrafer menu, in
> calc is CTRL + 1 menu, for cells. I have a gaming PC, and i am an
> informatic prof. at school. I don't know why the windows do not respond for
> some second and after 20 or 30 seconds it's ok, it is low.. please help!
>

What version of Windows? And what of LibreOffice?
Does it happen with any other software?

Let us know here or on Italian list :)
---
Gabriele Ponzo

>
> Thanks so much,
> Roberto.
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Prevent Template Name Appearing in Document Title [SOLVED]

[Gabriele Ponzo]

Wow, I'm really glad to have been helpful, even in an indirect way like
this :)

Thank you for watching!
---
Gabriele Ponzo


Il giorno gio 23 set 2021 alle ore 17:29 Dave Barton 
ha scritto:

> On 16/09/2021 13:32, Dave Barton wrote:
> > Is there any setting available to prevent template names being
> > automatically added to the Title field of the file properties. This is
> > not the case for the "hard coded" default templates.
> >
> > I am fully aware of how to remove the template name from the Title
> > field, but I do not want to do this every time I open a new file based
> > on another template.
> >
> > TIA
> >
> > Dave
>
> Answering my own question. While watching Gabriele Ponzo's "Professional
> Templates" LiboCon presentation today, the realisation hit me that
> templates inherit ALL aspects of of the document from which they are
> created. The simple solution to my issue is to ensure that the "Title"
> field of the "File Properties" dialog is cleared before the template is
> saved.
>
> Apologies for the list noise.
>
> Dave
>
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] My Question About Security

[Gabriele Ponzo]

Your file is safe as long as it stays on your computer, but if you use some
Cloud storage such as OneDrive, DropBox or any other, we cannot grant it's
security.
And anyway, LibreOffice (usually) does not encrypt files. But yes, it does
not send them anywhere either, unless you ask it to do that.
---
Gabriele Ponzo


Il giorno gio 27 gen 2022 alle ore 09:52 NE NE  ha
scritto:

> Hi, My name is Hatice from Turkey.
>
> First of all, thank you for making free software available to people. And
> my question to you is:
>
> "When we use the programs included in your software, for example; When we
> write a document, no one but us can access this document, right? I mean our
> files should be protected on our computer. your program should not have
> online-like functionality."
>
> Can you please inform me about that issue.
>
> Have a nice day and I wish you good work...
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Adding Time in hours

[Gabriele Ponzo]

CTRL+1 opens the Cell Format dialog window. There, in "numbers" tab, you
have to choose "Time" on the left panel and the 4th format on the centre
panel ("876613:37:46" corresponding to [HH]:MM:SS format code).

That's it, it's not related to LibreOffice Calc but to SpreadSheets' usage
in general :)
---
Gabriele Ponzo


Il giorno gio 25 mag 2023 alle ore 12:31 .  ha scritto:

> In adding time of hours and minutes, when the total is greater than 24
> hours, the total reduces to minutes.  For example;
>
> 23hours 45 minutes
>
> PLUS
>
> 3 hours 15 minutes
>
> Total- 3 hours
>
> I need the sum total hours no matter if it's beyond 24.
>
>
> Thanks,
>
> Peter
>
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Can't open new version of LO

[Gabriele Ponzo]

Otherwise, at the end of the Download page, you can still choose a previous
version (like the one that was working for you, or one in the middle
between that one and the latest), download it and install it.

https://www.libreoffice.org/download/download-libreoffice/

If the version you'd like is not listed, there's also an "in the archive"
link, pointing at this page:
https://downloadarchive.documentfoundation.org/libreoffice/old/

There you can find ALL LO versions, from the very beginning of the project.

BUT before doing that, I'd suggest to check if currently installed version
is compatible with Windows 7 and in that case try running it in safe mode:
https://help.libreoffice.org/latest/en-US/text/shared/01/profile_safe_mode.html

I hope it has been useful, good luck.
---
Gabriele Ponzo


Il giorno lun 1 apr 2024 alle ore 17:45 Italo Vignoli 
ha scritto:

> When you hit the yellow DOWNLOAD button, the download starts in
> background without any visible activity on your screen. We suggest to
> open the browser DOWNLOAD page to check the status. Please do not close
> the browser until you are sure the download has finished.
>
> If the download does not start, please try with another server. To
> change server, you should click on the INFO link just below the yellow
> DOWNLOAD button, and select one from the list that you find in the page
> which opens after you click on the INFO link.
>
> You should also check that the download link starts with HTTPS, as
> otherwise the browser will not download the file. If this is not the
> case, please change the server based on the instructions from the
> previous paragraph.
>
> Please note that you can retry the download as many times as you want
> provided that you do not close the browser window before the download
> has completed. You can ignore the donation request, as donations are
> optional and help us to keep the project alive.
>
> If everything works properly, when the download has finished a window
> will open asking you to choose between executing the installer or saving
> the file on your hard disk. Please choose the second option, and save
> the file inside your DOWNLOADS folder.
>
> Then open the DOWNLOADS folder, and double click on the file (the name
> starts with LibreOffice, and ends with .MSI on Windows and with .DMG on
> macOS). Carefully follow the instructions on the screen until the end of
> the installation process.
>
> If everything works properly, LibreOffice will be installed properly and
> will show up in your menu (for Windows) or in your Applications folder
> (for macOS).
>
> Sorry for the long message. I hope this helps. Best regards.
>
>
> On 01/04/24 17:29, Bill Bauer wrote:
> > I was running version 7.4 & got a notice to download 7.6.6.3.  After
> > downloading & restarting my computer, when I click on the new version
> icon
> > on my desktop, the icon highlights but the program never opens.
> >  I am running Windows 7(yes I know it's a bit old & I am looking to
> > replace this computer) but I do need Libre Office to continue my work
> until
> > I can get the new computer.
> >  I would appreciate any advice.  Maybe deleting the program
> completely &
> > try downloading it again?  Please help now.
> >
> > Bill Bauer
> >
> --
> Italo Vignoli - it...@vignoli.org
> mobile/signal +39.348.5653829
> GPG Key ID - 0xAAB8D5C0
> DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0
>
>
> --
> 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/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy