date:20111214

It is a first for me, I download OS's and other large files regularly.

Thanks, again.

On 12/14/2011 7:03 PM, David S. Crampton wrote:
> I don't know why. Sorry experience suggested it. I have seen this
> behavior on 3 different antivirus scanners over the years. All in
> Windows OS. No useful user feedback.  Not even an event registered to
> event logs.
> 
> If you download a lot you might see it in other downloads. I answered a
> similar question in this forum about a month ago. Same thing.
> 
> I can see it in theory. The scanner is looking for "tokens" or sequences
> of binary code that are associated with virus / worm executables.  It's
> not improbable that a huge download, using compression, would generate
> enough of similar looking binary string to trigger a false positive.
> 
> Why the antivirus scanner doesn't tell you what's happened? Mystery.
> 
> I'm glad you got it,
> David
> 
> On Wed, 14 Dec 2011 15:30:52 -0800, M Robinson 
> wrote:
> 
>> That worked. Why does that work?
>> I'm using Avast 6.0.1367, and it hasn't thrown any flags while silently
>> killing ONLY LibreOffice Portable downloads.
>>
>> On 12/14/2011 6:14 PM, David S. Crampton wrote:
>>> Try to turn off your realtime antivirus scanner. Unload it or stop the
>>> process.
>>>
>>> On Wed, 14 Dec 2011 13:33:40 -0800, Pedro  wrote:
>>>

 M Robinson wrote
>
> What's the story with LibreOffice Portable, I've been
> trying to
> download the file since PortableApps released version 10. It doesn't
> matter which site a attempt to download from I end up with an
> incomplete
> file of 19.9 MB, the downloads start with a file side of 121 MB.
>

 That seems to be a problem with the PortableApps mirrors or your
 download
 manager.
 Try to get LibreOffice separately from
 http://portableapps.com/apps/office/libreoffice_portable

 In any case you should ask at the PortableApps forum since
 LibreOffice or
 TDF can't help you on this problem ;)

 -- 
 View this message in context:
 http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html


 Sent from the Users mailing list archive at Nabble.com.

> 


-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton

I don't know why. Sorry experience suggested it. I have seen this behavior  
on 3 different antivirus scanners over the years. All in Windows OS. No  
useful user feedback.  Not even an event registered to event logs.


If you download a lot you might see it in other downloads. I answered a  
similar question in this forum about a month ago. Same thing.


I can see it in theory. The scanner is looking for "tokens" or sequences  
of binary code that are associated with virus / worm executables.  It's  
not improbable that a huge download, using compression, would generate  
enough of similar looking binary string to trigger a false positive.


Why the antivirus scanner doesn't tell you what's happened? Mystery.

I'm glad you got it,
David

On Wed, 14 Dec 2011 15:30:52 -0800, M Robinson   
wrote:



That worked. Why does that work?
I'm using Avast 6.0.1367, and it hasn't thrown any flags while silently
killing ONLY LibreOffice Portable downloads.

On 12/14/2011 6:14 PM, David S. Crampton wrote:

Try to turn off your realtime antivirus scanner. Unload it or stop the
process.

On Wed, 14 Dec 2011 13:33:40 -0800, Pedro  wrote:



M Robinson wrote


What's the story with LibreOffice Portable, I've been trying  
to

download the file since PortableApps released version 10. It doesn't
matter which site a attempt to download from I end up with an  
incomplete

file of 19.9 MB, the downloads start with a file side of 121 MB.



That seems to be a problem with the PortableApps mirrors or your  
download

manager.
Try to get LibreOffice separately from
http://portableapps.com/apps/office/libreoffice_portable

In any case you should ask at the PortableApps forum since LibreOffice  
or

TDF can't help you on this problem ;)

--
View this message in context:
http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html

Sent from the Users mailing list archive at Nabble.com.



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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

On 12/14/2011 5:24 PM, Jay Lozier wrote:
> On 12/14/2011 02:35 PM, toki wrote:
> On 14/12/11 16:19, David S. Crampton wrote:
> 
 looking at web apps was PEOPLE; specifically problems with our
 in-house people.
> Migrating to the cloud hides the people problem.  It does not remove it.
> For sensitive data, the cloud merely compounds the issues.
>> +1, my main complaint about the "Cloud" is that it is a marketing term
>> and refers to using:
>> a, server data storage with client applications
>> b. server data storage with server applications.
> 
>> The first is implemented by many companies to varying degrees, data and
>> documents can be shared by using a server while individuals work on a
>> local copy with applications on their computers. Depending on how the
>> sharing and integration is set up you may only need occasional access to
>> the data server. If the data server goes down, you may be able to
>> continue working.
> 
>> The second is basically a return to the mainframe with dumb terminals.
>> Those of us old enough to remember those days tend to shudder at this
>> regression (or more accurately stupidity). You are totally dependent on
>> the server/mainframe and the connection in addition to any local
>> problems. Server or connection goes down you are contemplating your
>> navel. Another problem with this model is there are finite limits to the
>> number connections and it is possible (not necessarily likely) to be
>> locked out due to all the connections being in use. I work on an online
>> application and we have limited administrative/vpn logins available and
>> periodically all the connections are taken.
 this calls for LO to build a community of support people that can
 support small to medium sized businesses and avoid the>  siren call
 of M$ style big money and big ego.

Good luck with that one. Firefox isn't making that much money, but they
are so wobbly, from trying to becoming THE 'platform', that I'm looking
for the next browser—Chrome isn't it, but the market share it is
devouring confirms that I'm not the only one that thinks Firefox is
risking a flaming-out trying to achieve orbit.

> More specifically, what is needed is more than a theoretical business
> plan. A small, profitable organization (2-10 people) that provides paid
> support for LibO to SOHO and SMB organizations that can "show" other
> individuals and organizations the path:
> * Tier 1 support;
> * Tier 2 support;
> * Tier 3 support;
> * Tier 4 support;
> 
> # What each tier includes;
> # How much to charge for each tier;
> # Charging on a per incident basis;
> # Contracts;
> # Etc;
> 
> Does anybody know of anything along these lines, that was written
> specifically for FLOSS support?  The economics of FLOSS support, and
> non-FLOSS support are very different.
> 
> jonathon
>>
> 
> 


-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

[libreoffice-users] Re: Change cell border sizes- quickly?

On 12/14/2011 02:35 PM, . wrote:
> 
> 
> On 12/14/2011 03:15 PM, NoOp wrote:
>> On 12/14/2011 04:26 AM, . wrote:
>>>
>>> On 12/14/2011 05:45 AM, MiguelAngel wrote:
>> ...
 With F11, select Default format, and change there the border.
 If there is another style non vinculated with default, change it also.

 Miguel Ángel
>>> Miguel, I tried it with one of the sheets but it had no effect.  I tried
>>> it with a new sheet but no effect either.
>>>
>>> Here's what I did;
>>>
>>> - opened the ods file I want to work on which has about 90 sheets within it.
>>> - hit F11
>>> - right clicked on Default in Styles and Formatting
>>> - change the Cell Borders to 1 pt. and selected Default under Line
>>> Arrangement
>>>
>>> At that point in the process the there's a lot of activity (so to speak)
>>> in the bottom of the Calc window...some progress bar flashing (so
>>> whatever it's called)  giving the impression that what I wanted to
>>> change is occurring.  However, a check of the cell formatting indicates
>>> that the cell border size wasn't changed.
>>>
>>> Any other ideas?
>> Works for me:
>>
>> LibreOffice 3.3.4
>> OOO330m19 (Build:401)
>> tag libreoffice-3.3.4.1
>>
>> and
>>
>> LibreOffice 3.4.4
>> OOO340m1 (Build:402)
> What "worked for you" and what did it accomplish?

The above instructions, changed the border sizes to 1 pt.

Select the entire sheet (clicking upper left corner), open styles
(either F11 or via the icon), right-click Default|Modify|Borders|Line
Width: 1.00pt|Line arrangement: second outline box under 'Default'.
Note: even changed the pt to 2pt and color to green, saved the file,
closed the file, reopened the file & the cell boarders are still 2pt/green.

...


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

Re: [libreoffice-users] Re: LibreOffice Portable

That worked. Why does that work?
I'm using Avast 6.0.1367, and it hasn't thrown any flags while silently
killing ONLY LibreOffice Portable downloads.

On 12/14/2011 6:14 PM, David S. Crampton wrote:
> Try to turn off your realtime antivirus scanner. Unload it or stop the
> process.
> 
> On Wed, 14 Dec 2011 13:33:40 -0800, Pedro  wrote:
> 
>>
>> M Robinson wrote
>>>
>>> What's the story with LibreOffice Portable, I've been trying to
>>> download the file since PortableApps released version 10. It doesn't
>>> matter which site a attempt to download from I end up with an incomplete
>>> file of 19.9 MB, the downloads start with a file side of 121 MB.
>>>
>>
>> That seems to be a problem with the PortableApps mirrors or your download
>> manager.
>> Try to get LibreOffice separately from
>> http://portableapps.com/apps/office/libreoffice_portable
>>
>> In any case you should ask at the PortableApps forum since LibreOffice or
>> TDF can't help you on this problem ;)
>>
>> -- 
>> View this message in context:
>> http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html
>>
>> Sent from the Users mailing list archive at Nabble.com.
>>
> 
> 


-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

Re: [libreoffice-users] Re: LibreOffice Portable

I'm using Pale Moon 6.0 and also tried it with Avant Ultimate 2012 build
8, Opera 11.51 Build 1087, IE version 9.0.8112.16421, and Chrome
15.0.874.121.

I anyone has any idea why I'm having problems let me know, I would like
to download LibreOffice Portable version 3.4.4. all downloads stalled
with errors at about 28 MB.

On 12/14/2011 5:31 PM, NoOp wrote:
> On 12/14/2011 11:54 AM, M Robinson wrote:
>> Hello,
>>
>> What's the story with LibreOffice Portable, I've been trying to
>> download the file since PortableApps released version 10. It doesn't
>> matter which site a attempt to download from I end up with an incomplete
>> file of 19.9 MB, the downloads start with a file side of 121 MB.
> 
> I suspect that Pedro is right about your download manager. I just
> downloaded via the LibreOffice mirror w/o issue:
> 
> http://ftp.osuosl.org/pub/tdf/libreoffice/portable/3.4.4/LibreOfficePortable_3.4.4_MultilingualNormal.paf.exe
> 
> That link is simply a mirror link via:
> http://www.libreoffice.org/download/portable/
> 
> 
> 

-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton

Try to turn off your realtime antivirus scanner. Unload it or stop the  
process.


On Wed, 14 Dec 2011 13:33:40 -0800, Pedro  wrote:



M Robinson wrote


What's the story with LibreOffice Portable, I've been trying to
download the file since PortableApps released version 10. It doesn't
matter which site a attempt to download from I end up with an incomplete
file of 19.9 MB, the downloads start with a file side of 121 MB.



That seems to be a problem with the PortableApps mirrors or your download
manager.
Try to get LibreOffice separately from
http://portableapps.com/apps/office/libreoffice_portable

In any case you should ask at the PortableApps forum since LibreOffice or
TDF can't help you on this problem ;)

--
View this message in context:  
http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html

Sent from the Users mailing list archive at Nabble.com.




--
David S. Crampton

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

Re: [libreoffice-users] Re: LibreOffice Portable

Thanks, version 3.4.3 installed without issue.

I like the remove extra languages option, that was one of the reasons I
wanted to download LibreOffice:

http://server-support.co/blog/pc/trimming-down-libreoffice-portable/

However, the poster claims he got the LibreOffice foot print down to
215.MB. WinDirTree shows my LibreOffice 3.4.3 Portable Folder at 253.2 MB

On 12/14/2011 5:07 PM, webmaster for Kracked Press Productions wrote:
> On 12/14/2011 04:33 PM, Pedro wrote:
>> M Robinson wrote
>>>  What's the story with LibreOffice Portable, I've been trying to
>>> download the file since PortableApps released version 10. It doesn't
>>> matter which site a attempt to download from I end up with an incomplete
>>> file of 19.9 MB, the downloads start with a file side of 121 MB.
>>>
>> That seems to be a problem with the PortableApps mirrors or your download
>> manager.
>> Try to get LibreOffice separately from
>> http://portableapps.com/apps/office/libreoffice_portable
>>
>> In any case you should ask at the PortableApps forum since LibreOffice or
>> TDF can't help you on this problem ;)
> 
> Try the downloading from this link.  See if it works for you.
> 
> http://libreoffice-na.us/English-3.4-installs/install.html
> 
> The files are hosted on a different server than the one listed above. 
> If there is an issue with their server, then it should be OK from my
> server listing.  There are 2 versions listed there as well.  All you can
> do is try.  The more places you can download the files from, the better
> it is for when the original server[s] are down or having issues.
> 
> As always, scan the downloaded .exe files with your anti-virus package. 
> Safety first.
> 
> 
> 
> 


-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

Re: [libreoffice-users] Re: Change cell border sizes- quickly?

2011-12-14 Thread .



On 12/14/2011 03:15 PM, NoOp wrote:
> On 12/14/2011 04:26 AM, . wrote:
>>
>> On 12/14/2011 05:45 AM, MiguelAngel wrote:
> ...
>>> With F11, select Default format, and change there the border.
>>> If there is another style non vinculated with default, change it also.
>>>
>>> Miguel Ángel
>> Miguel, I tried it with one of the sheets but it had no effect.  I tried
>> it with a new sheet but no effect either.
>>
>> Here's what I did;
>>
>> - opened the ods file I want to work on which has about 90 sheets within it.
>> - hit F11
>> - right clicked on Default in Styles and Formatting
>> - change the Cell Borders to 1 pt. and selected Default under Line
>> Arrangement
>>
>> At that point in the process the there's a lot of activity (so to speak)
>> in the bottom of the Calc window...some progress bar flashing (so
>> whatever it's called)  giving the impression that what I wanted to
>> change is occurring.  However, a check of the cell formatting indicates
>> that the cell border size wasn't changed.
>>
>> Any other ideas?
> Works for me:
>
> LibreOffice 3.3.4
> OOO330m19 (Build:401)
> tag libreoffice-3.3.4.1
>
> and
>
> LibreOffice 3.4.4
> OOO340m1 (Build:402)
What "worked for you" and what did it accomplish?


Here's a rather lengthy and complex cell border fix-

- open the ods file you want to correct all of the cell border sizes in.

- Click>File--->Save As---> OpenDocument Sheet Flat XML file (.fods)

- Exit Calc

- Open the .fods file you just saved with a simple text editor

- Search for the following line-  
>


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

[libreoffice-users] Re: LibreOffice Portable

On 12/14/2011 11:54 AM, M Robinson wrote:
> Hello,
> 
> What's the story with LibreOffice Portable, I've been trying to
> download the file since PortableApps released version 10. It doesn't
> matter which site a attempt to download from I end up with an incomplete
> file of 19.9 MB, the downloads start with a file side of 121 MB.

I suspect that Pedro is right about your download manager. I just
downloaded via the LibreOffice mirror w/o issue:

http://ftp.osuosl.org/pub/tdf/libreoffice/portable/3.4.4/LibreOfficePortable_3.4.4_MultilingualNormal.paf.exe

That link is simply a mirror link via:
http://www.libreoffice.org/download/portable/



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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Jay Lozier


On 12/14/2011 02:35 PM, toki wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 14/12/11 16:19, David S. Crampton wrote:


looking at web apps was PEOPLE; specifically problems with our in-house people.

Migrating to the cloud hides the people problem.  It does not remove it.
For sensitive data, the cloud merely compounds the issues.
+1, my main complaint about the "Cloud" is that it is a marketing term 
and refers to using:

a, server data storage with client applications
b. server data storage with server applications.

The first is implemented by many companies to varying degrees, data and 
documents can be shared by using a server while individuals work on a 
local copy with applications on their computers. Depending on how the 
sharing and integration is set up you may only need occasional access to 
the data server. If the data server goes down, you may be able to 
continue working.


The second is basically a return to the mainframe with dumb terminals. 
Those of us old enough to remember those days tend to shudder at this 
regression (or more accurately stupidity). You are totally dependent on 
the server/mainframe and the connection in addition to any local 
problems. Server or connection goes down you are contemplating your 
navel. Another problem with this model is there are finite limits to the 
number connections and it is possible (not necessarily likely) to be 
locked out due to all the connections being in use. I work on an online 
application and we have limited administrative/vpn logins available and 
periodically all the connections are taken.

this calls for LO to build a community of support people that can support small to 
medium sized businesses and avoid the>  siren call of M$ style big money and 
big ego.

More specifically, what is needed is more than a theoretical business
plan. A small, profitable organization (2-10 people) that provides paid
support for LibO to SOHO and SMB organizations that can "show" other
individuals and organizations the path:
* Tier 1 support;
* Tier 2 support;
* Tier 3 support;
* Tier 4 support;

# What each tier includes;
# How much to charge for each tier;
# Charging on a per incident basis;
# Contracts;
# Etc;

Does anybody know of anything along these lines, that was written
specifically for FLOSS support?  The economics of FLOSS support, and
non-FLOSS support are very different.

jonathon
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJO6PqWAAoJEEKevXexj2B11RoH/RuPjoS/F8/hSZ53FGfNgr/m
SXhVzVJnUhl722U06XbI1efeRVagY8Pf1GpFw1/jeIjvA6DDeWjL7sZdVskpaiWQ
MjMxNA2EzEwE7r6p4ugs3KQQejRymuLxprEaslix7s2VrW3lyzYqPjg8DHyMKtmA
mo5NGdgc1Cgj41wCzipkwibnQwWlq0ZHKQLFeE9UofP1/M1Q1LLvN6kZ6Rl0dCH9
beISC87/gYbkGUU1tvMXMF6QLtFcEfla9k5K1sAOcHYmwVsrDWqxd5i0pdAL9ZVf
7GYwStaEIBbkac+b+5TAMMG6/ktcZJtTtB1XF0hpqcRrjQJNvM2a5jlZZM1dIdw=
=eNUD
-END PGP SIGNATURE-




--
Jay Lozier
jsloz...@gmail.com


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

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Alexander Thurgood

Le 14/12/11 22:05, Mark Stanton a écrit :


Hi Mark,

> If I'm not mistaken (although I might be and I haven't got the time 
> to go back and check) and odb file is effectively a zip file with 
> various things in it.

Yes.

> I believe HSQL is a "cut down" database, on the basis that a lot of 
> the bells and whistles of a full database engine aren't required by 
> small applications.  Hence it's a small, fast database, without it's 
> own data storage, I imagine, since the data for it *is* kept in the 
> odb file.

Hmm, I wouldn't say "cut down", it is actually rather good, certainly in
its latest incarnation, which is not included as the engine for OOo/LO
ODB files.

It can be used with its own independent storage too, but then you have
to set it up in server/client mode, i.e. LO becomes the client (via and
ODB file) and hsqldb.jar runs as a "server". In the current setup of
LO/hsqldb, the data is effectively stored within the ODB file. In fact,
the whole of the hsqldb.jar is loaded into memory when the ODB file is
opened. This is then used (via a Java2uno bridge, at least that is how I
understand it) to access tables, queries, forms, etc, so everything
resides in memory, which is fine...until your app crashes, you run out
of memory, or you have a power cut, and then...you cry your heart out,
throw a wobbly, or swear til the air turns blue, when you discover your
precious ODB file has either been corrupted or the data you have been
entering for the last 3 hours has not been saved. And all of this is
absolutely not hsqldb's fault, but OOo/LO's because of the way it was
decided at the time to integrate hsqldb into OOo.

There are moves afoot to switch to SQLite as the default db backend
engine. Whether that will actually work, whether it will result in one
or several files, remains to be seen. Personally, I hope that the
multifile option will be chosen, and that we will just use the LO ODB
container as a front end, so that the db data will always be accessible
outside of the LO app and readable by any SQLite compliant reader.

Here's hoping...


Alex





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

[libreoffice-users] Re: LibreOffice Portable

On 12/14/2011 01:33 PM, Pedro wrote:
> 
> M Robinson wrote
>> 
>> What's the story with LibreOffice Portable, I've been trying to
>> download the file since PortableApps released version 10. It doesn't
>> matter which site a attempt to download from I end up with an incomplete
>> file of 19.9 MB, the downloads start with a file side of 121 MB.
>> 
> 
> That seems to be a problem with the PortableApps mirrors or your download
> manager.
> Try to get LibreOffice separately from
> http://portableapps.com/apps/office/libreoffice_portable
> 
> In any case you should ask at the PortableApps forum since LibreOffice or
> TDF can't help you on this problem ;)
...
http://www.libreoffice.org/download/portable/
"LibreOffice is packaged for portable use by PortableApps.com with
permission and assistance from The Document Foundation."








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

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread webmaster for Kracked Press Productions

On 12/14/2011 4:33 PM, Pedro wrote:
> 
> M Robinson wrote
>>
>> What's the story with LibreOffice Portable, I've been trying to
>> download the file since PortableApps released version 10. It doesn't
>> matter which site a attempt to download from I end up with an incomplete
>> file of 19.9 MB, the downloads start with a file side of 121 MB.
>>
> 
> That seems to be a problem with the PortableApps mirrors or your download
> manager.
> Try to get LibreOffice separately from
> http://portableapps.com/apps/office/libreoffice_portable
> 
> In any case you should ask at the PortableApps forum since LibreOffice or
> TDF can't help you on this problem ;)
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html
> Sent from the Users mailing list archive at Nabble.com.
> 
Fair enough, I've already posted to their forum. After a week I Thought
I would post here as well—LibreOffice.org IS linking to PortableApps.com
and claim to have some collaborative input.

If you are going to carry my flag carry it the right way. OpenOffice is
the PortableApps default office suite and it works, so they DO know how
to carry a flag.

-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

Re: [libreoffice-users] Re: LibreOffice Portable


On 12/14/2011 04:33 PM, Pedro wrote:

M Robinson wrote

 What's the story with LibreOffice Portable, I've been trying to
download the file since PortableApps released version 10. It doesn't
matter which site a attempt to download from I end up with an incomplete
file of 19.9 MB, the downloads start with a file side of 121 MB.


That seems to be a problem with the PortableApps mirrors or your download
manager.
Try to get LibreOffice separately from
http://portableapps.com/apps/office/libreoffice_portable

In any case you should ask at the PortableApps forum since LibreOffice or
TDF can't help you on this problem ;)


Try the downloading from this link.  See if it works for you.

http://libreoffice-na.us/English-3.4-installs/install.html

The files are hosted on a different server than the one listed above.  
If there is an issue with their server, then it should be OK from my 
server listing.  There are 2 versions listed there as well.  All you can 
do is try.  The more places you can download the files from, the better 
it is for when the original server[s] are down or having issues.


As always, scan the downloaded .exe files with your anti-virus package.  
Safety first.





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

[libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread Pedro


M Robinson wrote
> 
> What's the story with LibreOffice Portable, I've been trying to
> download the file since PortableApps released version 10. It doesn't
> matter which site a attempt to download from I end up with an incomplete
> file of 19.9 MB, the downloads start with a file side of 121 MB.
> 

That seems to be a problem with the PortableApps mirrors or your download
manager.
Try to get LibreOffice separately from
http://portableapps.com/apps/office/libreoffice_portable

In any case you should ask at the PortableApps forum since LibreOffice or
TDF can't help you on this problem ;)

--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Base can't open databases

On 12/14/2011 12:31 AM, Michael Bogaerts wrote:
> opgegeven URL beschikbaar is.English version;The connection with the 
> datasource 'main' couldn't be made.The connection with the external 
> datasource can't be made
> because there's no SDBC-driver available for the given URL.The thing 
> is though; i have made special 'links' to the SDBC files
>   in the options -java -classpath which link to the
>   correct directorieseven files (hsqldb.jar / sdbc_hsqldb.jar
>   / "Liboffice\basis\program\classes") but i guess it doesn't work.
>   Also; i have the idea that java doesn't get loaded by LibOffice.Now 
> please; help me if you can... what should i do; except turning
>   back to openoffice 3.3...  since that's really the very last thing
>   i'd like to do (not that i don't trust it... but their development
>   is so slow)Or should i consider LibOf 3.4 as 'unstable' and revert to 
> 3.3.4

Try 3.3.4.

Most likely related:

https://bugs.freedesktop.org/process_bug.cgi

That works in 3.3.4 for me, but not in 3.4.4.



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

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Mark Stanton

If I'm not mistaken (although I might be and I haven't got the time 
to go back and check) and odb file is effectively a zip file with 
various things in it.

As Tom said, LO (& Ooo, of course) really doesn't have a database 
section.  It has a gateway to a database, in fact different adapters 
for various databases.  This is really very sensible in most ways.  
It just talks to a database engine that is specifically built to do 
the data work and just gives back results.

I believe HSQL is a "cut down" database, on the basis that a lot of 
the bells and whistles of a full database engine aren't required by 
small applications.  Hence it's a small, fast database, without it's 
own data storage, I imagine, since the data for it *is* kept in the 
odb file.

I hope someone will correct me if I'm wrong in the technical details 
here.

Regards
Mark Stanton
One small step for mankind...



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

[libreoffice-users] Re: Change cell border sizes- quickly?

On 12/14/2011 04:26 AM, . wrote:
> 
> 
> On 12/14/2011 05:45 AM, MiguelAngel wrote:
...
>> With F11, select Default format, and change there the border.
>> If there is another style non vinculated with default, change it also.
>>
>> Miguel Ángel
> 
> Miguel, I tried it with one of the sheets but it had no effect.  I tried
> it with a new sheet but no effect either.
> 
> Here's what I did;
> 
> - opened the ods file I want to work on which has about 90 sheets within it.
> - hit F11
> - right clicked on Default in Styles and Formatting
> - change the Cell Borders to 1 pt. and selected Default under Line
> Arrangement
> 
> At that point in the process the there's a lot of activity (so to speak)
> in the bottom of the Calc window...some progress bar flashing (so
> whatever it's called)  giving the impression that what I wanted to
> change is occurring.  However, a check of the cell formatting indicates
> that the cell border size wasn't changed.
> 
> Any other ideas?

Works for me:

LibreOffice 3.3.4
OOO330m19 (Build:401)
tag libreoffice-3.3.4.1

and

LibreOffice 3.4.4
OOO340m1 (Build:402)



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

[libreoffice-users] LibreOffice Portable

2011-12-14 Thread webmaster for Kracked Press Productions

Hello,

What's the story with LibreOffice Portable, I've been trying to
download the file since PortableApps released version 10. It doesn't
matter which site a attempt to download from I end up with an incomplete
file of 19.9 MB, the downloads start with a file side of 121 MB.
-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread toki

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 14/12/11 16:19, David S. Crampton wrote:

> looking at web apps was PEOPLE; specifically problems with our in-house 
> people.

Migrating to the cloud hides the people problem.  It does not remove it.
For sensitive data, the cloud merely compounds the issues.

> this calls for LO to build a community of support people that can support 
> small to medium sized businesses and avoid the> siren call of M$ style big 
> money and big ego.

More specifically, what is needed is more than a theoretical business
plan. A small, profitable organization (2-10 people) that provides paid
support for LibO to SOHO and SMB organizations that can "show" other
individuals and organizations the path:
* Tier 1 support;
* Tier 2 support;
* Tier 3 support;
* Tier 4 support;

# What each tier includes;
# How much to charge for each tier;
# Charging on a per incident basis;
# Contracts;
# Etc;

Does anybody know of anything along these lines, that was written
specifically for FLOSS support?  The economics of FLOSS support, and
non-FLOSS support are very different.

jonathon
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJO6PqWAAoJEEKevXexj2B11RoH/RuPjoS/F8/hSZ53FGfNgr/m
SXhVzVJnUhl722U06XbI1efeRVagY8Pf1GpFw1/jeIjvA6DDeWjL7sZdVskpaiWQ
MjMxNA2EzEwE7r6p4ugs3KQQejRymuLxprEaslix7s2VrW3lyzYqPjg8DHyMKtmA
mo5NGdgc1Cgj41wCzipkwibnQwWlq0ZHKQLFeE9UofP1/M1Q1LLvN6kZ6Rl0dCH9
beISC87/gYbkGUU1tvMXMF6QLtFcEfla9k5K1sAOcHYmwVsrDWqxd5i0pdAL9ZVf
7GYwStaEIBbkac+b+5TAMMG6/ktcZJtTtB1XF0hpqcRrjQJNvM2a5jlZZM1dIdw=
=eNUD
-END PGP SIGNATURE-

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

Re: [libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Steve Edmonds


Hi.
Not sure if it would work, but what about the 3.3.4 release?
steve

On 2011-12-15 01:20, Michael Bogaerts wrote:

Hey Alex,

Thanks for the info..
But since i'm using CALC in a production enviroment i don't want to go 
'trying' with beta releases ...

I could though use a VM and see if it works there ...

Also; i thought that the tables were converted to ODF; but clearly 
they're not when i read your comments...


Is there a way to fully convert an MDB to ODF without keeping 'links'???
because actually that's what i wanted to do in the first place...

If i need an older version to do that, no problem; i'll temporarily 
install OO.O or so in a VM and do it with that, so that in my 
production enviroment i'm permanently freed of this MS dictatorship...


Thanks again for all your good help!




Met vriendelijke groeten,

Michael Bogaerts



De bij ons als "Alex Thurgood" geidentificeerde tegenpartij wist exact 
op 14/12/2011 10:39 uur het volgende uit de vingers te tokkelen:

Le 14/12/2011 09:31, Michael Bogaerts a écrit :

Hi Michael,


   with LibOffice.I removed OO.O first and then I installed 
LibOffice 3.4.4 (the
   latest release).Since that day i can't open my database files 
anymore; i can't
   read the original MDB files, nor can i open my odf files... 
well,

   i can open the odf files, but as soon as i open a table i get an
   errormessage. (it's dutch though, so i'll translate it for you


MDB file access, in fact the ADO, Access2003, Access2007, accdb file 
access was all broken in the 3.4.x versions up to and including 3.4.4.


Several fixes were entered into the master code branch for the 
upcoming 3.5 release, which appear to have solved this problem (still 
not perfect, but at least it now works - well in the tests I managed 
to do anyway). You may want to test with a beta release of 3.5 to see 
if you work with those files again.


I don't know whether the fixes are going to be integrated into a 
3.4.5 version.


Alex





__ 


Alle inkomende en uitgaande mail van mail.bogy.be wordt gescand op
spyware, spam enzomeer. Indien u toch problemen via deze mailserver zou
ondervinden, stuur dan de originele mail door naar i...@bogy.be

All incoming and outgoing mail from mail.bogy.be is scanned against 
spyware, spam, etc. If you would have any inconvenience from our 
services then do not hesitate to send the original mail to i...@bogy.be

Serverconfig: A64 3700+, 1.5GB Ram, +1 TB HD, WXP Pro, Mercury/32.

De inhoud van deze mail is enkel bestemd voor de ontvanger; indien u 
deze mail verkeerdelijk hebt ontvangen, gelieve de verzender hiervan 
op de hoogte te brengen en de inhoud niet verder te verspreiden.
The contents of this mail is solely intended for the individual whom 
it is addressed. If you received this mail in error, then please 
inform the sender and do not spread the contents of this mail any 
further.
__ 



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

Re: [libreoffice-users] Syntax Question

2011-12-14 Thread Ian Whitfield


On 14/12/2011 16:04, Gérard FARGEOT wrote:

=INDIRECT("Data."&Data.H5&Data.M9)
with Letters column identifier in Data.H5 and number row identifier in Data.M9

If column identifier is a number, you can use INDIRECT&  ADDRESS
=INDIRECT(ADDRESS(Data.M9;Data.H5;4;;"Data"))


Thanks Gerard

PERFECT - That works a treat - Just what I was looking for!!

Sometimes strange bits of syntax can be very hard to work out until you 
see it working and can learn it.


Thanks again

Ian Whitfield.


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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Joel Madero

Personally I think the priority of a cloud suite is much less than ensuring
that there is absolutely no bugs while moving files between Microsoft and
LO, if a new user opens a .doc with a few tables, footer, header, TOC,
etc... in LO and sees that it doesn't look right, they'll abandon it
immediately and probably never look back. This is an unfortunate truth that
we are at, it'd be nice to actually have a bug list that is just
compatibility between Microsoft and LO. Just my two cents

On Wed, Dec 14, 2011 at 8:19 AM, David S. Crampton
wrote:

> I will speak up a little for the positive case for cloud-based computing
> and apps.  In the IT Manager position I recently left the motivator for
> looking at web apps was PEOPLE; specifically problems with our in-house
> people.
>
> Making a long story short, I had built an entirely in-house M$ shop
> supported by people I hired plus occasional consulting especially for
> network / Cisco support.  We had about 12 servers, 160 desktops, a very
> elaborate WAN, M$ Suite plus an in-house M$ WSUS for their flood of
> updates.  The team was 3 people: myself, a sys admin and a desktop tech.
>
> The workload was heavy and I relied on the motivation of the two hired
> staff to be learning M$ stuff toward becoming full M$ experts.  The overall
> economics of in-house machines and fully burdened in-house staff made sense
> for a while.
>
> The people problems started as competition between my two staff people.
> Productivity and teamwork began to stink; deadlines were flaunted; Helpdesk
> calls took longer. For a million different reasons (excuses) neither I nor
> the organization found a way to deal with the people problems. We had built
> in an addiction to in-house expertise and when our own people went sour
> nobody, myself included, had the cojones to correct it.
>
> So we started to look at web apps. The economics were looking good. Buy
> more bandwidth, pay the monthly costs and get rid of at least 1 bad actor,
> maybe both!  I left their employment mostly for personal reasons, a death
> in the family. But even so, "mostly" is the key word.
>
> Six months later the organization has increased the bandwidth and
> (temporarily?) solved lots of WAN performance issues. The people problems
> and how to support the burden of M$ apps and their security issues remains
> unsolved. Status quo.
>
> In summary, I agree with all the technical reasons and security concerns
> expressed about web / cloud apps.  It was people-problems that blew down
> the house.
>
> Upon reflection, this calls for LO to build a community of support people
> that can support small to medium sized businesses and avoid the siren call
> of M$ style big money and big ego.  Good luck!  No, seriously, good luck to
> us all.
>
> --
> David S. Crampton
>
> On Wed, 14 Dec 2011 07:35:51 -0800, webmaster for Kracked Press
> Productions  wrote:
>
>  On 12/14/2011 10:18 AM, Caesar wrote:
>>
>>> On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press
>>> Productions  wrote Re Re:
>>> [libreoffice-users] Re: When will be a Web-Version of OOo/LO
>>> available?:
>>>
>>>  Personally, I do not like the idea of cloud based computing, for
 security reasons and ownership of files.  If the connection to the
 Internet is down on your end or theirs, you do not have access to your
 data.

>>> Excellent points.
>>>
>>> The whole 1980s migration from central computers w/dumb terminals to
>>> PCs was motivated in large part by the desire to spread the computing
>>> load and sever the "umbilical cord/chain" that central mainframe
>>> computers required.  In most rural areas of the U.S. today, dial-up
>>> modem is as good as it gets, and that won't facilitate the "cloud".
>>>
>>>  I was part of the movement.  I even saw PCs used as dumb terminals for
>> a time with software like "Kermit" being used since it had the ability to
>> upload/download the files to the central systems like we do with FTP
>> clients and the web.
>>
>> Yes, I know a lot of people who either can only get dial-up in their
>> areas, or cannot afford the price for broadband.  I am currently lucky to
>> have broadband, but with a fixed income, and the fees going up for
>> everything, I may not have it in the future.  Or, I may keep it and drop my
>> current digital phone system for some cheaper and less reliable one that is
>> based off my PC or my purchased network device that does Internet phone
>> calls.
>>
>> So, if you want to use cloud computing and file storage, you better
>> remain in the cities.  In the more rural areas where people like to live to
>> get away from the crowd, you are out of luck.
>>
>>
>>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to thi

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread David S. Crampton

I will speak up a little for the positive case for cloud-based computing  
and apps.  In the IT Manager position I recently left the motivator for  
looking at web apps was PEOPLE; specifically problems with our in-house  
people.


Making a long story short, I had built an entirely in-house M$ shop  
supported by people I hired plus occasional consulting especially for  
network / Cisco support.  We had about 12 servers, 160 desktops, a very  
elaborate WAN, M$ Suite plus an in-house M$ WSUS for their flood of  
updates.  The team was 3 people: myself, a sys admin and a desktop tech.


The workload was heavy and I relied on the motivation of the two hired  
staff to be learning M$ stuff toward becoming full M$ experts.  The  
overall economics of in-house machines and fully burdened in-house staff  
made sense for a while.


The people problems started as competition between my two staff people.  
Productivity and teamwork began to stink; deadlines were flaunted;  
Helpdesk calls took longer. For a million different reasons (excuses)  
neither I nor the organization found a way to deal with the people  
problems. We had built in an addiction to in-house expertise and when our  
own people went sour nobody, myself included, had the cojones to correct  
it.


So we started to look at web apps. The economics were looking good. Buy  
more bandwidth, pay the monthly costs and get rid of at least 1 bad actor,  
maybe both!  I left their employment mostly for personal reasons, a death  
in the family. But even so, "mostly" is the key word.


Six months later the organization has increased the bandwidth and  
(temporarily?) solved lots of WAN performance issues. The people problems  
and how to support the burden of M$ apps and their security issues remains  
unsolved. Status quo.


In summary, I agree with all the technical reasons and security concerns  
expressed about web / cloud apps.  It was people-problems that blew down  
the house.


Upon reflection, this calls for LO to build a community of support people  
that can support small to medium sized businesses and avoid the siren call  
of M$ style big money and big ego.  Good luck!  No, seriously, good luck  
to us all.


--
David S. Crampton

On Wed, 14 Dec 2011 07:35:51 -0800, webmaster for Kracked Press  
Productions  wrote:



On 12/14/2011 10:18 AM, Caesar wrote:

On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press
Productions  wrote Re Re:
[libreoffice-users] Re: When will be a Web-Version of OOo/LO
available?:


Personally, I do not like the idea of cloud based computing, for
security reasons and ownership of files.  If the connection to the
Internet is down on your end or theirs, you do not have access to your
data.

Excellent points.

The whole 1980s migration from central computers w/dumb terminals to
PCs was motivated in large part by the desire to spread the computing
load and sever the "umbilical cord/chain" that central mainframe
computers required.  In most rural areas of the U.S. today, dial-up
modem is as good as it gets, and that won't facilitate the "cloud".

I was part of the movement.  I even saw PCs used as dumb terminals for a  
time with software like "Kermit" being used since it had the ability to  
upload/download the files to the central systems like we do with FTP  
clients and the web.


Yes, I know a lot of people who either can only get dial-up in their  
areas, or cannot afford the price for broadband.  I am currently lucky  
to have broadband, but with a fixed income, and the fees going up for  
everything, I may not have it in the future.  Or, I may keep it and drop  
my current digital phone system for some cheaper and less reliable one  
that is based off my PC or my purchased network device that does  
Internet phone calls.


So, if you want to use cloud computing and file storage, you better  
remain in the cities.  In the more rural areas where people like to live  
to get away from the crowd, you are out of luck.





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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Caesar

On Wed, 14 Dec 2011 10:35:51 -0500, webmaster for Kracked Press
Productions  wrote Re Re:
[libreoffice-users] Re: When will be a Web-Version of OOo/LO
available?:

>I was part of the movement.  I even saw PCs used as dumb terminals for a 
>time with software like "Kermit" being used since it had the ability to 
>upload/download the files to the central systems like we do with FTP 
>clients and the web.

Yes indeed. I too ran from the tyrany of the mainframe as soon as I
was able.  I have no desire to ever go back to giving a central site
custody of anything of mine that is important.

And  I still have an old Kermit manual around here somewhere :-)

>So, if you want to use cloud computing and file storage, you better 
>remain in the cities.  In the more rural areas where people like to live 
>to get away from the crowd, you are out of luck.

Quite so.

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

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Alexander Thurgood

Le 14/12/11 13:20, Michael Bogaerts a écrit :

Hi Michael,


> Also; i thought that the tables were converted to ODF; but clearly
> they're not when i read your comments...
> 
> Is there a way to fully convert an MDB to ODF without keeping 'links'???
> because actually that's what i wanted to do in the first place...
> 
> If i need an older version to do that, no problem; i'll temporarily
> install OO.O or so in a VM and do it with that, so that in my production
> enviroment i'm permanently freed of this MS dictatorship...
> 

The GUI way :

1) open the ODB file that points to your MDB file in OOo/LO(in a version
that works of course)

2) Create a new blank ODB file with the database creation wizard. You do
not need to use the wizard to create any tables, just the container.

3) Open this second ODB file for editing, click on the Tables icon in
the main ODB window.

4) Now, select a table from your ODB/MDB file, and drag/drop it into the
empty table workspace of your new ODB file window. A migration wizard
should start that will help you with the data and structure migration of
your Access table to a table understood by the HSQLDB engine used in the
native ODB container.

5) Be sure to check that both structure and data types are what you want
before allowing the data to be imported. Also note that some Access data
types are not supported by the HSQLDB engine. These fields havin a data
type definition that is not recognised will have  as their data
type or UNKNOWN or UNIDENTIFIED (I'm speaking from memory here, so don't
quote me on this last bit). For those data types, you will have to find
an approximate equivalent that is supported by HSQLDB, if indeed such a
type exists (checking beforehand would be wise).

6) Repeat for each table that you want to convert/migrate.

7) Save your new ODB file before closing the main ODB container window,
in fact, save it regularly anyway, as the ODB container is not a model
of stability (unfortunately).


Hope that helps,

Alex




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

[libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Tom

Hi :)
+1
Afaik there are no plans to make LibO into Cloud based apps. Recently there
was an announcement that work was starting on making LibreOffice available
to directly install on certain mobile devices but it is expected to take
months or years to complete. So, it's likely we would have noticed
something about going to the Cloud.

One of our supporters is Google and they already have an office suite that
is entirely Cloud based and which likes to use the same file-formats as
LibreOffice. So, on a tablet (or whatever) you can edit a document using
Google-docs that was originally created in LibreOffice, NeoOffice, Symphony
or even OpenOffice. Or create in Google-docs and then edit with LibreOffice
or whatever. Each project attempts to get closer and closer to the agreed
ODF standards that they drew-up together. If you use the older ODF
standard then MS Office 2007 & 2010 can happily edit too.

There is a portable version available at
http://portableapps.com/apps/office/libreoffice_portable
and/or
http://www.libreoffice.org/download/portable/
but this is to install LibreOffice on a usb-stick / memory card or whatever
so that you can use LibreOffice on any Windows machine without having to
install LO to machines that may not be completely under your control.
Useful for workplaces, cyber-cafes, showing off to friends etc etc.

So, there is a LOT of flexibility about ODF documents even tho LibO itself
is not making itself subject to the whims of internet connection speeds and
download/upload limits.

Regards from
Tom :)

--
View this message in context:
http://nabble.documentfoundation.org/When-will-be-a-Web-Version-of-OOo-LO-available-tp3584737p3585787.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?


On 12/14/2011 10:18 AM, Caesar wrote:

On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press
Productions  wrote Re Re:
[libreoffice-users] Re: When will be a Web-Version of OOo/LO
available?:


Personally, I do not like the idea of cloud based computing, for
security reasons and ownership of files.  If the connection to the
Internet is down on your end or theirs, you do not have access to your
data.

Excellent points.

The whole 1980s migration from central computers w/dumb terminals to
PCs was motivated in large part by the desire to spread the computing
load and sever the "umbilical cord/chain" that central mainframe
computers required.  In most rural areas of the U.S. today, dial-up
modem is as good as it gets, and that won't facilitate the "cloud".

I was part of the movement.  I even saw PCs used as dumb terminals for a 
time with software like "Kermit" being used since it had the ability to 
upload/download the files to the central systems like we do with FTP 
clients and the web.


Yes, I know a lot of people who either can only get dial-up in their 
areas, or cannot afford the price for broadband.  I am currently lucky 
to have broadband, but with a fixed income, and the fees going up for 
everything, I may not have it in the future.  Or, I may keep it and drop 
my current digital phone system for some cheaper and less reliable one 
that is based off my PC or my purchased network device that does 
Internet phone calls.


So, if you want to use cloud computing and file storage, you better 
remain in the cities.  In the more rural areas where people like to live 
to get away from the crowd, you are out of luck.




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

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Michael Bogaerts


You are learning me here something ...

So odb files aren't real database files or what???


Met vriendelijke groeten,

Michael Bogaerts



De bij ons als "Mark Stanton" geidentificeerde tegenpartij wist exact op 
14/12/2011 14:44 uur het volgende uit de vingers te tokkelen:

It's hard to think of a situation that would truly benefit from the
data being in an odb.  Specific database engines manipulate their own
data much better than... Almost anything.

You can do by extracting the data from your current database and
putting it into HSQL.  I believe Base does actually store that data
in the .odb file.

Mark Stanton
One small step for mankind...






__
Alle inkomende en uitgaande mail van mail.bogy.be wordt gescand op
spyware, spam enzomeer. Indien u toch problemen via deze mailserver zou
ondervinden, stuur dan de originele mail door naar i...@bogy.be

All incoming and outgoing mail from mail.bogy.be is scanned against 
spyware, spam, etc. If you would have any inconvenience from our 
services then do not hesitate to send the original mail to 
i...@bogy.be 


Serverconfig: A64 3700+, 1.5GB Ram, +1 TB HD, WXP Pro, Mercury/32.

De inhoud van deze mail is enkel bestemd voor de ontvanger; indien u 
deze mail verkeerdelijk hebt ontvangen, gelieve de verzender hiervan 
op de hoogte te brengen en de inhoud niet verder te verspreiden. 

The contents of this mail is solely intended for the individual whom it 
is addressed. If you received this mail in error, then please inform the 
sender and do not spread the contents of this mail any further.

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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Caesar

On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press
Productions  wrote Re Re:
[libreoffice-users] Re: When will be a Web-Version of OOo/LO
available?:

>Personally, I do not like the idea of cloud based computing, for 
>security reasons and ownership of files.  If the connection to the 
>Internet is down on your end or theirs, you do not have access to your 
>data.

Excellent points.  

The whole 1980s migration from central computers w/dumb terminals to
PCs was motivated in large part by the desire to spread the computing
load and sever the "umbilical cord/chain" that central mainframe
computers required.  In most rural areas of the U.S. today, dial-up
modem is as good as it gets, and that won't facilitate the "cloud".

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

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread webmaster for Kracked Press Productions



The question about a "cloud" version of LO or OOo was the thread.
As for LO having one, well there is a lot of server side work and 
expense to produce a "cloud based" application.


As for how soon will there be a cloud app that is not so limiting, it is 
all in the economics of server side computing, which cloud-based apps 
mostly are.  It is expensive to have a set of servers and bandwidth to 
host a package that does the computing for you, instead of your system 
doing its own work.  These servers are usually owned by large companies 
that have the ability to either charge a "cloud" fee or have other 
income sources to cover the huge costs.  How many servers would be 
needed to do the computing power for 1,000 people using a package like 
LibreOffice?  How many would it be for 100,000?  Who pays for these 
servers and all the electricity?  Google Docs has a mega-company like 
Google to pay for the servers needed to do the online "cloud" computing 
needed to serve all its users. Small companies, or not-for-profit ones 
would never be able to afford to do the same thing.


As for some large company taking LO and making it a cloud app, they are 
free to do the work to do so.  The key is how much need is there and how 
are they going to get their money back?  MSO is now going cloud-based, 
but they have the money to do the work to make it work that way.


Personally, I do not like the idea of cloud based computing, for 
security reasons and ownership of files.  If the connection to the 
Internet is down on your end or theirs, you do not have access to your 
data.


To be honest, I do not see a lot of people needing to use cloud-based 
computing, except for the Tablet market.  I do not know about you, but I 
would not want to do much typing and such on one of those small things, 
so the need for a large package like LO accessible to a tablet via the 
"cloud" is not something that is high priority to many.  Since you do 
most business/personal work via a laptop or desktop, and not a tablet, 
you would use the cloud for files, not computing.  The does have an 
office package, but limited due to resources.  The cloud computing 
version of an office package would be just as limited and slower that 
the one on a desktop/laptop system until the market will bare the 
expense of the resources for the server power.  I think you would pay a 
lot of money every month to have a non-limited office suite based in the 
"cloud", or have a company like Google foot the bill.



On 12/14/2011 04:33 AM, Alex Thurgood wrote:

Le 14/12/2011 08:37, Michelle Konzack a écrit :

Hi Michelle,







I have found an old announcement that OOo will be available  as  Web-App
and I like to know, whether it exist already and where  the  mailinglist
is.

Note:  It seems the OOo guys will shutdown the OOo site and mailinglists



I can't answer your question directly, but as far as OOo mailing lists 
are concerned, they are not all being shut down, some of them have 
actually been migrated to the Apache infrastructure. You should look 
up the OOo project under Incubation on the Apache project page if you 
want to subscribe to mailing lists there.



Alex





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

Re: [libreoffice-users] Finding Dictionaries

2011-12-14 Thread webmaster for Kracked Press Productions



What he was looking for was an Australian dictionary that included the 
thesaurus, and such.


That dictionary is not currently on the LO Extension Center.

The key for why most of the dictionaries on the LibreOffice-NA.US site 
dictionary page[s] are not on the Extension Center list, is simple.  The 
Extension Center requires the author of the dictionary to apply to the 
list for their dictionary to be part of it. On the LibreOffice-NA.US 
[North American Community DVD project] dictionary page[s] ALL of the 
known dictionaries were placed on that list.  The dictionaries were 
found on many sources, or upgraded from their creators.  The issue of 
the Extension Center is the simple fact that it looks like many of the 
dictionary authors are either unknown or unreachable.  They have set up 
their inclusion process for legal reasons or some other reason that will 
indicate to the admin of the "Center" that the extension file author is 
stating that this file is free to use and distribute.


As for the different DVD projects, vs. the official LO centers for 
extension and templates; well we all have our own ways of doing things.  
Each project is geared to the needs of the author and its community.  
LO's Extension Center gives much more than a list of file that are 
available for download.  The LibreOffice-NA.US site "online version" of 
their DVD wanted a simpler web-based system where you could browse the 
files via the HTML pages or [with the DVD media] browse the DVD itself 
with a file manager.


I have asked the TDF/LO people to look into how they can add the 
dictionaries if the creators are no longer supporting their work AND/or 
are unreachable.  I created American[en_US], British[en_GB], and 
Canadian[en_CA] English dictionaries to fit a niche where there was a 
need for on that had Thesaurus, Hyphenation, plus a Spell Checking word 
list of a large size [up to 638K+ words].  Others have created their own 
dictionaries to fit their local niche.  I support anyone's efforts to 
create a dictionary for their language needs.  It would be great to have 
more of them.


The LibreOffice North American Community DVD project's 3.4.4 online 
version of the DVD is at the following URL.  The link that was listed in 
the original posting was for the 3.3.4 installs, instead of the 3.4.x 
line of installs.  I keep the 3.4.x version up-to-date first.

http://libreoffice-na.us/English-3.4-installs/index.html

The 3.6 Gig .iso file for that DVD is at the following link.
http://download.documentfoundation.org/libreoffice/box/3.4.4/libo3.4.4-NA-DVD-WLM-Dec-3-2011.iso

On 12/14/2011 04:58 AM, Tom Davies wrote:

Hi :)
+1
It would be great if the website list knew and recognised the various Dvd projects.  The dictionaries you found are also on the Extensions site so i would be good to have something pointing to there too i guess. 


Nicely found!  It's not easy to find this sort of thing at the moment!
Congrats and regards from
Tom :)

--- On Tue, 13/12/11, Colin Curtain  wrote:

From: Colin Curtain
Subject: [libreoffice-users] Finding Dictionaries
To: users@global.libreoffice.org
Date: Tuesday, 13 December, 2011, 22:43

Using LibreOffice on Ubuntu.
I tried to install an Australian Dictionary as no spellcheck or thesaurus
was available.
The LibreOffice instructions for 'Install the required dictionaries',
Chapter 2 Setting up writer directs the user to get more dictionaries online
at this webaddress:
http://extensions.libreoffice.org/extension-center?getCategories=Dictionary
http://extensions.libreoffice.org/extension-center?getCategories=Dictionary

I could not find the dictionaries I needed here, but after some more
searching found them here:
http://libreoffice-na.us/English/dictionary.html
http://libreoffice-na.us/English/dictionary.html

It would be great if the 'get dictionaries online' site could include all of
these other dictionaries as well.





--
View this message in context: 
http://nabble.documentfoundation.org/Finding-Dictionaries-tp3583895p3583895.html
Sent from the Users mailing list archive at Nabble.com.




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

re: [libreoffice-users] Syntax Question

2011-12-14 Thread Gérard FARGEOT

Hi,

> Message du 14/12/11 14:29
> De : "Ian "Witty" Whitfield" 
> A : users@global.libreoffice.org
> Copie à : 
> Objet : [libreoffice-users] Syntax Question
> 
> Hi All
> 
> Can someone help me with some syntax please??
> 
> I have a two-sheet Calc Spreadsheet. All my data lives on the first 
> sheet called "Data" and my Analysis Reports are on Sheet Two.
> 
> I have the same values in any given Column in my Data Sheet, (ie all my 
> Totals are in Column D), and - as per my last posting here - I can now 
> ID which Row I need to use each month.
> 
> So on my Analysis Sheet I want to fetch all the needed data but it must 
> be dynamic.
> 
> If my Column Identifier is at Data.H5 and my Row Identifier is at 
> Data.M9 I can place the cell reference on my Second Sheet with
> '=Data. H5&((M9)' [Lets say I put this into Cell M10]
> 
> I have tried - '=INDIRECT(Data.M10)' and 'INDIRECT(Data.&(M10))' and 
> '=INDIRECT(Data.+(M10)) etc etc but nothing works. Can anyone give me 
> the correct syntax for this please? It seems as soon as I cross sheets 
> the syntax changes because a straight typed-in '=Data.M10' works fine!!
> 
> What I need is - '=THE VALUE IN CELL(Data.H5)&(Data.M9).
> 
> Thanks a lot. (I'm using LO 3.4)
> 
> Ian Whitfield.
> 

=INDIRECT("Data."&Data.H5&Data.M9)
with Letters column identifier in Data.H5 and number row identifier in Data.M9

If column identifier is a number, you can use INDIRECT & ADDRESS
=INDIRECT(ADDRESS(Data.M9;Data.H5;4;;"Data"))

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

Re: [libreoffice-users] Re: Base can't open databases

Hi :)
Ouch sorry for double-posting and nothing hugely useful in either.  

Base is better when the back-end is separate from the front-end.  Base is a 
great front-end.  There are a lot of choices for back-ends and i have no idea 
which is best for a simple small database.  SqlLite, HSql(db?) or something?  

A new guide to Base is being written but it's slow going.  The 1st chapter is 
available at
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
There is a tutorial just under it on that page.  

Base can use an embedded back-end just like Access does but it's not as good 
that way apparently.  I think the back-end is basically the table and perhaps 
the relationships between tables but i'm not completely clear yet.  I think the 
front-end is the gui, queries, forms, reports and all that.  Somehow i doubt 
it's quite that straight-forwards!  

Getting forms and reports from Access to Base is not easy.  I think you 
basically have to re-write them.  I'm guessing/hoping that Queries can possibly 
be exported as Sql statements and then imported and tweaked.  Access doesn't 
follow Sql standards in it's implementation so it might be easier to just 
re-create them too.  

I have been wondering about trying to access works simple but messy database 
through Base and just set-up queries and stuff that are less problematic so 
that we all write to the same data-source.  I have a feeling that it might be 
easier to move the data to a new back-end and then get Access to read that 
rather than to use it's embedded back-end.  

So, this thread has been interesting and good to see.  
Regards from
Tom :)


--- On Wed, 14/12/11, Michael Bogaerts  wrote:
From: Michael Bogaerts 
Subject: Re: [libreoffice-users] Re: Base can't open databases
To: users@global.libreoffice.org
Date: Wednesday, 14 December, 2011, 12:20

Hey Alex,

Thanks for the info..
But since i'm using CALC in a production environment i don't want to go 
'trying' with beta releases ...
I could though use a VM and see if it works there ...

Also; i thought that the tables were converted to ODF; but clearly they're not 
when i read your comments...

Is there a way to fully convert an MDB to ODF without keeping 'links'???
because actually that's what i wanted to do in the first place...

If i need an older version to do that, no problem; i'll temporarily install 
OO.O or so in a VM and do it with that, so that in my production environment 
i'm permanently freed of this MS dictatorship...

Thanks again for all your good help!

Met vriendelijke groeten,

Michael Bogaerts



De bij ons als "Alex Thurgood" geidentificeerde tegenpartij wist exact op 
14/12/2011 10:39 uur het volgende uit de vingers te tokkelen:
> Le 14/12/2011 09:31, Michael Bogaerts a écrit :
> 
> Hi Michael,
> 
> 
>>        with LibOffice.I removed OO.O first and then I installed LibOffice 
>>3.4.4 (the
>>        latest release).Since that day i can't open my database files 
>>anymore; i can't
>>        read the original MDB files, nor can i open my odf files... well,
>>        i can open the odf files, but as soon as i open a table i get an
>>        errormessage. (it's dutch though, so i'll translate it for you
> 
> MDB file access, in fact the ADO, Access2003, Access2007, accdb file access 
> was all broken in the 3.4.x versions up to and including 3.4.4.
> 
> Several fixes were entered into the master code branch for the upcoming 3.5 
> release, which appear to have solved this problem (still not perfect, but at 
> least it now works - well in the tests I managed to do anyway). You may want 
> to test with a beta release of 3.5 to see if you work with those files again.
> 
> I don't know whether the fixes are going to be integrated into a 3.4.5 
> version.
> 
> Alex

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

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Mark Stanton

It's hard to think of a situation that would truly benefit from the 
data being in an odb.  Specific database engines manipulate their own 
data much better than... Almost anything.

You can do by extracting the data from your current database and 
putting it into HSQL.  I believe Base does actually store that data 
in the .odb file.

Mark Stanton
One small step for mankind...



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

Re: [libreoffice-users] Re: Base can't open databases

Hi :)
You can have a machine with more than 1 version of LibreOffice but it's not 
trivial to set-up.  This guide can help.  
http://wiki.documentfoundation.org/Installing_in_parallel
The main advantage is that when you feel like upgrading you can test the new 
one before committing to it and rolling it out.  It saves setting up a VM as 
they are never quite the same as "running on bare metal".
Regards from
Tom :)

--- On Wed, 14/12/11, Michael Bogaerts  wrote:

From: Michael Bogaerts 
Subject: Re: [libreoffice-users] Re: Base can't open databases
To: users@global.libreoffice.org
Date: Wednesday, 14 December, 2011, 12:20

Hey Alex,

Thanks for the info..
But since i'm using CALC in a production enviroment i don't want to go 'trying' 
with beta releases ...
I could though use a VM and see if it works there ...

Also; i thought that the tables were converted to ODF; but clearly they're not 
when i read your comments...

Is there a way to fully convert an MDB to ODF without keeping 'links'???
because actually that's what i wanted to do in the first place...

If i need an older version to do that, no problem; i'll temporarily install 
OO.O or so in a VM and do it with that, so that in my production enviroment i'm 
permanently freed of this MS dictatorship...

Thanks again for all your good help!

Met vriendelijke groeten,

Michael Bogaerts

De bij ons als "Alex Thurgood" geidentificeerde tegenpartij wist exact op 
14/12/2011 10:39 uur het volgende uit de vingers te tokkelen:
> Le 14/12/2011 09:31, Michael Bogaerts a écrit :
> 
> Hi Michael,
> 
> 
>>        with LibOffice.I removed OO.O first and then I installed LibOffice 
>>3.4.4 (the
>>        latest release).Since that day i can't open my database files 
>>anymore; i can't
>>        read the original MDB files, nor can i open my odf files... well,
>>        i can open the odf files, but as soon as i open a table i get an
>>        errormessage. (it's dutch though, so i'll translate it for you
> 
> MDB file access, in fact the ADO, Access2003, Access2007, accdb file access 
> was all broken in the 3.4.x versions up to and including 3.4.4.
> 
> Several fixes were entered into the master code branch for the upcoming 3.5 
> release, which appear to have solved this problem (still not perfect, but at 
> least it now works - well in the tests I managed to do anyway). You may want 
> to test with a beta release of 3.5 to see if you work with those files again.
> 
> I don't know whether the fixes are going to be integrated into a 3.4.5 
> version.
> 
> Alex
> 
> 

__
Alle inkomende en uitgaande mail van mail.bogy.be wordt gescand op
spyware, spam enzomeer. Indien u toch problemen via deze mailserver zou
ondervinden, stuur dan de originele mail door naar i...@bogy.be

All incoming and outgoing mail from mail.bogy.be is scanned against spyware, 
spam, etc. If you would have any inconvenience from our services then do not 
hesitate to send the original mail to i...@bogy.be 
Serverconfig: A64 3700+, 1.5GB Ram, +1 TB HD, WXP Pro, Mercury/32.

De inhoud van deze mail is enkel bestemd voor de ontvanger; indien u deze mail 
verkeerdelijk hebt ontvangen, gelieve de verzender hiervan op de hoogte te 
brengen en de inhoud niet verder te verspreiden. 
The contents of this mail is solely intended for the individual whom it is 
addressed. If you received this mail in error, then please inform the sender 
and do not spread the contents of this mail any further.
__
-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[libreoffice-users] Syntax Question

2011-12-14 Thread Ian "Witty" Whitfield


Hi All

Can someone help me with some syntax please??

I have a two-sheet Calc Spreadsheet. All my data lives on the first 
sheet called "Data" and my Analysis Reports are on Sheet Two.


I have the same values in any given Column in my Data Sheet, (ie all my 
Totals are in Column D), and - as per my last posting here - I can now 
ID which Row I need to use each month.


So on my Analysis Sheet I want to fetch all the needed data but it must 
be dynamic.


If my Column Identifier is at Data.H5 and my Row Identifier is at 
Data.M9 I can place the cell reference on my Second Sheet with

'=Data. H5&((M9)' [Lets say I put this into Cell M10]

I have tried - '=INDIRECT(Data.M10)' and 'INDIRECT(Data.&(M10))' and 
'=INDIRECT(Data.+(M10)) etc etc but nothing works. Can anyone give me 
the correct syntax for this please? It seems as soon as I cross sheets 
the syntax changes because a straight typed-in '=Data.M10' works fine!!


What I need is - '=THE VALUE IN CELL(Data.H5)&(Data.M9).

Thanks a lot. (I'm using LO 3.4)

Ian Whitfield.

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

Re: [libreoffice-users] Change cell border sizes- quickly?

2011-12-14 Thread Cor Nouws


Hi Alexander,

. wrote (14-12-11 13:26)

With F11, select Default format, and change there the border.
If there is another style non vinculated with default, change it also.


Miguel, I tried it with one of the sheets but it had no effect.  I tried
it with a new sheet but no effect either.


That will be because there is direct formatting on the cells.
Try selecting one/few, and choose Format > Default Formatting.That of 
course will also change formatting of numbers etc. so doing that for the 
whole sheet will be impossible, I expect.




At that point in the process the there's a lot of activity (so to speak)
[...]


Recalculating lines probably..

Regards,

--
 - Cor
 - http://nl.libreoffice.org


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

Re: [libreoffice-users] Change cell border sizes- quickly?

2011-12-14 Thread .



On 12/14/2011 05:45 AM, MiguelAngel wrote:
> El 14/12/11 5:18, Dave Barton escribió:
>>  Original Message  
>> From: .
>> To: users@global.libreoffice.org
>> Date: Tue, 13 Dec 2011 22:26:01 -0500
>>
>>>
>>> I upgraded from Oo 3.2 (I think that was the version) to the following
>>> version of LibreOffice;
>>>
>>> LibreOffice 3.4.3
>>> OOO340m1 (Build:302)
>>>
>>> A spreadsheet I work on had the cell borders set at 1 pt. in Oo. Now
>>> with LibreOffice all of the cell borders on the sheet are .25 pt.  A
>>> change was made to the cell border sizes and I didn't do it.
>>>
>>> How do I quickly change ALL of the cell borders in the many sheets I'm
>>> working on?  I have literally 1,000's of cells to fix IF I have to
>>> change each cell one at a time.
>>>
>>> Man, do I need some help!
>>>
>>> Thanks.
>>
>> I don't know if it's possible to fix multiple sheets at one time, but
>> for individual sheets follow this procedure:
>>
>> o Keyboard Ctrl + A to select/highlight all cells on the sheet.
>> o Right click anywhere in the highlighted area and select "Format Cells"
>> o In the dialog select the "Borders" tab and make the adjustment.
>>
>> Recommend you check out the Calc User Guide:
>> http://www.libreoffice.org/get-help/documentation/
>>
>> Dave
>>
>
> With F11, select Default format, and change there the border.
> If there is another style non vinculated with default, change it also.
>
> Miguel Ángel

Miguel, I tried it with one of the sheets but it had no effect.  I tried
it with a new sheet but no effect either.

Here's what I did;

- opened the ods file I want to work on which has about 90 sheets within it.
- hit F11
- right clicked on Default in Styles and Formatting
- change the Cell Borders to 1 pt. and selected Default under Line
Arrangement

At that point in the process the there's a lot of activity (so to speak)
in the bottom of the Calc window...some progress bar flashing (so
whatever it's called)  giving the impression that what I wanted to
change is occurring.  However, a check of the cell formatting indicates
that the cell border size wasn't changed.

Any other ideas?










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

Re: [libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Michael Bogaerts


Hey Alex,

Thanks for the info..
But since i'm using CALC in a production enviroment i don't want to go 
'trying' with beta releases ...

I could though use a VM and see if it works there ...

Also; i thought that the tables were converted to ODF; but clearly 
they're not when i read your comments...


Is there a way to fully convert an MDB to ODF without keeping 'links'???
because actually that's what i wanted to do in the first place...

If i need an older version to do that, no problem; i'll temporarily 
install OO.O or so in a VM and do it with that, so that in my production 
enviroment i'm permanently freed of this MS dictatorship...


Thanks again for all your good help!




Met vriendelijke groeten,

Michael Bogaerts



De bij ons als "Alex Thurgood" geidentificeerde tegenpartij wist exact 
op 14/12/2011 10:39 uur het volgende uit de vingers te tokkelen:

Le 14/12/2011 09:31, Michael Bogaerts a écrit :

Hi Michael,


   with LibOffice.I removed OO.O first and then I installed 
LibOffice 3.4.4 (the
   latest release).Since that day i can't open my database files 
anymore; i can't

   read the original MDB files, nor can i open my odf files... well,
   i can open the odf files, but as soon as i open a table i get an
   errormessage. (it's dutch though, so i'll translate it for you


MDB file access, in fact the ADO, Access2003, Access2007, accdb file 
access was all broken in the 3.4.x versions up to and including 3.4.4.


Several fixes were entered into the master code branch for the 
upcoming 3.5 release, which appear to have solved this problem (still 
not perfect, but at least it now works - well in the tests I managed 
to do anyway). You may want to test with a beta release of 3.5 to see 
if you work with those files again.


I don't know whether the fixes are going to be integrated into a 3.4.5 
version.


Alex





__
Alle inkomende en uitgaande mail van mail.bogy.be wordt gescand op
spyware, spam enzomeer. Indien u toch problemen via deze mailserver zou
ondervinden, stuur dan de originele mail door naar i...@bogy.be

All incoming and outgoing mail from mail.bogy.be is scanned against 
spyware, spam, etc. If you would have any inconvenience from our 
services then do not hesitate to send the original mail to 
i...@bogy.be 


Serverconfig: A64 3700+, 1.5GB Ram, +1 TB HD, WXP Pro, Mercury/32.

De inhoud van deze mail is enkel bestemd voor de ontvanger; indien u 
deze mail verkeerdelijk hebt ontvangen, gelieve de verzender hiervan 
op de hoogte te brengen en de inhoud niet verder te verspreiden. 

The contents of this mail is solely intended for the individual whom it 
is addressed. If you received this mail in error, then please inform the 
sender and do not spread the contents of this mail any further.

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

Re: [libreoffice-users] Change cell border sizes- quickly?

2011-12-14 Thread MiguelAngel

El 14/12/11 5:18, Dave Barton escribió:

 Original Message  
From: .
To: users@global.libreoffice.org
Date: Tue, 13 Dec 2011 22:26:01 -0500

I upgraded from Oo 3.2 (I think that was the version) to the following
version of LibreOffice;

LibreOffice 3.4.3
OOO340m1 (Build:302)

A spreadsheet I work on had the cell borders set at 1 pt. in Oo. Now
with LibreOffice all of the cell borders on the sheet are .25 pt.  A
change was made to the cell border sizes and I didn't do it.

How do I quickly change ALL of the cell borders in the many sheets I'm
working on?  I have literally 1,000's of cells to fix IF I have to
change each cell one at a time.

Man, do I need some help!

Thanks.

I don't know if it's possible to fix multiple sheets at one time, but
for individual sheets follow this procedure:

o Keyboard Ctrl + A to select/highlight all cells on the sheet.
o Right click anywhere in the highlighted area and select "Format Cells"
o In the dialog select the "Borders" tab and make the adjustment.

Recommend you check out the Calc User Guide:
http://www.libreoffice.org/get-help/documentation/

Dave

With F11, select Default format, and change there the border.
If there is another style non vinculated with default, change it also.

Miguel Ángel

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

Re: [libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-14 Thread Stephan Zietsman

Ian Whitfield wrote:
> 1) How do I work out what ROW NUMBER a given unique value is on?
> 2) How do I use this ROW NUMBER to make-up a valid CELL ADDRESS?
> 3) How do I get the VALUE in that CELL ADDRESS?
> [...]
> 2) For the CELL ADDRESS I have a cell that identifies each COLUMN that these
> values resides in (ie all my TOTALS are in COLUMN H), and I now have the ROW
> COUNT of the data I'm looking for. So I can use
>
> "=COLUMN ID & fixed ROW NUMBER"
>
> 3) The last step is to get the VALUE that is in the Cell at that location.
> For this I used
>
> "=INDIRECT (CELL ADDRESS)"

I prefer using OFFSET(), rather than INDIRECT().  Here's an example:

Column A contains the name of fruits, column B contains the quantity.
Let's say A2 contains "Apples", B2 contains "12", A3 contains "Pears"
and B3 contains "7".  If I want to know how many "Pears" I have, I
would use something like this:
= OFFSET(A2, MATCH("Pears", A2:A3, 0) - 1, 1)

The result would be "7" (the value in the second column).

Obviously, you can replace "Pears" with "Apples" or a cell reference.

> Perfect - PROBLEM SOLVED!!

Ok then.  Just thought I'd give you another suggestion.

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

Re: [libreoffice-users] Finding Dictionaries

Hi :)
+1
It would be great if the website list knew and recognised the various Dvd 
projects.  The dictionaries you found are also on the Extensions site so i 
would be good to have something pointing to there too i guess.  

Nicely found!  It's not easy to find this sort of thing at the moment!
Congrats and regards from
Tom :)

--- On Tue, 13/12/11, Colin Curtain  wrote:

From: Colin Curtain 
Subject: [libreoffice-users] Finding Dictionaries
To: users@global.libreoffice.org
Date: Tuesday, 13 December, 2011, 22:43

Using LibreOffice on Ubuntu.
I tried to install an Australian Dictionary as no spellcheck or thesaurus
was available.
The LibreOffice instructions for 'Install the required dictionaries',
Chapter 2 Setting up writer directs the user to get more dictionaries online
at this webaddress: 
http://extensions.libreoffice.org/extension-center?getCategories=Dictionary
http://extensions.libreoffice.org/extension-center?getCategories=Dictionary 

I could not find the dictionaries I needed here, but after some more
searching found them here:
http://libreoffice-na.us/English/dictionary.html
http://libreoffice-na.us/English/dictionary.html 

It would be great if the 'get dictionaries online' site could include all of
these other dictionaries as well.





--
View this message in context: 
http://nabble.documentfoundation.org/Finding-Dictionaries-tp3583895p3583895.html
Sent from the Users mailing list archive at Nabble.com.

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


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

[libreoffice-users] Re: new user

2011-12-14 Thread Tom

Hi :)
There is also the Nabble interface.  

Generally it seems best to join a list and then set your preferences to
"nomail" and then perhaps subscribe to individual threads but i'm still not
sure ow best to handle high-traffic lists such as this one.
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/new-user-tp3584232p3584996.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Base Crashes when making listbox droppable

2011-12-14 Thread Alex Thurgood


Le 13/12/2011 18:46, dakiriki a écrit :

Hi,



Is this abug?
It makes Base totaly unusable to me.
Thanks in advance


Yes, sounds like it, but I think I saw something on bugzilla about this 
already. You should check with bugzilla to see if it hasn't already been 
registered, and if not open a new bug report, or else add your  own 
findings to the existing report.



Alex


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

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Alex Thurgood


Le 14/12/2011 09:31, Michael Bogaerts a écrit :

Hi Michael,



   with LibOffice.I removed OO.O first and then I installed LibOffice 3.4.4 
(the
   latest release).Since that day i can't open my database files anymore; i 
can't
   read the original MDB files, nor can i open my odf files... well,
   i can open the odf files, but as soon as i open a table i get an
   errormessage. (it's dutch though, so i'll translate it for you


MDB file access, in fact the ADO, Access2003, Access2007, accdb file 
access was all broken in the 3.4.x versions up to and including 3.4.4.


Several fixes were entered into the master code branch for the upcoming 
3.5 release, which appear to have solved this problem (still not 
perfect, but at least it now works - well in the tests I managed to do 
anyway). You may want to test with a beta release of 3.5 to see if you 
work with those files again.


I don't know whether the fixes are going to be integrated into a 3.4.5 
version.


Alex


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

[libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Alex Thurgood


Le 14/12/2011 08:37, Michelle Konzack a écrit :

Hi Michelle,







I have found an old announcement that OOo will be available  as  Web-App
and I like to know, whether it exist already and where  the  mailinglist
is.

Note:  It seems the OOo guys will shutdown the OOo site and mailinglists



I can't answer your question directly, but as far as OOo mailing lists 
are concerned, they are not all being shut down, some of them have 
actually been migrated to the Apache infrastructure. You should look up 
the OOo project under Incubation on the Apache project page if you want 
to subscribe to mailing lists there.



Alex


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

Re: [libreoffice-users] When will be a Web-Version of OOo/LO available?