Re: [libreoffice-users] Writer Hyperlink Oddity

[gordon cooper]

Hello Dale,
 I have not met this problem (yet!). If you create a
hyperlink to a pdf document, but without the 'a' unfinished indicator
I take it that the hyperlink remains unchanged regardless of the
file being accessed again.  It appears to be an issue with the single
character. Perhaps if you omitted the final underbar so that the
link read  8a instead of 8_a. The 'a' could be deleted when the
document is complete, just as you are doing now.

I know that this does not tell you why this occurs, but it might cure it.
Am working with hyperlinks while editing multi-lingual translations of
a system manual and have met several unexpected issues. Yours may
be yet to come!

Gordon
Tauranga
New Zealand.

On 14/05/16 08:06, Dale H. Cook wrote:

I have an odd problem with document hyperlinks in Writer, one which I never 
experienced when using Open Office or, before that, Word.

I have many Writer files containing hyperlinks to PDF documents on my hard drives. The problem only occurs when I create a hyperlink to a document still being added to 
such as "Dockets_1896-1897_08_a.pdf." The hyperlink looks fine in Writer when I create it, but when I come back to the Writer file some hours or days later the 
visible hyperlink has changed to "Dockets_1896-1897_08 _a .pdf" where the spaces between "08" and "_a" and between "_a" and 
".pdf" are so narrow as to be almost invisible, and where"Dockets_1896-1897_08" "_a" and ".pdf" are three separate hyperlinks, 
all with the original destination.

After finishing the additions to the document I change the filename, destination, and hyperlink to 
"Dockets_1896-1897_08.pdf" (the "_a" is only there to show that the PDF is not yet 
complete) and never again have a problem with that hyperlink. What is puzzling is that only some of the 
hyperlinks with the "_a" suffix suffer from this problem - not all of them. Any ideas?

Dale H. Cook, Member, NEHGS and MA Society of Mayflower Descendants;
Plymouth Co. MA Coordinator for the USGenWeb Project
Administrator of http://plymouthcolony.net





--
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] Data filtering with Base

[Egbert Eissing]

 
Hello,
I encounter a bigproblem by filtering data in a form by a date. Several days 
ofexperimenting did not produce any working result. 
On of many filterstrings I experimented with is as follows:sFilter= chr(34) 
 & chr(34) & " = " & chr(39) &(sDescription) & chr(39) & " AND " & 
chr(34) &"Expense"& chr(34)&"."(34)&"dateEntered"& chr(34) & " = " & 
chr(39) & aDate (39) This produces anerror message: “incorrect property 
value”
Another filterstring which looks more promising goes like this:sFilter= chr(34) 
 & " = " & chr(39) & sDescription (39) & " AND " & 
"Expense"&"."&"dateEntered " & ">= " & chr(39) & fDate & chr(39) & chr(34) The 
result shown ina message box looks as follows:"Description ='SalaryMidMonth' 
AND Expense.dateEntered >= '16/04/2016'"
After applying thisfilter, no data is shown on the form, instead the following 
errormessage:The data contentcould not be updated | Syntax error in SQL 
statement. 
If I remove the date part of the filter, the filtering works fine. I believe 
theproblem is in the expression “ Expense.dateEntered “. Unfortunately I need 
tospecify the table name, because the query has two tables, both ofwhich have a 
“dateEntered” column. In all my previous datafiltering with dates, a table did 
not need to be specified, and italways worked without problem. 
Here is yet anotherfilter formulation (same as before, but chr(34)) on both 
ends removed:sFilter= sSearchfield & " = " & chr(39) & sDescription (39) & 
" AND " & "Expense"&"."&"dateEntered " & ">= " & chr(39) & fDate & chr(39) 
msgbox output:Description ='SalaryMidMonth' AND Expense.dateEntered >= 
'16/04/2016'This filter filterscorrectly by “Description”, but does not filter 
by date.
I have also beenexperimenting with different formats of the date specification, 
suchas “2016-04-16” as well as the “dim aDate as Newcom.sun.star.util.Date” 
format. 
The column in theunderlying mySQL database table is of the “Date” type. 
Can anybody help meby pointing out what is wrong with the above filter 
composition?Thanks very much inanticipationEgbert Eissing
-- 
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] Writer Hyperlink Oddity

[Dale H. Cook]

I have an odd problem with document hyperlinks in Writer, one which I never 
experienced when using Open Office or, before that, Word.

I have many Writer files containing hyperlinks to PDF documents on my hard 
drives. The problem only occurs when I create a hyperlink to a document still 
being added to such as "Dockets_1896-1897_08_a.pdf." The hyperlink looks fine 
in Writer when I create it, but when I come back to the Writer file some hours 
or days later the visible hyperlink has changed to "Dockets_1896-1897_08 _a 
.pdf" where the spaces between "08" and "_a" and between "_a" and ".pdf" are so 
narrow as to be almost invisible, and where"Dockets_1896-1897_08" "_a" and 
".pdf" are three separate hyperlinks, all with the original destination.

After finishing the additions to the document I change the filename, 
destination, and hyperlink to "Dockets_1896-1897_08.pdf" (the "_a" is only 
there to show that the PDF is not yet complete) and never again have a problem 
with that hyperlink. What is puzzling is that only some of the hyperlinks with 
the "_a" suffix suffer from this problem - not all of them. Any ideas?

Dale H. Cook, Member, NEHGS and MA Society of Mayflower Descendants;
Plymouth Co. MA Coordinator for the USGenWeb Project
Administrator of http://plymouthcolony.net 


-- 
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] generator numbers + letters (random) for CALC how?

[manuel_songokuh]

hi
i wish to use calc libreoffice for my work, list archiver for my inventary and 
video 10.000 and other stuffs..but for calc how i can add formule easy..?
my dream:add extention or add new feature for random (generator):-upper case 
letters
-lower case letters-numbers-number of letters
is it possible for to create new feature or not?
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] damaged file issue

[John R. Sowden]

Whenever I start LO 5, I get a message about a file that is damaged and 
I am asked if I want to fix it.  I say yes, LO comes back and says it 
cannot be fixed.


I am able to access the file (password protected SS) with no problem.

I am offered the option of deleting information regarding fixing the 
problem.  Once when this happened months ago, I said yes.  I got an 'are 
you sure?' msg box.  This worries me.


Q1: Why am I receiving this when I can access the file fine?

Q2: What is in the file that has recovery information; is the the 
damaged file?


Q3: Is the fact that the file is password protected a factor here?


Ubuntu 14.04

John



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

Re: [libreoffice-users] Libre Office for Androids

[charles meyer]

Hi Jorge,

Thank you so much for sharing that.

I used Open Office before I switched to Libre in Windows and found
them fairly close function-wise.

I'll share there's an Android OO for her tablet with my friend.

Thank you again for kindly sharing that.

Best,

Charles.

Subject: Re: [libreoffice-users] Libre Office for Androids
Date: Thu, 05 May 2016 21:02:12 -0600
From: jorge 
To: charles meyer 
CC: users@global.libreoffice.org 

Hi Charles and all:

Until I know, LO for Android is in progress but at this moment as a
viewer only and Alpha or begining Beta version (not stable) for LO as we
use in GNU / Linux and windows.

There is an other version that could help you and your friend: This is
Aoo (Android OpenOffice). It is a version of OpenOffice for Android.
I've used it and it works good (In general as I probed: Writer, and
Calc). It is the nearest of LO at this moment that I know.

As I read, Aoo is based on OpenOffice but is not part of Apache Fundation.

I suggest to your friend that use keyboard and mouse with your tablet too.

Regards,

Jorge Rodríguez

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

Re: [libreoffice-users] document confidentiality failure

[Cley Faye]

At least on 5.1.1.3 (Windows x64) this "bug" doesn't happen. I can see the
recent document lists in the combobox, but if I clear the document history
autocompletion will not show them back; it merely does autocomplete on file
path and not on the document history...

-- 
Cley Faye
http://cleyfaye.net

2016-05-13 0:13 GMT+02:00 message :

> Readers,
>
> Please be aware of the following bug:
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=99187
>
> --
> 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] welcome screen keyboard shortcuts strange behavior

[Ady Ady]

When opening LibreOffice 5.0.6.3 under Windows ("soffice.exe"), there
are shortcut keys that are supposed to perform a certain task, such as
creating a new Writer Document. The relevant keys are shown as
underlined (e.g. the letter "D" for a new Writer Document).

The same shortcuts are also available in older versions. When I was
using the older 4.4.x branch, these shortcuts were working correctly;
after opening LibreOffice ("soffice.exe") I was able to launch Writer
by simply pressing "d". After updating to 5.0.6.3, this same effect
(opening Writer) is _not_ being triggered by the same action (pressing
"d" on the keyboard).

Now, after opening LibreOffice 5.0.6.3 ("soffice.exe") if I open Writer
(by other means, instead of using the keyboard shortcut) at least once
and then close Writer again (thus, going back to the initial
LibreOffice screen), then the keyboard shortcuts start to work
correctly; i.e. pressing "d" will open Writer.

These shortcut keys will continue to work correctly, until I close
LibreOffice completely. When opening LibreOffice 5.0.6.3
("soffice.exe") again, the shortcuts will not work unless I open one of
the components (such as Writer) at least once, and then close the
component, as I described before.

Searching the web, I tried to use an adequate set of terms that would
lead me to some information about the matter, but I failed.

1_ Is this a known issue?

2_ Can it be replicated by other users?

3_ Is it present under other OS?

4_ Is there some new option that might have changed the prior behavior?
Perhaps the specific key's combinations have changed in some way?

5_ Is it still present in newer versions (such as the 5.1.x branch)?

6_ Is there a bug report already opened?

TIA,
Ady.

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