[libreoffice-users] Re: Can't print directly with the toolbar print icon

[Pedro]

Hi Mark

You need to re-add the function Print Directly to your Toolbar.
Right-click on the Standard Toolbar, select "Customize Toolbar...", scroll
down to the Print button on the Right panel and check the box for the Print
Directly button under it so that it is displayed.
If the problem is not that it is un-selected, just add it from the Function
list on the left.

Hope this helps,
Pedro



--
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

[libreoffice-users] Re: Slide show sizes

[Pedro]

MR ZenWiz wrote
> Why did Impress blow it up so large and yet PP was able to shrink it
> just by loading and saving it, no changes?

Since both files (PPTX and ODP) are ZIP files with a different extension,
you can rename them and check which files each ZIP contains.
My guess is that ODP is storing un-needed font files. This has been reported
for years for ODT files
https://bugs.documentfoundation.org/show_bug.cgi?id=65353



--
Sent from: http://nabble.documentfoundation.org/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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Graphic with multiple curves

[Pedro]

Hi Marco

You need to rearrange the data to get what you want. You need a column for
each month (the month name will be used as the label for the line)

x,Jan,Fev
10,20,
15,30,
20,20,
5,,10
10,,15
30,,30

Then simply select all data and choose a XY plot with lines

Cumprimentos,
Pedro



--
Sent from: http://nabble.documentfoundation.org/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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Cursor position lost every time file is closed in 5.4.1

[Pedro]

MR ZenWiz wrote
> This used to be an occsaional problem with 5.3, usually just the first
> few times I opened a file.
> 
> Now it seems that every time I open a document, new or one I've been
> editing for a long time, it never remembers the cursor position and
> always comes up at the head of the file.
> 
> Is this a feature change or is there a switch I need to set?  I found
> nothing in help.

LibreOffice Developers decided to join the User name in early 5.3 versions.
Then because this was breaking up features (such as resumed editing) they
have returned to two fields but the user name was left joined.

You need to go to Tools > Options > User Data and fix your Name to separate
fields (First, Last)

Hope this helps.



--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
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

[libreoffice-users] Re: resume support on daily builds

[Pedro]

Hi


krishna-2 wrote
> is resume supported on daily builds at [ z ] ? at my present download
> speed it might take at least five days to complete ;)

Yes, the server supports resume downloads.

Regards,
Pedro



--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
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

[libreoffice-users] Re: help note icons broken

[Pedro]

Hi Carlo


carlo.strata wrote
> I just install LibreOffice 5.3.5.2 win64 - from the usual prerelases
> directory  - with the associated italian help pack and I see that the note
> icons in the help pages are all broken.

I get the same problem with version 5.3.5.2 x64 under Windows 7. I tested
with several help packs (including the English US for 5.3 and Portuguese PT
for versions 5.3, 5.2, 5.1 and 5.0)

I'm not sure if this has been broken for years in the Help packs...

Here is an image to help others find the problem

<http://nabble.documentfoundation.org/file/n4219722/Missing_icons.png> 

Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/help-note-icons-broken-tp4219685p4219722.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

[libreoffice-users] Re: LO Scolling problems under Windows.

[Pedro]

Dave-3 wrote
> Is anyone else experiencing a similar issue, or is there a known
> rendering problem in recent versions of LO?

LibreOffice has switched (don't know exactly which version) to OpenGL
rendering which is on by default in recent versions.

Go to Tools > Options and select on the left listing LibreOffice, View and
then uncheck "Use OpenGL for all rendering"

If this doesn't help, can you report a bug and append to it  one of the
documents that causes problems?



--
View this message in context: 
http://nabble.documentfoundation.org/LO-Scolling-problems-under-Windows-tp4218791p4218792.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

[libreoffice-users] Re: No version install on a Windows 7 domain joined machine

[Pedro]

Tanstaafl wrote
> When you join a machine to a domain, the 'Domain Admins' group is
> automatically added to the Local Administrators group on the computer
> that was joined. It has been this way forever (as long as I can
> remember), and is extremely useful, and is simply not a 'security issue'
> as you suggest.

Actually that is not true. At my workplace I have to manually add the domain
admin to the PC's admin group on each computer.

Maybe some setting was misconfigured by our IT but my point is you should
not assume everything everywhere works as you think it does.

Actually the OP already confirmed that the domain admin is also a local
admin so this could be a Windows 7 x86 specific bug (I have no problems with
any version of LibreOffice x64 on Windows 7 x64).



--
View this message in context: 
http://nabble.documentfoundation.org/No-version-install-on-a-Windows-7-domain-joined-machine-tp4218392p4218511.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

[libreoffice-users] Re: No version install on a Windows 7 domain joined machine

[Pedro]

Malcolm Moore wrote
> I am logged in as the domain administrator. 
> 
> What am I forgetting  ?

Is the domain administrator included in the Administrators Group for this
particular machine?



--
View this message in context: 
http://nabble.documentfoundation.org/No-version-install-on-a-Windows-7-domain-joined-machine-tp4218392p4218403.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

[libreoffice-users] Re: keep cell format in Calc

[Pedro]

Thomas Blasejewicz-3 wrote
> Good morning
> I have to work (translation) on an Excel file with two columns> Japanese 
> and an empty column where German has to be placed.
> "Naturally" (translation agencies just don't get it), everything is 
> formated for Japanese.

Could this be a limitation of the Excel export? You didn't mention if it is
MS XML (XLSL) or good-old binary XLS

Can you work in  ODS format (while you are translating) and then export as
XLS only before sending to your client?

If that works it is obviously a workaround (not a solution) and you should
report a bug at bugzilla (https://bugs.documentfoundation.org/).



--
View this message in context: 
http://nabble.documentfoundation.org/keep-cell-format-in-Calc-tp4215909p4215961.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

[libreoffice-users] Re: Referencing to a cell name on another sheet

[Pedro]

Johnny Rosenberg wrote
> So what is the proper way to handle this? How can I reference a cell name
> on another sheet?

Assuming you are referring to another Sheet in the same file, it does work
as you described (using version 5.3.2.2 x64 under Windows 10 x64)
Which OS, LO version are you using?

Here is an example that does work. Named range fps is in cell AA1
Named_range.ods
  



--
View this message in context: 
http://nabble.documentfoundation.org/Referencing-to-a-cell-name-on-another-sheet-tp4211608p4211618.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

[libreoffice-users] Re: Open XLS directly into LibreOffice 4.1 vs double clicking on it in Windows

[Pedro]

Hi John


John Meyer wrote
> I have LibreOffice set up at work to default open XLS files. When I do a 
> double click, it gives me the normal import options but otherwise goes 
> fine. If I try to directly open that file in LibreOffice Calc, however, 
> it kicks it out to Writer. Is this a known bug in LO?

Branch 4.1 was discontinued in May 2014
Even if the bug existed in that version maybe it is already fixed by now.

Please test if the problem still occurs in a current branch (preferably 5.3
or alternatively 5.2)
If your problem still occurs please report it in the Bug tracker (search for
an existing bug before reporting)
https://bugs.documentfoundation.org/

Thanks!
Pedro





--
View this message in context: 
http://nabble.documentfoundation.org/Open-XLS-directly-into-LibreOffice-4-1-vs-double-clicking-on-it-in-Windows-tp4210931p4211035.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

[libreoffice-users] Re: sorting in calc

[Pedro]

Gary Collins wrote
> Hello,
> Is there a character i can enter into a cell that will come *before*
> numbers in the sort order?
> I mean, before other cells that actually contain numbers rather than
> numerical strings

Any character that shows up before zero in Character Map (if you are using
Windows OS).
The very first character is ! but there are 14 others (e.g. #)

Hope this helps
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/sorting-in-calc-tp4209735p4209757.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

[libreoffice-users] Re: Calc a formula conundrum

[Pedro]

IGraham wrote
> I’m wondering if there is a simpler way of doing this

Use the function FIND to locate the word TO and then get all text after it
(100 characters should be enough...)

=MID(I5;FIND("TO";I5)+3;100)



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203p4199214.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

[libreoffice-users] Re: Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

[Pedro]

Hi Jurriaan

You can get any version you like from
http://downloadarchive.documentfoundation.org/libreoffice/old/

or simply the latest at
http://downloadarchive.documentfoundation.org/libreoffice/old/latest/win/

These files are guaranteed to be in working conditions. If you can not get a
working file from this server then you need to look for the problem
somewhere else (maybe your antivirus?)

I suggest that you use a download manager such as the FLOSS Free Download
Manager (http://www.freedownloadmanager.org/) to make sure your download is
100% complete.

Hope this helps!



--
View this message in context: 
http://nabble.documentfoundation.org/Downloads-impossible-and-latest-version-of-Firefox-not-recognized-by-captcha-connclusion-service-levo-tp4196366p4196467.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

[libreoffice-users] Re: Need someone to check a 5.2.x regression

[Pedro]

Bruce Hohl wrote
> In both cases the Format > Cells > Background > 'No Fill' did not work
> correctly per this bug report:
> https://bugs.documentfoundation.org/show_bug.cgi?id=101588 However,
> another
> tester did not find the problem on Windows 10. If you have 5.2.x install
> can you please check this:
> 
> To reproduce:
> 1 - Add background color to cell A1 and A3 but not cell A2.
> 2 - Select cells A1:A3
> 3 - Format > Cells > Background tab, Click 'No Fill', Click 'OK'.
> Cell background colors are not removed.
> This works in 5.1.x versions.

Answered and confirmed in the Bug Tracker.



--
View this message in context: 
http://nabble.documentfoundation.org/Need-someone-to-check-a-5-2-x-regression-tp4191257p4191270.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

[libreoffice-users] Re: v4 or later PDF Guides with bookmarks.

[Pedro]

Edwar Cifuentes wrote
> What I haven't been able to do is use the clickable index to quickly go 
> to where the chapters and different sections start.
> Do you by chance know how to this Pedro?

The clickable index works as expected in any viewer. The jpdfbookmarks
program is only supposed to be used to add bookmarks. If after adding the
bookmarks the index is not working in your PDF viewer as expected then it is
a bug. You can submit the bug to the jpdfbookmarks developers (but as I
mentioned it seems to be abandoned) or fix it yourself (if you know how to
code)

Alternatively you could try to run PDF X-Change Editor under Linux using
Wine (I am just an occasional Linux user so I have no idea how well this
works)

If that works then you can try something even faster: export the bookmarks
from the Calc 3.4 Guide and import it to the Calc 4.1 Since the manuals
should not be that different, you can have a perfect Calc 4.1 guide within a
few hours.

Disclaimer: I am no way affiliated with the authors of PDF X-Change Editor,
I'm just a happy user of a great free (but not open source) program (that
unfortunately is only available for the Windows platform)



--
View this message in context: 
http://nabble.documentfoundation.org/v4-or-later-PDF-Guides-with-bookmarks-tp4185212p4185471.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

[libreoffice-users] Re: v4 or later PDF Guides with bookmarks.

[Pedro]

Edwar Cifuentes wrote
> The fact that they have the capitalization and everything suggests that
> you 
> made them by copying and pasting and that it was indeed a very quick 
> process.
> 
> I'm jealous of that pdf software, I'll continue to search for 
> alternatives here...

It is even faster than that. Just select any text and press a hotkey and it
is added as a bookmark named after the select text.

If you do find a multi-platform Open Source program that does the same
please do share the information here.



--
View this message in context: 
http://nabble.documentfoundation.org/v4-or-later-PDF-Guides-with-bookmarks-tp4185212p4185355.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

[libreoffice-users] Re: v4 or later PDF Guides with bookmarks.

[Pedro]

Edwar Cifuentes wrote
>> In the spirit of open source, here is the Calc 4.1 manual in PDF with
>> bookmarks for the main chapters.
>> I added them all in under 2 minutes using the Free version of Tracker
>> Software's PDF-XChange Editor (available for Windows only)
>> Adding bookmarks is really simple: just select the text you want to show
>> on
>> the bookmark and press Ctrl+Shift+B (or type it manually). I only did the
>> top level chapters but the full index could be easily done...
> 
> Hey, thanks. I downloaded your file and I can't see the bookmarks neither
> in owncloud nor in evince (default linux pdf reader)
> I don't think there are free viewers in linux that allow you to make
> custom bookmarks like pdf xchange but I will check

In Owncloud, after loading the PDF, just click on the button on the top left
(Toggle Sidebar) and then on the Sidebar click on the second button from the
top left (Show Document Outline). Evince should have some option to display
bookmarks/outline...

You can try the Java based JPdfBookmarks under Linux...



--
View this message in context: 
http://nabble.documentfoundation.org/v4-or-later-PDF-Guides-with-bookmarks-tp4185212p4185280.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

[libreoffice-users] Re: v4 or later PDF Guides with bookmarks.

[Pedro]

Hi again


Edwar Cifuentes wrote
> Hello, when I download the PDF guides for calc 4 and 5 the documents 
> don't have bookmarks like the 3.4 version. Is it because they haven't 
> been added and you have to wait for them to be added, because the links 
> I used don't point to the latest version of the docs or because an 
> alternative to bookmarks is being used and my pdf viewer can't display it?

In the spirit of open source, here is the Calc 4.1 manual in PDF with
bookmarks for the main chapters.
I added them all in under 2 minutes using the Free version of Tracker
Software's PDF-XChange Editor (available for Windows only)
Adding bookmarks is really simple: just select the text you want to show on
the bookmark and press Ctrl+Shift+B (or type it manually). I only did the
top level chapters but the full index could be easily done...

https://cloud.openmailbox.org/index.php/s/heS4nmihNGttjUb
(unfortunately the file is too large to upload to the Nabble mailing list)

There is also a free and open source tool that does a similar job named
JPdfBookmarks (https://sourceforge.net/projects/jpdfbookmarks/) which as the
name implies requires Java but runs on any OS.
Unfortunately JPdfBookmarks seems abandoned and has the drawback that it
sets a fixed zoom level for each bookmark. Therefore jumping back and forth
between viewing the text and using the bookmarks could be unpleasant.

Enjoy!
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/v4-or-later-PDF-Guides-with-bookmarks-tp4185212p4185233.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

[libreoffice-users] Re: v4 or later PDF Guides with bookmarks.

[Pedro]

Edwar Cifuentes wrote
> Hello, when I download the PDF guides for calc 4 and 5 the documents 
> don't have bookmarks like the 3.4 version. Is it because they haven't 
> been added and you have to wait for them to be added, because the links 
> I used don't point to the latest version of the docs or because an 
> alternative to bookmarks is being used and my pdf viewer can't display it?

There is a clickable index (between pages 3 and 6 in the 4.1 guide) which
allows you to jump to any page in the document. This is not as efficient as
the bookmark/outline available in the 3.4 guides but it still works.
This was possibly an option taken by the editors to save time/work for the
volunteers? (I'm just guessing)

Hope this helps
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/v4-or-later-PDF-Guides-with-bookmarks-tp4185212p4185218.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

[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE

[Pedro]

Pedro wrote
> I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro
> x64 
> 
> (so it's not a Windows
> 

I meant it's not a Linux only problem.

Interestingly the problem also does NOT occur with version 5.1.3.2 under
Windows 10 Home x64



--
View this message in context: 
http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184927.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

[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE

[Pedro]

Hi Thomas


Thomas Boehm wrote
> I found an annoying bug (or is it a feature?) in Calc. When I create a
> new document in calc and fill column A in Sheet1 with text. Now I add
> Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as
> expected so far.
> 
> If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I
> copy it down until A100 or more everything turns UPPERCASE and I cannot
> change it.
> 
> I'm using LO 5.1.3.2 at the moment, but I observed this behavior in
> earlier versions too.
> 
> Am I doing something wrong or is this really a bug?

It is indeed a bug!

A very similar problem has been reported
https://bugs.documentfoundation.org/show_bug.cgi?id=99753

Maybe you can open a new bug report with your description? (it doesn't seem
to be exactly the same and developers are very picky)

I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro x64
(so it's not a Windows

Hope this helps
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184887.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

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

[Pedro]

charles meyer wrote
> Title case is this - Refinanced Loans On Three Separate Properties.
> 
> Under Change Case there is Toggle (just capitalizes), All caps. small
> case but no Title case listed.

Select the whole sentence and press Shift+F3 repeatedly. "Capitalize" will
capitalize every word of the sentence aka Title Case.



--
View this message in context: 
http://nabble.documentfoundation.org/Libre-Writer-Windows-Title-Case-tp4184292p4184537.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

[libreoffice-users] Re: Locked or missing files

[Pedro]

A wrote
> Some of those 
> files are /tmp files (example: attachments opened while I'm in 
> Thunderbird), which get deleted when the system reboots.

I also use Thunderbird under Windows 7 Pro. Re-opening LibreOffice (at least
with version 5.1.3.2) after Thunderbird as been closed (and the tmps have
been removed by Thunderbird on exit) doesn't show any temporary files in the
Recent list or in the Start Center.

I have no idea in which version this feature was added/fixed but it is
currently not an issue (at least under Windows)



--
View this message in context: 
http://nabble.documentfoundation.org/Locked-or-missing-files-tp4183448p4183487.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

[libreoffice-users] Re: Locked or missing files

[Pedro]

A wrote
> I get a lot of system crashes for a variety of reasons.  That means, I'm 
> constantly recovering files when I re-open LibreOffice.  Some of those 
> files are /tmp files (example: attachments opened while I'm in 
> Thunderbird), which get deleted when the system reboots.  When I restart 
> LO, it tries to recover those /tmp files which of course are gone 
> forever.  How can I tell LO to stop trying to recover those files and 
> permanently stop tracking them?

If you update at least to the 4.3 branch you will have the option to remove
any document from the recent list (I would recommend 4.4.7 which is the last
release in the 4.x tree)
If you want to stick with 4.2 you can use the History Master  extension
http://extensions.openoffice.org/en/project/history-master
After installing, close LibreOffice, reopen, click on Tools > Add-Ons >
History Master > Remove inaccessible items

Notice that documents in currently disconnected drives (such as an external
HDD) will also be removed.


A wrote
> Also, similar problem - I have a locked file.  While I can manipulate it 
> through the file system (mv locked file to save file, etc.) it would 
> certainly be nice if there were a way to force an unlock through LO.  Is 
> that a feature or does it need to be added?

I believe such an option would be useful (an "Unlock document" button). Can
you add an Enhancement request in https://bugs.documentfoundation.org ?



--
View this message in context: 
http://nabble.documentfoundation.org/Locked-or-missing-files-tp4183448p4183479.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

[libreoffice-users] Re: Libre Office for Androids

[Pedro]

Hi Tim


krackedpress wrote
> I asked the same question on the need of a office package for my tablet.
> 
> What I found out, for my 10 inch tablet, you really need an external 
> keyboard to use an Android Office package.
> 
> I too wait for LibreOffice to get an fully functional Android version.  
> While I wait, I will use the office package available - other than 
> Microsoft's Android office options.  Once LO has its version, then I 
> will have LO on Windows, Ubuntu Linux, and Android.

There is another option: get a free account at https://open365.io/ and use
LibreOffice 5.1.0.3 within your browser.

If you install the open365 Android application you will have two
synchronized copies of each document: 1 in your tablet and another on the
open365 cloud.

The good news: if your tablet breaks all your documents are safe. The bad
news: because LibreOffice is running in your browser you can only edit your
files when you are connected to the internet...

It is currently the closest you can get to having LibreOffice on an Android
tablet...

Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Libre-Office-for-Androids-tp4182935p4182989.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

[libreoffice-users] Re: configure external image editor

[Pedro]

Hi Felipe


Felipe T. Dorado wrote
>   what category or alternative does LO call when one clicks 
>   on the "editing image with an external editor"?
> 
> I hope some kind soul could point me to the proper email list where to ask
> or give some hint as to how to do it.
> Since I have come this far with this I'd like to finish it gracefully at
> least ; ) 

Apparently LibreOffice simply opens the image with the program associated to
the image type (could be png, jpg, etc) on your user preferences (at the OS
level)
This means that the menu option is not clear.

In fact the current "Edit with External Tool..." option seems like an
incomplete work. Even if you do Edit the image with the external program,
you will have to reinsert the edited image manually because simply closing
the external editor will not do that (as seems to be implied by the menu
option).

Therefore you have two options: you could consider this a Bug and request
the menu option to be renamed to the more accurate text "Open with
associated external program" OR you could do an Enhancement Request and ask
the developers to add an option to LibreOffice where the user defines the
path to an external editor (e.g. Gimp) which is actually used for editing.

Of course the second option involves a lot more work because it not only
requires to add that option to the Options dialog but would also require
that after editing the image, the modified image would be updated in the
document...

Curiously having an "Edit with External Tool..." option would seem that
there should be an Edit option (where LibreOffice's own Draw would used as
the logical Internal Tool)

Maybe in the future?

In any case, the place to report bugs or request enhancements is at
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice

Hope this helps...
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/configure-external-image-editor-tp4182475p4182579.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

[libreoffice-users] Re: Text Roation

[Pedro]

Phil wrote
> ive took a screen shots from windows and mac, with the problematic area?
> can anyone else re-create it on windows??

It's another OpenGL problem.

Go to Tools > Options, click on LibreOffice and View on the left tree and
then uncheck "Use OpenGL for all rendereing"

Close LibreOffice, open again.

You should report this bug at https://bugs.documentfoundation.org/ and use
keyword regression.



--
View this message in context: 
http://nabble.documentfoundation.org/Text-Roation-tp4182476p4182477.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

[libreoffice-users] Re: a question about libreoffice and my recent documents:

[Pedro]

https://ask.libreoffice.org/en/question/2298/suppress-recent-document-list/

The download page is
http://berma.pagesperso-orange.fr/HM/index2.html

Please remember to search 

https://ask.libreoffice.org/en/questions/



--
View this message in context: 
http://nabble.documentfoundation.org/a-question-about-libreoffice-and-my-recent-documents-tp4182459p4182461.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

[libreoffice-users] Re: LibreOffice Online

[Pedro]

nasrin khaksar wrote
> what do you mean?
> is it like microsoft office 2016?
> i did not test microsoft newer versions but i heard that some works
> installation, saving files and some fonctions need connection to the
> internet.

I have no idea if it's like MS Office 2016. I never used it. But it is open
source and it is not proprietary so it is certainly better :)


nasrin khaksar wrote
> i think its good for job projects, businesses, organazation and some
> work that not private and we are in a hurry and want to get help from
> someone or share our experience!

Obviously this is not useful for everybody. An online office suite like
open365 doesn't make sense for personal use in places where access to the
internet is limited. But maybe for an ONG with several PCs connected to an
intranet it is worth considering...

The idea is to have the office installed in your own server so that all
users have the same stable version and don't have to worry if the software
is updated.
On the other hand if everybody in a organization is using LibreOffice then
there is really no reason to use MS file formats...

Maybe this is the beginning of a GOOD thing!



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Online-tp4181840p4182312.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

[libreoffice-users] Re: LibreOffice Online

[Pedro]

Bo Siltberg wrote
> The site wants me to install a client, what is this client used for?
> My antivirus program claims it contained "Variant.Graftor.5639" and
> deleted
> it...

The client is exactly the same as the Dropbox (or Microsoft's OneDrive)
client. It syncs the cloud files with a folder on your drive. The advantage
is that if you don't have internet connection you can still use the offline
LibreOffice to work on the offline file and it will be synced when you are
connected. In addition it is a backup on your own computer so if the cloud
service is discontinued you still have your files, which to me makes all
sense ;)

I believe your antivirus is being overcautious about a program that is
uploading files to the internet (but that is how a sync client should work)

Hope this helps
(again, I'm not affiliated to the service or company, I'm just spreading
what I consider good news, so don't shoot the messenger )



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Online-tp4181840p4181871.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

[libreoffice-users] LibreOffice Online

[Pedro]

Hi all

Sharing exciting news

http://nabble.documentfoundation.org/libreoffice-l10n-LibreOffice-on-the-cloud-Open365-tp4181681.html

It links to the brand new 

https://open365.io/

I just opened an account and it behaves exactly like the offline version.
You can even change the icon theme or add extensions like dictionaries (and
they work!)

The only limitation is that the interface is in US English only.

Have fun! 

(I'm not affiliated to the company providing the service, in fact I couldn't
find any information about it so I wouldn't recommend uploading any
sensitive information...) 



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Online-tp4181840.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

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

[Pedro]

Hi nasrin (aka Zahra)


jomali wrote
> On Tue, Apr 5, 2016 at 12:38 PM, nasrin khaksar <

> nasrinkhaksar3@

> >
> wrote:
> 
>> hi.
>> because docx is compress format and needs less space.
>> for this reason, they send me all documents in docx format.
> 
> So have them save as doc format and zip them, sending you the zip file!

Yes, this is a good suggestion!

Using the file you (nasrin) sent me as an example:

original docx 221KB
saved as doc (in Office 2010) 874KB
doc+zip 193KB

Your best option is to ask your friend to save as doc in MS Office and then
zip. This way both can open and edit the file. You just need to add some
extra steps: extract the file, edit and then compress again.

Saving as ODT in MS Office 2010 (which has a similar size to docx)  is
unfortunately not an option in this case: MS Office will ruin the file if
you modify it in LibreOffice.

Hope this helps.



--
View this message in context: 
http://nabble.documentfoundation.org/about-libreoffice-and-tables-tp4180245p4180376.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

[libreoffice-users] Re: Calc- How to count selected lines

[Pedro]

Hi Rob


Rob wrote
> I just found 2 formats that seem to work:
> COUNTIF(D$4:D4,"<>"&"")
> 
> and also
> COUNTIF(D$4:D4,"<>")
> No clue why this works, but it does...
> 
> Thanks for thinking with me,

I really don't understand why it works but it does.
I'm attaching a sample file in case someone finds this useful.
COUNTIF.ods <http://nabble.documentfoundation.org/file/n4179920/COUNTIF.ods>  

Thank you for teaching me a new trick. This formula is going to be quite
handy.

Best regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-How-to-count-selected-lines-tp4179893p4179920.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

[libreoffice-users] Re: Calc- How to count selected lines

[Pedro]

I'm not sure if this helps with any of your questions but COUNTA counts
numbers and/or text

If you can provide a link to a sample file and explain what you expect maybe
it is easier.

Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-How-to-count-selected-lines-tp4179893p4179898.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

[libreoffice-users] Re: LO spreadsheet format row

[Pedro]

Hi Helen


Helen-2 wrote
> Is there a way, in L.O. spreadsheet, to lock the rows so that a row cannot
> take more than one line?  So that all rows have the same height. 

Select the cell(s) that have more than one row of text (or all) and then go
to menu Format > Cells, switch to tab Alignment and uncheck the option "Wrap
text automatically"

Now you will probably have to adjust the width of the column so that all
text is visible.

Hope this answers your question.



--
View this message in context: 
http://nabble.documentfoundation.org/LO-spreadsheet-format-row-tp4179702p4179703.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

[libreoffice-users] Re: Calc + "Find" in Linux

[Pedro]

Thomas Blasejewicz-3 wrote
> Is there a trick to make the "Ctrl + F" work = display the "Find and
> Replace" dialog box (in the middle of the screen)?
> 
> If so, please tell me how to achieve that.

At some point the hotkey for Find & Replace changed to Ctrl+H /maybe the
information in the menus was not updated in the LibreOffice version you are
using now (it is correct in 5.1.1.3)?
In any case you should be able to use Tools > Customize > Keyboard to select
any keyboard combination to any function...

Hope this helps.



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Find-in-Linux-tp4178482p4178491.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

[libreoffice-users] Re: date display in Calc Linux/Windows

[Pedro]

Thomas Blasejewicz-3 wrote
> I assume, there is a trick to do that?
> 
> Fonts: as far as I can see, there are no fonts with the same name in
> Linux/Windows.
> Does that then mean, I cannot work on the same file using both Linux and
> Windows?

Open the file in the Windows machine, go to File > Properties, switch to the
Font tab and check the "Embed fonts in the document" box.
In theory the fonts are cross platform and should work on both OSes...
Please be warned that the file will increase substantially in size. 
LibreOffice currently has a bug that causes some unneeded fonts to be
embedded 
https://bugs.documentfoundation.org/show_bug.cgi?id=65353

Hope this helps.



--
View this message in context: 
http://nabble.documentfoundation.org/date-display-in-Calc-Linux-Windows-tp4177742p4177746.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

[libreoffice-users] Re: Viewing Manual Break Locations

[Pedro]

Annette wrote
> Another very helpful feature btw. that I use extensively is adding
> background colours to
> styles (which I remove of course when the text is ready for print):
> Navigator (F5)/ right-click style in question: modify / Area). Ok, my
> text looks motley, but in this way I find quickly which styles haven't
> been applied properly (by me *blush*).

Brilliant! This is a real "Egg of Columbus"
Thank you for sharing!



--
View this message in context: 
http://nabble.documentfoundation.org/Viewing-Manual-Break-Locations-tp4177377p4177616.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

[libreoffice-users] Re: Issues Converting to PDF

[Pedro]

Rufus Reynolds, III wrote
> We're using LibreOffice 4.4.1 on a project for DISA and have several cases
> where Microsoft Office documents take a very long time to convert to PDF,
> and sometimes actually crash the service. We are running in headless mode.

Is there any reason why you are not using the final version in the 4.4
branch (4.4.7.2)?
Maybe the problem is already fixed...


Rufus Reynolds, III wrote
> Is there any other information we can share to help? Can I attach the
> example document to an email to this list?

 
Under which OS (version and architecture) are you having these problems?

You can not attach files to the emails but you can add them to the Nabble
interface to the mailing list
http://nabble.documentfoundation.org/Issues-Converting-to-PDF-tp4177197.html
Alternatively you can post a link to some ftp server or file sharing host.

Please remember that branch 4.4 has been EOLed on December 31, 2015 so any
fixes will not be incorporated into that branch



--
View this message in context: 
http://nabble.documentfoundation.org/Issues-Converting-to-PDF-tp4177197p4177202.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

[libreoffice-users] Re: LibreOffice 5.1 inserted images not printing correctly

[Pedro]

marcpare4 wrote
> Is anyone having the same problem with LibreOffice 5.1.0.3 "Fresh"?
> 
> When I insert an image, it all looks fine, but, when I print it, the 
> images are printed in the right size, but, all messed up. -- my printer 
> model is Brother CDP L2520DW

I suggest that you try 5.1.1.1 before reporting the bug , maybe it's already
fixed (some of the problems I had with 5.1.0.3 were)



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-1-inserted-images-not-printing-correctly-tp4176358p4176360.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

[libreoffice-users] Re: Hashes for File Downloads Are Not Obviously Available

[Pedro]

Jim-2 wrote
> I looked and I can't find any file checksum hashes for your downloads 
> anywhere on your site. I have old eyes so if the links aren't obvious I 
> may have missed them.

Just under the big green "Download Version ..." button is a quite visible
"Info" link which leads you to quite a few hashes.

e.g.
http://download.documentfoundation.org/libreoffice/stable/5.0.5/win/x86/LibreOffice_5.0.5_Win_x86.msi.mirrorlist

Hope this helps



--
View this message in context: 
http://nabble.documentfoundation.org/Hashes-for-File-Downloads-Are-Not-Obviously-Available-tp4176336p4176339.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

[libreoffice-users] Re: Broken .docx

[Pedro]

Hi Andrea


Andrea Venturoli wrote
> What surprised me is that both LO 5.0.5 and OpenOffice were able to open 
> all of them without any trouble on FreeBSD.
> 
> If any developer is interested I can send one file to check.

Maybe you can report this bug on Bugzilla and include the file?
https://bugs.documentfoundation.org/

Regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Broken-docx-tp4176245p4176249.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

[libreoffice-users] Re: Screen tearing in LibreOffice

[Pedro]

Thomas Blasejewicz-3 wrote
> None of which has ANY effect.
> Just to make sure, I restarted LibreOffice (not Windows) after every
> change.
> 
> I seem to be the only person complaining about this behavior. Does 
> nobody encounter it?
> I noticed it on SIX different computers.

Yes, you only need to restart LibreOffice.

Did you use the same document to test the 6 computers? I have never seen the
"major text portions
start to "run" into each other just like wet ink on paper" problem. 
Can you share a link to the document (if you used the same document)?
Can you take a screenshot of the problem?
Maybe you should search Bugzilla for this problem (and report it if it
hasn't been reported yet)



--
View this message in context: 
http://nabble.documentfoundation.org/Screen-tearing-in-LibreOffice-tp4176146p4176158.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

[libreoffice-users] Re: Opening Microsoft Office 2013 files

[Pedro]

Hi Amichai


Amichai Rotman wrote
> As I mentioned, none of these steps worked. It is *very* important for me
> to make it work!
> 
>- Any tips?
>- Maybe tweaking some configuration options?
>- Telling her Editor to save the fie in a different format?
> 
> I wish I could switch her Editor to LibreOffice too, but I get the feeling
> she's not that open minded as my mom. It took her to days to tell me which
> version of Microsoft Office she uses...

Microsoft Office and LibreOffice (or any Open Document based Office) will
never be 100% compatible. It is not in Microsoft's interest that they are
compatible.

That said, you are probably better off using Office 2003 (.doc) format. It
has been around for a longer time (so many problems have been figured out)
and it is no longer changing. On the contrary there is no Office 2013
format. It is just another iteration of the XML version that Microsoft has
been tweaking since Office 2007 making it slightly incompatible even with
the previous MS Office releases so that the user is forced to keep buying
the newest version.

If there are any features in the document that are not compatible with .doc
then your only options (excluding giving in to Microsoft) are to ask the
Editor to install LibreOffice alongside with Microsoft Office or send the
editor the Portable version of LibreOffice (maybe just the link)
http://www.libreoffice.org/download/portable-versions/
and in that case you could stick with ODF files which is definitely your
best option.

The idea is that the Editor will still be using MS Office as default but can
open ODF files.

Hope this helps,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Opening-Microsoft-Office-2013-files-tp4176151p4176156.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

[libreoffice-users] Re: Screen tearing in LibreOffice

[Pedro]

Hi Thomas


Thomas Blasejewicz-3 wrote
> A solution would be VERY highly appreciated.

Have you tried disabling OpenGL? In my systems the recently added OpenGL
does not bring any improvement even on a high spec machine (on the contrary)

Go to Tools > Options, on the left panel LibreOffice > View and on the right
panel uncheck "Use OpenGL for all rendering (on restart)"
Close and open LibreOffice to see if any improvements are noticeable. If
there were no changes try disabling "Use anti-aliasing" and/or "Use hardware
acceleration". Change one setting at a time and try all possible
combinations.

Hope this helps.
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Screen-tearing-in-LibreOffice-tp4176146p4176149.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

[libreoffice-users] Re: Linear Graph with X,Y data

[Pedro]

Hi Joel


jmadero wrote
> I'm hoping to create a linear graph from January of 2007 -> Current
> Month using this data. I can't think of a way to do this without putting
> the data in a different format (possible but not ideal). Can anyone
> think of a different solution for a single line chart over time (I don't
> want a different line per year or month).

In my experience this is simply not possible. To have a linear graph the
X-values have to increase (in this case with year). You have 12 text values
on the X-axis.
You really have to convert this to a two column structure (BTW if you make
the first date value 1/15/2007 and the second 2/15/2007 you can simply drag
the X values all the way down and LO is smart enough to always use the 15th
of every month)

If someone knows a different solution, I'm also interested in learning!

Regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Linear-Graph-with-X-Y-data-tp4175833p4175834.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

[libreoffice-users] Re: LibreOffice 5.1: Sweet, subtle, and necessary polish - TechRepublic

[Pedro]

James Knott wrote
> I came across this article today.
> 
> http://www.techrepublic.com/article/libreoffice-5-1-sweet-subtle-and-necessary-polish/?ftag=TRE475558a&bhid=12825460

Interesting article. Unfortunately Jack Wallen is not aware (or deliberately
ignores) that 5.1.0 is the .0 release in a new branch. Even if it has new
features (because it is a new branch...) it is still very raw and it should
not be recommended for general use.
So 5.1 is not a .1 fix over 5.0. It is a new branch with new features (and
new bugs and regressions). Branch 5.1 should be usable around 5.1.3 (just
like 5.0.5 is an excellent version)

A good example is Open Remote File. It is an excellent improvement. Except
that because this is a .0 release it fails to work on some systems/OSes
(search bugzilla to see what I mean).

Another example is OpenGL. In branch 5.1 OpenGL is set to ON by default.
Unfortunately OpenGL is currently not a good experience (at least in my
experience with several machines ranging from Windows XP to 10). The menus
are blurry and slow, which is particularly noticeable on older/slower
systems.

So, yes branch 5.1 has great things but don't make such a fuss about a .0
(again, it is 5.1.0) release.

Just my 2 cents...



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-1-Sweet-subtle-and-necessary-polish-TechRepublic-tp4175715p4175761.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

[libreoffice-users] Re: LO 5 Writer: How can I switch off the formatting in the styles and formatting window?

[Pedro]

Hi Stuart


V Stuart Foote wrote
> Easily done 
> 
> 1.  Tools -> Options -> Advanced:  Expert configuration dialog
> 2. Search string  "StylesAndFormatting"
> 3. highlight the stanza
> 4. a Boolean, so True is enabled and False is disabled -- the Edit button
> will toggle.
> 5. OK to apply and exit.

Sure it's easy. For someone who knows these settings are hidden in Expert
configuration ;)

Are these settings described anywhere? 
I couldn't find any documentation (either on the Help file or online)...



--
View this message in context: 
http://nabble.documentfoundation.org/LO-5-Writer-How-can-I-switch-off-the-formatting-in-the-styles-and-formatting-window-tp4175486p4175513.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

[libreoffice-users] Re: LO5.1 on Linux - Opening Writer document takes >1hr

[Pedro]

Hi Patrick


Patrick Dijkgraaf wrote
> Just tried 5.1.1.1 on the Debian box but unfortunately, the issue is
> still there... ☹
> Please let me know if you have other suggestions, otherwise I'll
> defininately file a bugreport.

The major change from 5.0 to 5.1 is the default usage of OpenGL for all
graphic operations. Maybe OpenGL is slowing down your system (on both my
Windows machines all OpenGL does is make everything blurry and slow). But
remember this is a .0 version so it is expected to be buggy (no matter what
the TDF marketeers say)

Go to menu Tools > Options, on the left panel choose LibreOffice > View and
uncheck the box "Use OpenGL for all rendering (on restart)". Close the
Options dialog and Exit LibreOffice.

Restart LibreOffice and reopen your document.

If this solves your problem you should still report a bug. It is not
expected to need 1 hour to open a document...

Cheers,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/LO5-1-on-Linux-Opening-Writer-document-takes-1hr-tp4175443p4175491.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

[libreoffice-users] Re: LO5.1 on Linux - Opening Writer document takes >1hr

[Pedro]

Hi Patrick


Patrick Dijkgraaf wrote
> Is anybody able and willing to help me on this?
> Due to the size of the file and intellectual property reasons, I did
> not add (a link to) the file. I can make the file available upon
> request, please let me know.

You have done some quite extensive testing so it seems to be reasonable to
assume there is a specific problem with LO 5.1.0.3 under Arch Linux.

You could try 5.1.1.1 (aka RC1) which solved some of the problems that
occured under Windows XP with 5.1.0.3. Maybe those fixes also improved LO
under Arch Linux...
http://dev-builds.libreoffice.org/pre-releases/

If that doesn't improve things you should move back to the 5.0 branch
(currently at version 5.0.5) and report the bug at Bugzilla
https://bugs.documentfoundation.org/

Hope this helps...
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/LO5-1-on-Linux-Opening-Writer-document-takes-1hr-tp4175443p4175465.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

[libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Pedro]

Hi Owen


Owen Genat wrote
> Pedro, something like this should give an idea:
> 
> $ unzip -p filename.odp styles.xml | xmllint --format - | grep "font-face
> style:name" | sort -u
> 
> That will just give style-based font use. For direct formatting, replace
> "styles.xml" with content.xml.

That looks a lot like a Unix/Linux line command ;) so I will give it a go
when I'm on my Linux box. Nevertheless it looks much more efficient than
having to rename the odp to zip, extracting the xml files and searching for
fonts! Thanks!

The problem with styles.xml is that it is listing ALL the fonts in the
default styles regardless of the fact that you are probably using  a small
fraction of them. Many (most?) users only use the Default style and all else
is direct formatting...

What I'm trying to figure out is which fonts are _effectively_ used...

Regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174439.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

[libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Pedro]

Hi Dave


Dave Barton wrote
>> Brilliant!
> 
> Yep! Just like most of Tom Bilek's extensions.

+1


Dave Barton wrote
>> BTW the extension works perfectly in LibreOffice 4.4.7 and 5.0.4.2 but
>> doesn't work in 5.1.0.3
> 
> Which OS? The extension works perfectly for me in Writer LibreOffice
> 5.1.0.3 x64 on Window 7 & PCLinuxOS.

I forgot to mention it is Windows XP Pro x86 SP3.
AltSearch doesn't work either.
Maybe it's time for TDF to assume that 5.1 does NOT support Windows XP (5.0
already doesn't fully support it, like the missing updates dialog)


Dave Barton wrote
>> Unfortunately you are right. It only works in Write. I will ask the
>> author
>> if he is willing to adapt it to Impress (and Draw), where I believe they
>> are
>> _very_ useful.
> 
> You might find that Tom is overloaded with other commitments at the
> moment, but I feel sure he would be open to a RFE.

I already sent him an email. Maybe you can put a good word for me? ;)

Regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174430.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

[libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Pedro]

Hi Jonathon


toki wrote
> I _think_ that the TestFonts extension works for Impress.
> 
> It was designed for Write.

Brilliant! It was exactly something like this I was looking for (how stupid
of me not to remember looking in OpenOffice Extensions where there are many
more extensions available...)

BTW the extension works perfectly in LibreOffice 4.4.7 and 5.0.4.2 but
doesn't work in 5.1.0.3

Unfortunately you are right. It only works in Write. I will ask the author
if he is willing to adapt it to Impress (and Draw), where I believe they are
_very_ useful.

Thank you for your valuable answer!

Thank you to all that contributed to this discussion!

Warm regards from
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174418.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

[libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Pedro]

Hi Tom


TomD wrote
> I thought the font-box (on one of the toolbars) shows the correct
> font-name
> despite the document displaying the substitution?  It'd be a pain to move
> the cursor through the whole document and doing so is quite error-prone,
> but if it works it might usable for an odd one or two documents.

Indeed it does show the original font but it is not efficient to have to
click on every text box on every slide to check the font (especially because
several fonts can be used in a single text box).

I'm really hoping that someone has a magical extension that does this :P



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174402.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

[libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Pedro]

Robert Funnell wrote
> What about unzipping the .odt/.odp/whatever file and searching for 
> font names in the resulting .xml files? (Again, I haven't tried this.)

That would make sense. Unfortunately the file styles.xml lists some 55 fonts
>From a PDF copy of the presentation I can see that there should be 15
different fonts, so the xml is not helping...

Unless I'm looking in the wrong xml... Does anyone know any better?





--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174366.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

[libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Pedro]

Hi Robert and Brian

You had the same idea with a few minutes overlap :)

Thank you for the suggestion. I am aware that PDFs list the embedded fonts.
Unfortunately that doesn't work for this problem...

When you open an Open Document and don't have the fonts used in the document
they will be replaced by a similar font. 
Therefore when you create the PDF in a computer that doesn't have all the
original fonts, the fonts embedded are the replacement fonts. This means
that the PDF font list will show the fonts currently used but not the name
of the original ones.

Any other ideas?



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174357.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

[libreoffice-users] How to find out which fonts are used in an Open Document?

[Pedro]

Hi all

Does anyone know a way to find out which fonts are used in a Open Document
(in this case it's an Impress presentation)?

I'm trying to figure out how a user can make sure that he has all the fonts
needed to view a presentation or any other document (which does NOT have
embedded fonts) exactly like the author intended.

Thank you in advance!

Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339.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

[libreoffice-users] Re: question about the best version of libreoffice:

[Pedro]

Hi Andreas, all


Andreas Säger wrote
> I'm still convinced that the poster is not interested in the answer to
> his technical question. And like so often we will not see any feedback
> regarding the answers to his on topic question. Therefore I call him a
> troll.

I believe you are wrong. She has contributed with bug reports on the
tracker.

If LibreOffice wants to be universally used then it needs users from other
countries and cultures. 
This is particularly important if LibreOffice wants to handle other
characters and Right To Left (RTL) writing such as Persian or Farsi (used by
around 100 million human beings)

The fact that she adds a link to a site explaining her religion doesn't
shock me. In fact I think it follows the same logic of Open Source projects
(such as LibreOffice). If you find a good project you want to share it with
others so that they join the community and that advantage of this good thing
you found.

I do not believe in any religion but I am sure that insulting people or
their religion does not help in any way and am also sure that religion is
not a subject for this forum.

Returning to the subject I believe it would be useful to find out what is
making people stick to older (and in particular discontinued) versions. If
it is because the new features in new versions are not useful to them but
the version they use fulfills all their needs, then it is fine. But if the
cause are regressions then it is something to worry about.

Just my 2 cents.

All the best,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/question-about-the-best-version-of-libreoffice-tp4172346p4172556.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

[libreoffice-users] Re: Anaphraseus extension

[Pedro]

Hi Thomas

Installing Anaphraseus 2.05.126b  on LO 5.0.4.2 under Windows XP returned
and error message but the toolbar was installed. I have no idea if it works
as expected because I don't have any Translation Memory files :)

Why are you using LO 4.4.3.2? If you want to stay on the 4.4 branch it would
make sense to update to 4.4.7 (the extension installed without any problems
on my PC)

Do you have the latest Java installed?

So, the answer is: it does seem to work (at least the toolbar is there and
the buttons work...)



--
View this message in context: 
http://nabble.documentfoundation.org/Anaphraseus-extension-tp4171044p4171051.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

[libreoffice-users] Translations

[Juan Pedro CC]

Good Morning,
In your Spanish distribution, is included by default, for all Spain,
besides our Spanish language, Catalan language option, eliminating options
of other languages used in our country, such as the Basque, Galician and
Valencian. The issue is extremely controversial because in our country, the
use of regional languages creates no little domestic news, provoking much
controversy among Spanish regions.
No. You can not include a regional language by default if you don't include
the others one. The Catalan can be an installable option, but not a default
option. I consider, and as many more people we have talked about this
issue, an insult to our linguistic unity and variety, our nation and our
people.
Sincerely,
Juan Pedro Caparros Caballonga

-- 
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] Win 10

[Pedro]

what?? lol

On 12/12/2015 22:21, John Boyle wrote:
To Users: I belong to a computer club, and today we had a presentation 
on WIN 10 and how much of a headache it really is to install, even for 
professionals. I would like to know what version of LibreOffice has 
even a chance to work with WIN 10???





--
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

[libreoffice-users] Re: [bug 1/3] hyphenation fails doubling some letters

[Pedro]

Hi Carlo


carlo.strata wrote
> What do you think about?
> 
> Have I to file a bug or is there already one similar?

There are all these bugs related to hyphenation

https://bugs.documentfoundation.org/buglist.cgi?quicksearch=hyphenation&list_id=577601

and this one seems to be the same as yours

https://bugs.documentfoundation.org/show_bug.cgi?id=96300

Hope this helps!



--
View this message in context: 
http://nabble.documentfoundation.org/bug-1-3-hyphenation-fails-doubling-some-letters-tp4169123p4169124.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

[libreoffice-users] spell check

[Pedro]

Hi people :)

I'm coming here today to ask the community about one situation in my calc.
I have a ods file that I use every day, today I installed a spell-check 
dictionary to check the ods file, but the functionality doesn't work, 
now the "funny", if i create a new ods file, the spell-check works perfect!


any help?

Thank you!

--
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

[libreoffice-users] Re: Importing pictures that are resized.

[Pedro]

dave boland wrote
> Yes, I can get am image fairly soon, but how do I share it?  I don't
> think they like attachments to the mail forum.

You have two ways: share it in an image sharing site like imgur.com or
register in Nabble and add an attachment to your next reply here

http://nabble.documentfoundation.org/Importing-pictures-that-are-resized-td4168604.html


dave boland wrote
> Oh, I have GIMP 2.8.14,
> and LO version 5.0.2.2.  The O.S. in Ubuntu 15.15.  Let me see if I can
> get an upgrade done to both.

Maybe that is enough to solve the problem and there is no need to upload the
image ;)



--
View this message in context: 
http://nabble.documentfoundation.org/Importing-pictures-that-are-resized-tp4168604p4168617.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

[libreoffice-users] Re: Importing pictures that are resized.

[Pedro]

dave boland wrote
> On Mon, Dec 7, 2015, at 11:35 AM, Regina Henschel wrote:
>> Hi Dave,
>> 
>> dave boland schrieb:
>> > I'm creating some greeting cards using LO Draw templates I created a
>> few
>> > years ago.  The problem is that Draw gets the dimensions wrong.  I
>> start
>> > with a digital photo of about 3000 x 2000, resize it using GIMP to
>> about
>> > 9" x 6"
>> 
>> How do you resize it?
> 
> Regina, I use GIMP Image Resize.  Set the image to 300ppi, set the
> dimensions to inches, set the size to about 9"W x 6"H.  Once that is
> don, I export.

No problem doing the same with Gimp 2.8.16 and LibreOffice 5.4.0.1 under
Windows XP. Can you create an image file which illustrates the problem and
share it ? Could be a bug in Draw under Linux only...



--
View this message in context: 
http://nabble.documentfoundation.org/Importing-pictures-that-are-resized-tp4168604p4168614.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

[libreoffice-users] Re: Libre Writer - Read Only issues

[Pedro]

charles meyer wrote
> First, if I saved a document as .odt and tried opening it in MS Word
> 2003 I would get a Read Only option to open it.

MS Office 2003 does not support ODT (unless you installed the *very old* Sun
ODF Plugin)
Do you mean Office 2013?


charles meyer wrote
> Now, when I saved a document in MS Word and then try to open it in
> Libre Writer 4.3.5.2 I get the message...Unknown user. Open document
> read-only or open a copy of the following for editing."
> 
> Is there a file permission factor going on here?

Did you save a newly created document in ODT format in your Office 2013?

Of course there is a file permission "factor". Microsoft advises users not
to save in ODT (because some "data might be lost"...) and I assume it is
using the published ODF 1.2 specification.

On the other hand LibreOffice is pushing the ODF format so it is ahead of
the published specification (not using ODF 1.2 strict specification by
default).

You can change the ODF format under Tools > Option> Load/Save (second item
with an arrow on the left panel list) > ODF format version

Change to ODF "1.2 Extended (compatibility mode)"  or to "1.2" if the
previous option is still not compatible enough

Of course now you get a "Not using ODF 1.2 Extended may cause information to
be lost"

So I believe the "factor" is always going to be present whatever file format
you choose to use (similar problems occur with DOC and DOCX)

Hope this helps...



--
View this message in context: 
http://nabble.documentfoundation.org/Libre-Writer-Read-Only-issues-tp4168340p4168437.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

[libreoffice-users] Re: Thai language problem

[Pedro]

Ch. C. wrote
> Please check the thai language strange display problem on 5.0.2-5.0.3
> version., But 5.0.1 is ok.

Please report the problem at

https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice

You should include screenshots of what is the current "strange display" and
what you expect.



--
View this message in context: 
http://nabble.documentfoundation.org/Thai-language-problem-tp4166738p4166765.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

[libreoffice-users] Re: precision of Draw dimensions - 3 place

[Pedro]

dave boland wrote
>  If I make a suggestion to LO - add some more CAD abilities
> to Draw such as higher precision.  LOD is a very useful program, and
> could be even more useful.

Maybe request for user selectable precision? In your example 1/8 inch =
0.3175 cm so if someone uses the metric system it would require 4 decimal
cases to achieve the _exact_ same position.

If you would like to make that suggestion official, you can add it to the
Bugzilla tracker with severity=enhancement

https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice

This way it may be included in a future version...



--
View this message in context: 
http://nabble.documentfoundation.org/precision-of-Draw-dimensions-3-place-tp4166689p4166764.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

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

[Pedro]

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

[libreoffice-users] Re: I just downloaded Libre Office last night, and I have a couple of questions.

[Pedro]

Susan Mason wrote
> I have had Libre Office before, but not this newest version. For the most
> part, I like it. There are some things about it which are better than Open
> Office, and some things which appear identical to Open Office. 
> One of my questions, involves an issue I encountered last night with
> administrator permissions. This is strictly a one person computer, and I
> AM the administrator, and I actually resent it when my computer tells me
> that I do not have permission to do anything on my own computer. It once
> made me so mad, on a different computer...that I spent hours trying to fix
> all the permissions, and ended up having to re-install windows, because I
> screwed it up so badly. I thought that I had myself designated as the
> administrator on this computer...but it seems that I am only listed as
> computer user with special permissions. The program would not even let me
> update it.

You probably need to un-hide the Administrator account (probably it doesn't
have a password...)

https://techjourney.net/unhide-the-administrator-account-in-windows-xp/

Then you can log in as the Admin and install LibreOffice from this account
(or change your account to admin)


Susan Mason wrote
> My other question is...how can I reset the distance that objects will move
> when I press the space bar? I have the same problem with Open office. The
> space bar moves objects much too far. I want them to move at the tiniest
> possible increments for the utmost precision. 

Have you tried pressing Shift or Alt while moving the objects with the
cursor keys?


Susan Mason wrote
> I have used both MS-Word, and MS-Publisher for many years, and both these
> programs gave me this level of precision--but I currently have no copy of
> either, and can't afford them, either. I am NOT a Bill Gates fan, in any
> way, shape, or form...but I am used to working with word and Publisher,
> and I know how to make them do exactly what I want them to do. I know of
> no open source equivalent for Publisher...but, I wish I could find one. I
> also know of no open source program which will even open my old Publisher
> files. I wish I could find that, as well.

The Open Source equivalent to Publisher is Scribus

http://www.scribus.net/



--
View this message in context: 
http://nabble.documentfoundation.org/I-just-downloaded-Libre-Office-last-night-and-I-have-a-couple-of-questions-tp4166387p4166391.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

[libreoffice-users] Re: LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?

[Pedro]

Hi Manuel


manuel_songokuh wrote
> hellomaybe i'm wrong write english, then i want that theme:
> https://addons.mozilla.org/it/firefox/addon/dandywater/i like this theme
> to libreoffice, how..?did you try install that theme link to libreoffice?i
> did try write in input: "Dandelion Seeds . Water Droplets" is not detected
> (that is title of theme)
> i did try write in input: "VanillaOrchids" is not detected (that is name
> author create of theme)
> i did try write in input:
> "https://addons.mozilla.org/it/firefox/addon/dandywater/"; is not detected
> (that is url of theme)
> then...what i do..?

You can only search for the Theme's name. Searching for the Author won't
work.
Unfortunately the URL input was removed by a Google Summer School student
who remodeled the Theme dialog.

Currently there is no way to select a specific theme. Unless you are
fortunate that the theme you like is within the first 9 that come out in
whatever search you do, you are out of luck.

Curiously, searching for  "Dandelion Seeds" in the Mozilla Add-Ons, Themes
page immediately returns the theme you are looking for in first place, so I
have no idea which search engine or criteria the LibreOffice dialog is
using...

That is a know Regression and was reported some time ago
https://bugs.documentfoundation.org/show_bug.cgi?id=88502

Unfortunately none of the devs working on LibreOffice found that this is an
interesting bug to fix...

Maybe someone knows a workaround?



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-4-4-5-0-firefox-personas-not-work-with-path-url-why-tp4166307p4166344.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

[libreoffice-users] Re: Large spreadsheet does not open in LibreOffice.

[Pedro]

ammorei wrote
> I have a spreadsheet in '.xlsx', with a size around 150Mb and containing
> +/- 40 lines.
> I tried to open it in LibreOffice and the program is with a gray screen
> with the progress bar, just arriving at a point that the bar does not
> advance and the program simply crashes.
> 
> Is there any way to open this worksheet in LibreOffice.
> Libre Version: 5.0.3.2

Can you test with the following file?

https://dl.dropboxusercontent.com/u/2347109/30_line_sample.ods

If your file does not contain confidential data, can you share it?




--
View this message in context: 
http://nabble.documentfoundation.org/Large-spreadsheet-does-not-open-in-LibreOffice-tp4166243p4166246.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

[libreoffice-users] Re: The UK government embraces open source with the help of LibreOffice - TechRepublic

[Pedro]

V Stuart Foote wrote
> ... and I think his handling of the Collabora supported  GovOffice to
> cover things reasonably well...  its good press.

I'm quite curious to know when "Incremental Windows Installer .MSP patches"
will be available to LibreOffice users...

For developing countries where internet connections are slow it would be a
big improvement to download an incremental patch with a few Megabytes
instead of 200Mb for each x.x.1 update... 



--
View this message in context: 
http://nabble.documentfoundation.org/The-UK-government-embraces-open-source-with-the-help-of-LibreOffice-TechRepublic-tp4166051p4166096.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

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

[Pedro]

Hi Nasrin


nasrin khaksar wrote
> in libreoffice 4.3 and 4.4 its a setting in libreofficeoptions online
> update  to activate or
> deactivate libreoffice update and also consider that download the
> newer version of libreoffice be automatic or not.
> but in version 5.0.2.1 of libreoffice i did not find the
> setting for update in libreoffice.
> how is update of the newer version of libreoffice?
> i am afraid of the newer versions will be download automaticly without
> asking and my desire.

This is a bug in the x86 (32bit) version only. This is an error in the 5.x
branch  and it has already been reported

https://bugs.documentfoundation.org/show_bug.cgi?id=95184

Don't worry about the automatic download. LibreOffice is ALWAYS set to WARN
the user about new versions but does NOT automatically download the files.

The fact that the options are missing  does not mean there was a change of
mind by LibreOffice/TDF.

It was simply an error.

Hope this helps ;)



--
View this message in context: 
http://nabble.documentfoundation.org/a-question-about-libreoffice-opdate-tp4165716p4165724.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

[libreoffice-users] Re: Android version

[Pedro]

Hi Tom


TomD wrote
> Has anyone here used the AndrOffice or the LibreOffice version on Android?
> 
> Does anyone know if it installs onto the device itself so that it's usable
> off-line?
> 
> I have a friend who is going off to a distant land where they won't be
> able
> to use their hand-held phone but has created a spreadsheet to help convert
> between the various currencies they will encounter.  I've never used an
> Android so i have no idea what to recommend but i'd rather suggest a
> LibreOffice or OpenOffice solution.  Any ideas?

AndrOffice is a port of OpenOffice but the interface was not redesigned so
it's unusable in a mobile phone (maybe on a 10" tablet it could work)

LibreOffice Viewer is...  a viewer (and absurdly slow). I realize that at
some point it will have editing functions but at the moment it is a huge
download just to view files. The main advantage is that is supports ODF

I use WPS Office (formerly Kingston Office) but it is not Open Source. It is
a reverse-code software from an unknown company, so use at your own risk...
The usability is quite good even on a mobile phone. IMO it is currently the
best option. It doesn't support ODF, only MS formats (old binary and XHTML)

All of these are installed on the phone and work with files on the phone (no
need to connect to the "cloud")

Finally there is Microsoft Office... The interface is not bad (but inferior
to WPS) and it works with local files but requires an account to synchronize
at some point to the "cloud". I was not very impressed. I can't remember if
it worked with ODF...

Hope this helps (and looking forward to read other opinions :) )
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Android-version-tp4160256p4160263.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

[libreoffice-users] Re: Conditional Formatting On Date

[Pedro]

Dave Barton wrote
> In Calc I have column with a series of calculated dates (ie. the result
> of a formula). I am looking to find a way of using conditional
> formatting to set the background colour (eg. green) for those dates
> which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
> sets Format: Cell Background = Green)
> Can anyone offer any pointers to a solution?

One way to do this is to have another column with column Weekday using the
formula you suggested. Then you have two options: either use conditional
formatting to set the background of the Weekday column OR use conditional
formatting with Condition set to "Formula is" and point to the weekday in
the same row and have the background changed accordingly.

Hope this helps
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Conditional-Formatting-On-Date-tp4160195p4160203.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

[libreoffice-users] Re: Bug encounter

[Pedro]

Julio Saleme wrote
> I'm currently facing a bug in Writer which refresh constantly the part of
> the document where I inserted a checklist (bullets) besides that I don't
> know how to deactivate to track changes.

To deactivate just go to menu Edit > Track Changes and uncheck the option
Record Changes.

In any case the constant refresh should not happen, so please report the bug
including an example file.



--
View this message in context: 
http://nabble.documentfoundation.org/Bug-encounter-tp4159618p4159631.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

[libreoffice-users] Re: Track changes with MS Office

[Pedro]

Jack Wallen wrote
> On 2015-09-06 01:12, Pedro wrote:
>> If you use DOC track changes works with text but not with format 
>> changes.
>> 
>> This is one of the LO limitations that stops me from switching to LO...
> 
> I'm not sure what you mean. I use track changes with my editors all the 
> time. Some of them use Word some use LO. There have been issues with 
> highlighting in the past (between Word and LO), but I think that problem 
> has been solved with LO 5.0

I'm afraid the bugs are still there. If you exchange files with people using
MSO maybe something is lost and you don't even notice...

https://bugs.documentfoundation.org/show_bug.cgi?id=91862

Just tested with LO 5.0.2.1 x64 and the problems remain.

Regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Track-changes-with-MS-Office-tp4159393p4159606.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

[libreoffice-users] Re: Track changes with MS Office

[Pedro]

Andreas Säger wrote
> Can recent versions of Writer or Calc track changes with Word or Excel?
> This did not work with 3.x and I can not try out without MS Office.

Yes but no...
If you use ODF you never know what happens when you open with MSO
If you use DOCX you never know what happens when you open with LO
If you use DOC track changes works with text but not with format changes.

I never used track changes with spreadsheets...

This is one of the LO limitations that stops me from switching to LO...

HTH



--
View this message in context: 
http://nabble.documentfoundation.org/Track-changes-with-MS-Office-tp4159393p4159405.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

[libreoffice-users] Re: odd error in 5.0 writer

[Pedro]

Jack Wallen wrote
> Has anyone witnessed this strange happening?
> 
> I was working with the formatting of a book, using a template created by 
> Createspace. This template has worked perfectly until 5.0. However, 
> while working with it, I noticed text started disappearing (see attached 
> image). I could remove the formatting of the text and it would 
> reappear... only to immediately disappear the second I reformat. It 
> seems to be randomly happening.
> 
> I can't attach the file this is happening to, because the book has yet 
> to be published. I can, however, attach the blank template.
> 
> I wound up having to install the LibreOffice from the default Elementary 
> OS repo (LO 4.2) which worked just fine.

Could you be more specific? Under which OS? Were you using 5.0.5 or 5.0.1.2?
Did you test the latest stable build i.e. 4.4.5?

Using any branch until it reaches release x.x.3 or x.x.4 for production is
usually a bad idea (because of regressions) unlike what marketing says...

The User mailing list does not allow to add attachments to the emails, but
you can attach files to the Nabble topic if register
http://nabble.documentfoundation.org/odd-error-in-5-0-writer-td4158002.html

If the same template doesn't cause that problem in 4.2 then it is a
regression and should be reported in https://bugs.documentfoundation.org/



--
View this message in context: 
http://nabble.documentfoundation.org/odd-error-in-5-0-writer-tp4158002p4158028.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

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

[Pedro]

Jack Wallen wrote
> Thought I'd share this. One of my latest open source pieces for 
> TechRepublic about LibreOffice 5.0.
> 
> http://www.techrepublic.com/article/libreoffice-5-0-the-strongest-release-to-date/

Nice article. 

I disagree that the UI is the biggest problem... 

If you are a NEW user (i.e. never used an Office suite before) then you need
to learn it from zero and organized menus are more logical than large
buttons organized by someone else.
If you are moving from Office 2003 then you will feel at home. 
However if you are used to Office 2007 or newer then you are in real
trouble. Not only you will have to relearn/adjust to the UI but you will
have BIG problems with round-trip documents regardless if you are using XML
based MS file formats or Open Documents...

The issue is that not only XML based MS formats are proprietary and
constantly changing even within MS Office versions (so it is impossible for
other Offices to open or save EXACTLY like MS) but Microsoft makes sure that
you will also not want to use Open Document format to exchange files. You
will ALWAYS get some warning (more or less scary) that you will loose
something or that you have already lost something...

I really don't see a solution for this problem... Even if Governments
effectively push for Open Documents, the scary messages will always make
users think twice before opening or saving to Open Document formats...

Just my 2 cents ;)



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-Review-Rating-PCMag-com-tp4157614p4157845.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

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

[Pedro]

steveedmonds wrote
> On 2015-08-19 12:55, James Knott wrote:
>> On 08/18/2015 07:23 PM, Steve Edmonds wrote:
>>> Hi. Is this a review for LO 4? When I click on the link I get a review
>>> for 4.0
>> It says 5.0, when I click on the link.
>>
>>
> Must be a redirect because that link takes me to 
> http://au.pcmag.com/libreoffice-40/2249/review/libreoffice-40

Here is a direct link
http://www.pcmag.com/article2/0,2817,2418419,00.asp

Hope this works...



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-Review-Rating-PCMag-com-tp4157614p4157753.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

Re: [libreoffice-users] VAR, STDEV, CHISQ.INV

[Rui Pedro Caldeira]

Thank you for all your help!

My best,
Rui

Cumprimentos,
Rui Pedro Caldeira

On Thu, Jul 9, 2015 at 11:15 AM, Rob Jasper  wrote:

> Joel,
>
> just read the MS-Excel explanation you are referring to. Great explanation.
> Thanks for pointing to this.
>
> Rob.
>
> On 8 jul. 2015, at 20:42, Joel Madero wrote:
>
> > Sounds to me like normal floating number behavior. I know someone is
> trying
> > to document this and explain why it happens (it's a technical reason that
> > goes beyond my skills) but this seems entirely normal behavior given the
> > constraints of programming languages generally and hardware in
> particular.
> >
> >
> > Best,
> > Joel
> >
> > P.S. You can see similar issues in other spreadsheet software. This seems
> > to give some indication as to the reasons why:
> > https://support.microsoft.com/en-us/kb/78113 (yes I know it's MSO
> > link...just explaining the reason why floating number isn't entirely
> > accurate all the time)
> >
> > On Wed, Jul 8, 2015 at 11:33 AM, Rui Pedro Caldeira <
> rpcalde...@outlook.com>
> > wrote:
> >
> >> Hey and thanks for your fast answer. This is the data set:
> >>
> >>  0.01  0.01  0.01  0.01  0.01  0.01  0.01
> >> 0.01  0.01  0.01  0.01  0.01  0.01  0.01
> >> 0.02  0.03  0.97  0.97  0.97  0.97  0.98
> >> 1.01  1.97
> >>
> >> Using the formula in the spreadsheet it gives the value: 0.328061419
> (VAR)
> >> and 0.5727664611 (STDEV)
> >>
> >>
> >> And yes, i do mean CHISQ.INV :)
> >>
> >> Thanks, Rui.
> >>
> >> Cumprimentos,
> >> Rui Pedro Caldeira
> >>
> >> On Wed, Jul 8, 2015 at 7:24 PM, Brian Barker  >
> >> wrote:
> >>
> >>> At 18:44 08/07/2015 +0100, Rui Pedro Caldeira wrote:
> >>>
> >>>> I'm having some problems with the VAR and STDEV function, when
> executing
> >>>> these lines of code. The average is well calculated but the remaining
> >> two
> >>>> return very low, unrealistic and equal values (6.93018471335974E-310).
> >>>>
> >>>
> >>> That value is 2^-1027 - which is probably the smallest floating-point
> >>> value your system can represent without underflow.
> >>>
> >>> Have you compared the results produced from your data by equivalent
> >> normal
> >>> formulae in a spreadsheet cell?
> >>>
> >>> Do you mean CHISQ.INV and not CHISQINV?
> >>>
> >>> 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
> >>
> >
> >
> >
> > --
> > *Joel Madero*
> > LibreOffice QA Volunteer
> > jmadero@gmail.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] VAR, STDEV, CHISQ.INV

[Rui Pedro Caldeira]

Hey and thanks for your fast answer. This is the data set:

  0.01  0.01  0.01  0.01  0.01  0.01  0.01
0.01  0.01  0.01  0.01  0.01  0.01  0.01
0.02  0.03  0.97  0.97  0.97  0.97  0.98
1.01  1.97

Using the formula in the spreadsheet it gives the value: 0.328061419 (VAR)
and 0.5727664611 (STDEV)


And yes, i do mean CHISQ.INV :)

Thanks, Rui.

Cumprimentos,
Rui Pedro Caldeira

On Wed, Jul 8, 2015 at 7:24 PM, Brian Barker 
wrote:

> At 18:44 08/07/2015 +0100, Rui Pedro Caldeira wrote:
>
>> I'm having some problems with the VAR and STDEV function, when executing
>> these lines of code. The average is well calculated but the remaining two
>> return very low, unrealistic and equal values (6.93018471335974E-310).
>>
>
> That value is 2^-1027 - which is probably the smallest floating-point
> value your system can represent without underflow.
>
> Have you compared the results produced from your data by equivalent normal
> formulae in a spreadsheet cell?
>
> Do you mean CHISQ.INV and not CHISQINV?
>
> 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

[libreoffice-users] VAR, STDEV, CHISQ.INV

[Rui Pedro Caldeira]

Hello guys, I’m having some problems with the VAR and STDEV function, when
executing these lines of code. The average is well calculated but the
remaining two return very low, unrealistic and equal values
(6.93018471335974E-310).

To add to a bad situation, I can’t execute the function CHISQINV as stated
in the second code box below. It gives out the error:

BASIC runtime error.
An exception occurred
Type: com.sun.star.lang.IllegalArgumentException
Message: .

Any help is deeply appreciated!

Thanks,
Rui

== CODE BLOCK 1 ==oRange =
xSheet.getCellRangeByPosition(7, 1,  7, rangeLim)'Media (funciona)
average = oRange.computeFunction(com.sun.star.sheet.GeneralFunction.AVERAGE)
print average'Variancia (ver)
variance = oRange.computeFunction(com.sun.star.sheet.GeneralFunction.VAR)
print variance'StdDev (ver)
stdDev = oRange.computeFunction(com.sun.star.sheet.GeneralFunction.STDEV)
print stdDev

== CODE BLOCK 2 ==
function CHISQINV (erro, degree)dim oFunction as variant
oFunction = createUnoService("com.sun.star.sheet.FunctionAccess")
dim aArgument(1 to 2) as variant
dim result as doubleaArgument(1)=erro
aArgument(2)=degree result = oFunction.callFunction("CHISQ.INV",
aArgument())CHISQINV = resultend function

-- 
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

[libreoffice-users] Re: How to Turn a Landscape Table by 90 Degrees into a Portrait Table

[Pedro]

LibreOfficeZomi wrote
> *Once I found one, in OpenOffice.org Writer 3.0.1, but the table could
> only
> be turned  right-to-left vertical. What I wanted was to turn it
> left-to-right vertical.*
> 
> *That means, the table on the landscape page should be turned in order
> that
> the top of the table should be on the left margin on the portrait page,
> not
> on the right margin of the portrait page.*
> 
> *Now that I no longer use OpenOffice,org and only use LibreOffice, I do
> not
> know whether OpenOffice.org Writer has this feature. *
> 
> *The answer for this question should be in LibreOffice Writer.*

Yes, this is possible with LibreOffice 4.4. 

You can select if the text in a Table cell is rotated by 90 or 270 degrees.
You define this is Paragraph Style > Position > Rotation

Hope this helps.



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-Turn-a-Landscape-Table-by-90-Degrees-into-a-Portrait-Table-tp4152671p4152820.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

[libreoffice-users] Re: help track an issue

[Pedro]

Since you are running Linux, everything is easier :)

http://ask.libreoffice.org/en/question/20682/how-to-enable-libreoffice-logging/

Hope this helps!



--
View this message in context: 
http://nabble.documentfoundation.org/help-track-an-issue-tp4152664p4152666.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

[libreoffice-users] Re: LOOKUP with 2 values in 2 columns

[Pedro]

Hi Rob


Rob wrote
> How can I lookup 2 values set in Performed E1 and F1 in the main list?

I believe it is not possible to lookup in two columns. The best way is to
create a combined search field in column C of the Mainlist something like
=A1&"_"&B1
On the Performed tab you can either do the same (have 3 columns) or a single
column with just the combined code e.g. 297_b and do the lookup from the
Mainlist

If someone knows a more elegant/efficient way I would also be interested in
learning.

Hope this helps.
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/LOOKUP-with-2-values-in-2-columns-tp4150874p4150884.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

[libreoffice-users] Re: open files automatically

[Pedro]

Hi Andreas, all


Andreas Säger wrote
> Am 31.05.2015 um 19:18 schrieb Pedro:
> 
>> Is there a way to make it autorun on start?
> 
> Tools>Customize... [Events]
> Save in: 
> 
> Event: 
> 
> Macro: MyMacros.Library.Module.onApplicationStart

Brilliant! That worked perfectly. Thank you, Andreas!

Thomas Blasejewicz, there you have it. Two possible solutions: Andreas'
macro set to AutoStart (which works on any OS) OR Luuk's batch file (written
for Windows but it is probably easy to convert for Linux...)

Hope one of the solutions works for you.



--
View this message in context: 
http://nabble.documentfoundation.org/open-files-automatically-tp4149584p4150138.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

[libreoffice-users] Re: open files automatically

[Pedro]

Hi Luuk


Luuk wrote
> There's no need to automate Calc (or LO)
> 
> simply create a file
> name it something like 'autostartLibreoffice.bat'
> (or anything else, as long as the name ends in '.bat'

That has been suggested before. The OPs request is that LibreOffice opens
all files stored in a given folder. This means that he can add/remove files
from the folder as needed without having to edit a script/batch file.



--
View this message in context: 
http://nabble.documentfoundation.org/open-files-automatically-tp4149584p4150117.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

[libreoffice-users] Re: open files automatically

[Pedro]

Hi Andreas, all


Andreas Säger wrote
> Feel free to do what you want with it. I won't elaborate any further
> since this is a feature I would not use by myself.

I don't intend to use it either. I'm just trying to find a user friendly
solution to the OPs problem. And you seem to be the right person to solve
this :)


Andreas Säger wrote
> The right location for the AutoStart folder is your default document
> folder ("My Documents") as set up in menu:Tools>Options>Paths. This is
> system independent and every user who wants to use this can take care
> about the gory details:
> -- Move AutoStart after changing the default folder.
> -- Mind that directory names are case insensitive under Windows but case
> sensitive under regular systems.
> -- In order to keep this as simple as is (no error handlers), you must
> not drop any files into that folder that can not be loaded by your
> office suite.

Everything works fine (i.e. all documents in the AutoStart folder are
launched) except that the onApplicationStart macro is not executed when
LibreOffice is opened.

Is there a way to make it autorun on start?



--
View this message in context: 
http://nabble.documentfoundation.org/open-files-automatically-tp4149584p4150106.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

[libreoffice-users] Re: open files automatically

[Pedro]

Hi Andreas, all


Andreas Säger wrote
>>> On 28/05/2015 16:38, James Knott wrote:
> 
>>> Write a utility that creates a "Work Area" folder, regardless of the
>>> platform one uses.
>>> An interesting challenge for somebody who is good at PERL or Python
>>> coding.
> 
> Sub onApplicationStart()
> oSrv = createUnoService("com.sun.star.util.PathSettings")
> sPath = PathConcat(oSrv.Work, "AutoStart")
> sDir = PathConcat(sPath, "*.*")
> s = dir(sDir)
> while len(s)
>   sPathName = PathConcat(sPath,s)
>   StarDesktop.loadComponentFromURL(sPathName, "_blank", 0, Array())
>   s = dir()
> wend
> End Sub
> 
> Function PathConcat(s1, s2)
>   if right(s1,1) <> "/" then s1 = s1 & "/"
>   PathConcat = s1 & s2
> End Function

I can't test if this script does what the OP asked for. Where should the
AutoStart folder be placed when using a Windows OS or in a Linux OS?

Would it be possible to take this effort further and evolve this script into
an extension with a point-and-click interface to select the Autostart
folder?

Maybe some other people would find this feature useful and it is probably
more likely that this can be added as an extension rather than as a new
feature...

Just my 2 cents



--
View this message in context: 
http://nabble.documentfoundation.org/open-files-automatically-tp4149584p4150066.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

[libreoffice-users] Re: open files automatically

[Pedro]

Hi Thomas


Thomas Blasejewicz-3 wrote
> In case there is a stand-alone spreadsheet program (NOT Excel!) that can 
> do this trick ..
> I would love to learn its name.

Interesting feature. That wasn't available in the Lotus DOS days probably
because you could only open one file at a time :)

The short answer is: LibreOffice does not have that feature. I am not aware
of any free or commercial spreadsheet that does that.

The long answer: 

Since LibreOffice is a free open source software you can ask for that
feature to be added by submitting an Enhancement Request in the TDF Bugzilla
https://bugs.documentfoundation.org/

It is submitted as any other bug. Choose Calc(*) in the Component box and
"enhancement" in the Severity box.
Obviously this will be added to the list and is depending on a developer
getting interested on your problem.

Alternatively you can set a Bounty (e.g. https://www.bountysource.com/), try
Crowdfunding (e.g. https://freedomsponsors.org/) or pay a company like
Collabora to add the feature
(https://libreoffice-from-collabora.com/consultancy/)

Note: I'm not affiliated with TDF or any of the sites mentioned. There are
probably other companies/sites/solutions.

Hope this helps.

(*) Actually because LibreOffice can open many file formats this could be
added as a General feature where you could have text, spreadsheets,
presentations, etc in the Startup folder that would open when LibreOffice
opens ;) I bet quite a few people would find this feature interesting!



--
View this message in context: 
http://nabble.documentfoundation.org/open-files-automatically-tp4149584p4149773.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

[libreoffice-users] Re: Libre Office 4.4

[Pedro]

TR-2 wrote
> cannot change the "Recent Files" view page - would like not to have the 
> default page showing the file thumbnails.

Unfortunately that is _not_ an option. 

But there is a workaround in a request to add such an option
https://bugs.documentfoundation.org/show_bug.cgi?id=74834

Hope this helps.




--
View this message in context: 
http://nabble.documentfoundation.org/Libre-Office-4-4-tp4149152p4149339.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

[libreoffice-users] Re: last editing position

[Pedro]

Thomas Blasejewicz-3 wrote
> On 2015/05/07 13:24, V Stuart Foote wrote:
>> @Thomas,
>>
>> Yes that is correct, it was not fixed in 4.4 until the 4.4.3.1 build as
>> noted in the BZ issue.
>>
>> Update to 4.4.3.2 (now in pre-release) or move to a current build of a
>> Tinderbox  master.
>>   
>> Stuart
> 
> Just tried the operation on LibreOffice 4.2.7.2 installed on an xubuntu 
> 14.04 machine.
> Works just fine ...
> 
> What is Tinderbox master?

Tinderbox is a computer producing daily builds (which are Development
builds, not installed over your 4.4.2.2)

I advise you to get the 4.4.3.2 which works as expected (and is EXACTLY the
same as version 4.4.3 which will be officially released this week)

http://dev-builds.libreoffice.org/pre-releases/win/x86/LibreOffice_4.4.3.2_Win_x86.msi

you can also get the offline help for your location from the same folder

http://dev-builds.libreoffice.org/pre-releases/win/x86/

(scroll down and ignore the 5.0alpha files which are also Development
builds)

Hope this helps.



--
View this message in context: 
http://nabble.documentfoundation.org/last-editing-position-tp4148055p4148091.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

[libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

[Pedro]

Tanstaafl wrote
> 
> ROWS. NOT CELLS. AND NOT COLUMNS.

The same applies to selecting rows or columns. No delay.

No need to shout. You are being unnecessarily rude.



--
View this message in context: 
http://nabble.documentfoundation.org/Please-confirm-Calc-bug-discontiguous-selection-of-rows-right-click-is-very-slow-tp4146530p4146562.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

[libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

[Pedro]

Tanstaafl wrote
> The problem is in Calc, has to do with selecting discontiguous rows and
> a subsequent right-click action
> 
> The more discontiguous rows you select, the slower the right-click is to
> respond.

Right click is immediate regardless of the number of discontiguous cells
selected in my Windows XP Pro x86 SP3 machine (a 7 year "old" Core 2 Duo
with 2GB RAM) running LibreOffice 4.4.3.1 

Maybe the problem you are experiencing has already been solved?



--
View this message in context: 
http://nabble.documentfoundation.org/Please-confirm-Calc-bug-discontiguous-selection-of-rows-right-click-is-very-slow-tp4146530p4146558.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

[libreoffice-users] Re: No "help" exists for IFERROR function

[Pedro]

Tim Deaton wrote
> I'm using version 4.3.5.2 on Windows 7, and this past week imported a 
> spreadsheet from GoogleDocs.  The person I got it from exported it from 
> GoogleDocs into .ods format, and when I got it I found a lot of cells 
> with error messages.
> 
> The cause of the error messages was a lot of "=_xlfn.iferror((xxx))" 
> entries.  I searched LO help and found no reference to an IFERROR 
> function, so I thought that function did not exist in LO.  So I spent 
> hours replacing all those "=_xlfn.iferror((xxx))" entries with 
> "if(iserror(xxx),0,xxx)" entries.

I just tried that but exporting to ODS with GoogleDocs and opening in
LibreOffice 4.3.6 (the latest version in the stable 4.3 branch released in
February 20th) shows no problems at all with IFERROR.

Can you please try that with your file? If for some reason you do not have
permission to update LibreOffice, you can always use the Portable version
from
http://sourceforge.net/projects/winpenpack/files/X-LibreOffice/releases/

In any case it is indeed a "missing feature"  that the functions are not
described in the documentation (either the on-line or the off-line help)

Hope this helps



--
View this message in context: 
http://nabble.documentfoundation.org/No-help-exists-for-IFERROR-function-tp4145460p4145482.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