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

2017-09-21 Thread MR ZenWiz
On Thu, Sep 21, 2017 at 1:23 AM, Pedro  wrote:
:
> 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.
>
Yes, greatly, thanks.  It seems it was slightly worse - all the user
data was blanked out in the file(s).

-- 
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 Base Queries, Forms & Reports not appearing

2017-09-21 Thread Alexander Thurgood
Le 21/09/2017 à 15:16, Marion & Noel Lodge a écrit :

Hi Noel,

If you are using macros to open windows/dialogs in your database, then
you need to be aware of bug 95191. It is quite a serious hindrance to
cross-platform Base implementation, and has been around now for nearly 2
years...


Alex




> Hi Alexander & Robert,
> 
> Thank you both for your responses and suggestions.  Sorry about the delayed
> reply - I've had limited access to the User's Mac.
> 
> It is with a rather red face that I report that the problem was caused by
> me forgetting to load a Library file of 45 functions that I have written
> which form a central part of the system!  The Library file is loaded under
> My Macros | Standard and is stored with LO files.  It is not part of the
> .odb file.  I do it that way because the functions are common to all the
> databases I have written.
> 
> When I've forgotten to load the Library other times, (on Windows PCs),
> I've had an error message when the database has been initializing, telling
> me it can't find a particular function, and this has alerted me to what the
> problem is.  But the Mac reacted differently, so I assumed that it was a
> Mac problem.  Bad assumption!  Sorry I bothered you.
> 
> However, I did unzip the .odb file as you suggested, and examining the code
> alerted me to all the calls to the Library functions.  So your advice did
> lead me to the solution.  Once the Library file was in place, all the
> Queries, Forms and Reports magically appeared!
> 
> Much of the system is now working, but I'm still having problems opening
> the main menu.  I discovered that I have used a few calls to Windows
> functions, which naturally, the Mac takes a very dim view of!  I've tracked
> down several of these, but I think there must be more.  I knew that porting
> to the Mac would be difficult, but I'm now hopeful that I'll get there in
> the end.
> 
> Many thanks for your help
> 
> Noel
> --
> Noel Lodge
> lodg...@gmail.com
> 
> On 15 September 2017 at 16:50, Alexander Thurgood 
> wrote:
> 
>> Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit :
>>
>> Hi Noel,
>>
>> I don't know of any particular configuration setting that might cause
>> this, unless there is something physically wrong with the file itself.
>>
>> Some possibilities to explore :
>>
>> - if you have automatic document backups (AutoSave) configured on the
>> Mac LO, turn that off, restart LO and see if it makes a difference.
>> There is/was a known bug that affected the display of some ODB files
>> when this option was activated ;
>>
>> - compare the files on both OSes to check that they are identical (in
>> structure and content) by unzipping each one ;
>>
>> - when you create a query in H2 via LO, is it stored within the H2
>> database schema, for which the LO ODB would merely contain a reference
>> (with a file path, which would be different between Win/Mac)  OR is the
>> query stored within the LO ODB in full SQL ?
>>
>>
>> The fact that you can't see any of the Queries, Reports, Forms, might
>> indicate a problem with the paths in the XML sections of the ODB file
>> that defines each of these.
>>
>>
>> Alex
>>
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
>> unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
> 



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


Re: [libreoffice-users] Re: LO Base Queries, Forms & Reports not appearing

2017-09-21 Thread Marion & Noel Lodge
Hi Alexander & Robert,

Thank you both for your responses and suggestions.  Sorry about the delayed
reply - I've had limited access to the User's Mac.

It is with a rather red face that I report that the problem was caused by
me forgetting to load a Library file of 45 functions that I have written
which form a central part of the system!  The Library file is loaded under
My Macros | Standard and is stored with LO files.  It is not part of the
.odb file.  I do it that way because the functions are common to all the
databases I have written.

When I've forgotten to load the Library other times, (on Windows PCs),
I've had an error message when the database has been initializing, telling
me it can't find a particular function, and this has alerted me to what the
problem is.  But the Mac reacted differently, so I assumed that it was a
Mac problem.  Bad assumption!  Sorry I bothered you.

However, I did unzip the .odb file as you suggested, and examining the code
alerted me to all the calls to the Library functions.  So your advice did
lead me to the solution.  Once the Library file was in place, all the
Queries, Forms and Reports magically appeared!

Much of the system is now working, but I'm still having problems opening
the main menu.  I discovered that I have used a few calls to Windows
functions, which naturally, the Mac takes a very dim view of!  I've tracked
down several of these, but I think there must be more.  I knew that porting
to the Mac would be difficult, but I'm now hopeful that I'll get there in
the end.

Many thanks for your help

Noel
--
Noel Lodge
lodg...@gmail.com

On 15 September 2017 at 16:50, Alexander Thurgood 
wrote:

> Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit :
>
> Hi Noel,
>
> I don't know of any particular configuration setting that might cause
> this, unless there is something physically wrong with the file itself.
>
> Some possibilities to explore :
>
> - if you have automatic document backups (AutoSave) configured on the
> Mac LO, turn that off, restart LO and see if it makes a difference.
> There is/was a known bug that affected the display of some ODB files
> when this option was activated ;
>
> - compare the files on both OSes to check that they are identical (in
> structure and content) by unzipping each one ;
>
> - when you create a query in H2 via LO, is it stored within the H2
> database schema, for which the LO ODB would merely contain a reference
> (with a file path, which would be different between Win/Mac)  OR is the
> query stored within the LO ODB in full SQL ?
>
>
> The fact that you can't see any of the Queries, Reports, Forms, might
> indicate a problem with the paths in the XML sections of the ODB file
> that defines each of these.
>
>
> Alex
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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


[libreoffice-users] Re: LibreOffice - Macro - Java - Eclipse

2017-09-21 Thread Alexander Thurgood
Le 19/09/2017 à 13:38, Thomas Wielatt a écrit :

Hi Thomas,

> Is there anyone working on this kind of feature or is there any
> developer group where to ask this question?
> 

Unlikely that anyone is working on this and I doubt that Eclipse
integration as the IDE of choice for programming macros in LibreOffice
is going to come about anytime soon.

The aim is to reduce dependency on Java within LibreOffice, not to
increase it. That aim does not mean that the Java UNO bridge is going to
disappear anytime soon, but it does mean that if you want to integrate
Eclipse as your IDE for macro (or I presume Java tool programming)
development, you will be pretty much on your own.

Eclipse has been used previously to develop extensions for LO, but you
would probably be better off asking questions about that on the dev
mailing list or dev irc.


Alex



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


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

2017-09-21 Thread Steve Edmonds



On 21/09/17 20:23, Pedro wrote:

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


Thanks Pedro.
I knew this had come up before but I could not remember the details.
steve


--
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: Cursor position lost every time file is closed in 5.4.1

2017-09-21 Thread 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