[libreoffice-users] Re: Problems with "Merge" in Draw

[Kai]

Hi Tom

thanks for the hint :)

Here you will find the attachments:
map_1.png   
map_2.png   

map_1 shows the map before merging,
map_2 shows the map after trying to merge the first couple of shapes.

I did use the context menu. I did use "primitive" shapes with regular
fillings.

Here is the file to the problem:

roads.odp   

I've been able to reproduce the issue:

Create a circle with a diameter of X (let's say 1cm).
Create a rectangle with a width of 1cm and any height.
Align the bottom centre of the rectangle to the centre of the circle.

Now rotate the rectangle by 60 degrees (120 or 240 work as well) with the
rotation axis being the centre of the circle.
Contextmenu - shape - merge; The result is anything but a proper merge.

Any creative ideas?


Thanks and kind regards,
Kai



--
View this message in context: 
http://nabble.documentfoundation.org/Problems-with-Merge-in-Draw-tp4030803p4030970.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: Where are the nightly builds for Linux?

[NoOp]

On 01/21/2013 05:26 PM, Steven P. Ulrick wrote:
> Hello, Everyone
> I hope that this is not too off topic, but I was wondering...  Where are the 
> nightly builds for Linux?  
> 
> The following three directories are now empty:
>  dbgutil/>
>  Configuration/>
>  Configuration/>
> 
> This is the last nightly build that I have been able to install:
> 
> Version 4.1.0.0.alpha0+ (Build ID: 4a507f732d82c188ad81b022cbe3037951e58ac)
> TinderBox: Linux-Fedora17-x86_64@4-gcc-4.7-dbgutil, Branch:master, Time: 
> 2012-12-24_14:04:36
> 
> The directory that I downloaded it from is now empty:
>  dbgutil/>
> 
> Any help you can give me in solving this mystery is greatly appreciated.
> 
> Steven P. Ulrick
> 

/master seems to only contain Windows files every time that I've looked.

You can backup one directory
 http://dev-builds.libreoffice.org/daily/
and then go to LO 4
http://dev-builds.libreoffice.org/daily/libreoffice-4-0/
There you find the most recent deb & rpms:


etc.

Other than that, I'd suggest asking on the dev list.



-- 
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] is MSFT running scared ...

[Tom Davies]

Hi :)
Yes, installing a new Windows alongside an existing one still does over-write 
the Mbr and hides all previous versions of Windows as well as any other OSes 
you have.  It doesn't matter if the newer version is on a different physical 
drive or on an external drive or anything else.  

One trick is to physically unplug the drive with the Mbr you want to save and 
then install the newer Windows on it's own drive.  it will overwrite the Mbr on 
it's drive but will leave the unplugged drive's Mbr alone.  Then when you plug 
in the old drive then hopefully you can set the bios to boot the old drive 
first.  Of course this means the old drive is unaware of the new install so 
you'll need to run something like 
sudo update-grub
from you old Gnu&Linux distro.

Regards form
Tom :)  





>
> From: webmaster-Kracked_P_P 
>To: LibreO - Users Global  
>Sent: Tuesday, 22 January 2013, 0:39
>Subject: Re: [libreoffice-users] is MSFT running scared ...
> 
>
>Maybe you should give the URL for the Linux-based boot repair disk [.iso file 
>download].  I do not remember it it.
>
>I have two different disk type/names.
>
>"boot-repair-disk.iso" - 355 MB
>
>"ubuntu-secure-remix-12.10-32-bit.iso" - 787 MB
>"ubuntu-secure-remix-12.10-64-bit.iso" - 797.1 MB
>
>I think I used the "boot-repair-disk" version since all you had to do was 
>choose your OS version/type you are using.  I think I remember correctly that 
>there was only 4 buttons to choose from once the disk/OS booted up.
>
>My Dell laptop had 32-bit Vista even though 64-bit Vista was out and working.  
>Too cheap maybe to include it, since it cost us more for the 64-bit version 
>back then.  I just upgraded that dual boot laptop 64-bit Win7 professional 
>from 32-bit Vista and 64-bit Ubuntu 12.10 from 12.04 version.  Win7/pro killed 
>the dual booting till I ran the "repair disk".  I tend to use the Ubuntu boot 
>for the testing of the newest version of Ubuntu [10.04 to 10.10 to 11.04 to 
>11.10 to 12.04 to 12.10] before I upgrade it on my "production desktop".  I 
>upgraded the Vista to Win7/pro [64-bit] so I can have a working 64-bit Windows 
>OS on one of my systems without going to Win8, since I do not have any touch 
>screens except on my Android 4.0 tablet.
>
>Actually, I wonder if Win7 or Win8 would break the dual [or triple] booting a 
>laptop if both boot partitions were running a Windows OS before one was 
>upgraded from XP or Vista to Win7 or Win8?  Would Windows break the multi-boot 
>if there would be two+ Windows OSs on the same system but in different boot 
>partitions?
>
>Windows 2000 was for business based on Win NT, while Win Millennium was for 
>the home user based on Win98.  Millennium was worse than Vista ever was and 
>most users I dealt with switched to Win 2000 till XP [home or professional]  
>came out.
>
>Win8 look and feel is a reworking of their failed smart phone OS. They decided 
>that they still liked it and moved it to the Win8 tablet OS.  BUT, someone had 
>the bad idea of wanting all of "your" Windows based systems to look and "feel" 
>the same.  I do not want my "production desktop" to have the "look and feel" 
>of my tablet. I hated Unity's look and feel when it came out in the Spring of 
>2011.  Win8 seemed to look and feel the same.  I read that a large number of 
>Ubuntu user switched to Mint Linux because of Unity.  If MS would have looked 
>at the "fallout" when Ubuntu went to Unity, maybe they would have thought 
>twice about using a tablet looking OS desktop display for their desktop/laptop 
>OSs.  I kept Ubuntu, but switched to MATE for the desktop environment.
>
>For my opinion what business users in my area will do with new Win8 systems; 
>not buy them if they can get new Win7 systems or downgrade the new Win8 
>systems to Win7.  Every business user I have talked to locally hates the look 
>of Win8 and do not want to have to pay for the training to get their users to 
>be able to use it.  XP/Vista to Win7 was a little change, but XP/Vista/Win7 to 
>Win8 was a real big change that needs a lot of training.  TV ads for retail 
>computer stores use to offer free Win8 training so people could learn how to 
>deal with the big changes.  Well, those TV ads are all gone, along with most 
>of the Win8 ads [number of ads per day/week] are gone now.  Almost all of the 
>MS's tablet are gone now, but there are some major computer companies [like 
>HP] ads about tablet to laptop convertibles though replacing MS's "tablet with 
>a keyboard" ads..
>
>
>
>
>On 01/21/2013 04:55 PM, Tom Davies wrote:
>> Hi :)
>> There is always 'unexpectedly low' take-up of Windows newest OS when it 
>> first gets released.  Historically corporate users have learned to leave it 
>> until after at least the first Service Pack gets released.  One time MS 
>> tried to boost sales by claiming that Service Pack 1 was included in the 
>> initial release.
>> 
>> Usually there is a requirement to upgrade quite a bit of hardware in or

[libreoffice-users] Where are the nightly builds for Linux?

[Steven P. Ulrick]

Hello, Everyone
I hope that this is not too off topic, but I was wondering...  Where are the 
nightly builds for Linux?  

The following three directories are now empty:




This is the last nightly build that I have been able to install:

Version 4.1.0.0.alpha0+ (Build ID: 4a507f732d82c188ad81b022cbe3037951e58ac)
TinderBox: Linux-Fedora17-x86_64@4-gcc-4.7-dbgutil, Branch:master, Time: 
2012-12-24_14:04:36

The directory that I downloaded it from is now empty:


Any help you can give me in solving this mystery is greatly appreciated.

Steven P. Ulrick

-- 
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] is MSFT running scared ...

[webmaster-Kracked_P_P]

Maybe you should give the URL for the Linux-based boot repair disk [.iso 
file download].  I do not remember it it.


I have two different disk type/names.

"boot-repair-disk.iso" - 355 MB

"ubuntu-secure-remix-12.10-32-bit.iso" - 787 MB
"ubuntu-secure-remix-12.10-64-bit.iso" - 797.1 MB

I think I used the "boot-repair-disk" version since all you had to do 
was choose your OS version/type you are using.  I think I remember 
correctly that there was only 4 buttons to choose from once the disk/OS 
booted up.


My Dell laptop had 32-bit Vista even though 64-bit Vista was out and 
working.  Too cheap maybe to include it, since it cost us more for the 
64-bit version back then.  I just upgraded that dual boot laptop 64-bit 
Win7 professional from 32-bit Vista and 64-bit Ubuntu 12.10 from 12.04 
version.  Win7/pro killed the dual booting till I ran the "repair 
disk".  I tend to use the Ubuntu boot for the testing of the newest 
version of Ubuntu [10.04 to 10.10 to 11.04 to 11.10 to 12.04 to 12.10] 
before I upgrade it on my "production desktop".  I upgraded the Vista to 
Win7/pro [64-bit] so I can have a working 64-bit Windows OS on one of my 
systems without going to Win8, since I do not have any touch screens 
except on my Android 4.0 tablet.


Actually, I wonder if Win7 or Win8 would break the dual [or triple] 
booting a laptop if both boot partitions were running a Windows OS 
before one was upgraded from XP or Vista to Win7 or Win8?  Would Windows 
break the multi-boot if there would be two+ Windows OSs on the same 
system but in different boot partitions?


Windows 2000 was for business based on Win NT, while Win Millennium was 
for the home user based on Win98.  Millennium was worse than Vista ever 
was and most users I dealt with switched to Win 2000 till XP [home or 
professional]  came out.


Win8 look and feel is a reworking of their failed smart phone OS. They 
decided that they still liked it and moved it to the Win8 tablet OS.  
BUT, someone had the bad idea of wanting all of "your" Windows based 
systems to look and "feel" the same.  I do not want my "production 
desktop" to have the "look and feel" of my tablet. I hated Unity's look 
and feel when it came out in the Spring of 2011.  Win8 seemed to look 
and feel the same.  I read that a large number of Ubuntu user switched 
to Mint Linux because of Unity.  If MS would have looked at the 
"fallout" when Ubuntu went to Unity, maybe they would have thought twice 
about using a tablet looking OS desktop display for their desktop/laptop 
OSs.  I kept Ubuntu, but switched to MATE for the desktop environment.


For my opinion what business users in my area will do with new Win8 
systems; not buy them if they can get new Win7 systems or downgrade the 
new Win8 systems to Win7.  Every business user I have talked to locally 
hates the look of Win8 and do not want to have to pay for the training 
to get their users to be able to use it.  XP/Vista to Win7 was a little 
change, but XP/Vista/Win7 to Win8 was a real big change that needs a lot 
of training.  TV ads for retail computer stores use to offer free Win8 
training so people could learn how to deal with the big changes.  Well, 
those TV ads are all gone, along with most of the Win8 ads [number of 
ads per day/week] are gone now.  Almost all of the MS's tablet are gone 
now, but there are some major computer companies [like HP] ads about 
tablet to laptop convertibles though replacing MS's "tablet with a 
keyboard" ads..





On 01/21/2013 04:55 PM, Tom Davies wrote:

Hi :)
There is always 'unexpectedly low' take-up of Windows newest OS when 
it first gets released.  Historically corporate users have learned to 
leave it until after at least the first Service Pack gets released.  
One time MS tried to boost sales by claiming that Service Pack 1 was 
included in the initial release.


Usually there is a requirement to upgrade quite a bit of hardware in 
order to run the newer version of Windows and that creates reluctance 
until people have had time to save-up or plan for rolling out new 
hardware for the new OS.


Installing Windows always installs their boot-loader (used to be 
"ntldr") which overwrites the MBR of the hard-drive and then ignores 
any other OSes on the machine so that you can only boot into Windows.  
To reinstate your MBR just boot into a LIveCd or LiveUsb or some other 
way of booting into a Gnu&Linux and just repair or reinstall just the 
boot-loader of your distro. You don't need a special recovery or 
repair disk although those sorts of things are just one way to boot 
into a Gnu&Linux. You also don't need to reinstall the entire distro.  
It's just a case of repairing your boot-loader.  One of the final 
steps of the repair involves 'updating' your boot-loader and if that 
is one on a unix-based platform (such as Gnu&Linux, Bsd or whatever) 
then it picks up the new version of Windows that your just installed.  
Fixing the Mbr is really easy once you have done it once.


Typica

Re: [libreoffice-users] #NAME? error in valid formula in xlsx format spreadsheet

[Tom Davies]

Hi :)
Are you saying that the problem doesn't happen if you save in Xls or Ods 
formats?  If the problem only happens with XlsX format then can you
1.  avoid using that format and try to keep "an original" in either Ods or Xls? 
 Obviously Ods is the prefered one but if you need to share with MS Office 
users then Xls might be needed.  
2.  File a bug-report about the XlsX problem
https://wiki.documentfoundation.org/BugReport
Regards from
Tom :)  





>
> From: Eric J Owens 
>To: users@global.libreoffice.org 
>Sent: Monday, 21 January 2013, 19:59
>Subject: [libreoffice-users] #NAME? error in valid formula in xlsx format 
>spreadsheet
> 
>TIA!
>
>I have an xlsx format spreadsheet with several formulas:
>
>=PRODUCT(SUM(months("10/21/2012",NOW(),1),months("11/6/2012",NOW(),1)) ,50)
>
>When I close and re-open the spreadsheet, the cell with the formula gives
>me the #NAME? error.  The first time I saw this and after quite a while
>trying to determine what was wrong, I figured out that nothing at all was
>wrong with the formula.  All it takes for the spreadsheet to do the
>calculation is to modify the cell.  For example, changing just one of the
>"months()" functions to "MONTHS()" and then pressing enter will allow the
>cell to calculate the value, even though only one of the months() functions
>has been capitalized.  In fact, thinking that there might be some option
>making the function be case specific, when I first noticed the problem, I
>had tried to capitalize the months() function, but when I hit enter, the
>upper case was subsequently changed to lower case and the calculation was
>performed anyway.  When the spreadsheet is saved in ods or xls format, the
>formula is calculated as would be expected after a close/re-open and the
>months() is upper cased to MONTHS().
>
>Since I know how to fix the error after re-opening, it isn't a big deal,
>but it sure would be nice not having to edit all the formulas just to get
>my calculations performed.  Any idea why closing and re-opening the xlsx
>spreadsheet causes the formula to error when there really is no error?
>Other than saving in ods or xls format, any idea how to fix the issue?
>
>Thanks!
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] base masks

[Paolo Debortoli]

Il 21/01/2013 23:10, Dan Lewis ha scritto:

On 01/21/2013 03:00 AM, Paolo Debortoli wrote:

Il 21/01/2013 01:48, Dan Lewis ha scritto:

On 01/20/2013 05:58 PM, Paolo Debortoli wrote:
hi. using base...  is there a way to open masks without borders or 
tools, just the mask, to make it smaller ?


 I an not sure I understand what you mean. The only thing in 
Base that has a mask that I know is a pattern field. It has two of 
them: an edit mask and a literal mask. The properties for this field 
are listed in the Control tool when the pattern field is highlighted.
 Are you talking about a field in a form? Is it a pattern field? 
Do you want to make the mask in the pattern field smaller but not 
the pattern field? If this is true, what you really want to do is to 
change the size of the font for this field. Click the field while 
holding down the Control button. This highlights the field but not 
its label. Then right click the field and select Control from the 
pop up window. Scroll down through the properties until you find the 
Font property. Click the ellipse (...) for the Font property to open 
the Character dialog. Reduce the size of the text, and click OK.
 If this is not what you want, will you please be more specific 
about what you have and what you want to do.


--Dan

sorry, wrong translation... I meant formulary, form, questionnaire, 
the third voice from up on the left in the 'database' menu. if there 
is a way to open an object without window border / controls, just the 
object.  trying resizing.
 OK, you mean form. No, you can not open an object of Base (Table, 
Query, Form, or Report) without a window border. Your operating system 
(probably a version of Windows) places the window border around the 
object you open.
 Have you checked to see of there is a mailing list like this one 
for your native language. Then you should be able to get the 
information you need in your language.


--Dan

yes, no.  thank you for your answer.  I am using linux ubuntu. there are 
a couple of features of ms access...  one is the possibilities to define 
borders and scrollbars in the object properties (though it is not an 
important feature, just useful to simplify).  yes, i also use italian 
mailing list, but there was no talking about at the moment. ok.


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

[libreoffice-users] Re: missing dialog option in Win7 install?

[NoOp]

On 01/20/2013 08:27 AM, webmaster-Kracked_P_P wrote:
> On 01/19/2013 06:46 PM, NoOp wrote:
>> On 01/19/2013 06:43 AM, webmaster-Kracked_P_P wrote:
>>> I just noticed a difference in the Tools > Options > LibreOffice >
>>> General "options" in the 3.6.4 versions.
>>>
>>> With my 64-bit Debian install, there is a section for "Print dialogs"
>>> and the option for that is "Use LibreOffice dialogs".
>>>
>>> With my install on Windows 7 professional, that "Print dialogs" section
>>> is missing.
>>>
>>> I do not know if it is missing in my Windows installs for earlier
>>> versions of LO, since I updated all my Windows systems to 3.6.4 last month.
>>>
>>> I know, for Ubuntu, I need to click that check box in order to get LO to
>>> print duplex pages properly for my Epson Artisan 810 printer. With that
>>> option, both my HP Laserjet 2300dn and Canon MG6220 [inkjet] printers
>>> are duplexing properly as well.
>>>
>>> I am running Ubuntu 12.04 64-bit OS with MATE desktop environment and
>>> Win7/pro 64-bit systems[plus Ubuntu 10.04 and Win XP/pro]  So my Linux
>>> system show it, but my Windows systems do not.
>>>
>>> It there a reason that DEB installs need that option and Windows do not?
>> Probably for the same reason that you don't have spadmin in Windows
>> versions... (CUPS etc).
>>
>> ...
> 
> Well there should be no difference with the print dialogs between 
> versions.  Are you going to use the systems "default" print dialogs or 
> the package's?  Checking the box does not change the print dialogs used 
> for LO.  It is always LO's dialogs instead of the one that the other 
> packages use.  So either way, it uses a different print dialog than the 
> Ubuntu/Debian default print dialog used by packages like Firefox or GIMP.

The Ubuntu linux distro supplied version does indeed work.

LibreOffice 3.5.4.
Build ID: 350m1(Build:2)
This product was supplied by The Document Foundation, Debian and Ubuntu.

When unchecked, LO(U) uses the GTK print dialog.

It does not work in the linux LO Versions:
o LibreOffice 3.5.7.2
Build ID: 3215f89-f603614-ab984f2-7348103-1225a5
o 3.6.4.3 (Build ID: 2ef5aff)
o 4.0.0.0.beta2 (Build ID: 4104d660979c57e1160b5135634f732918460a0)
version. (It probable doesn't work in the LODev4 version because there
is no 'Enable experimental (unstable) features'.)

So file a bug report. Or add to an existing one:




[Use LibreOffice dialogs option for print dialog is ignored]
(filed 8 days before you started this thread, so quite recent)



-- 
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: missing dialog option in Win7 install?

[NoOp]

On 01/20/2013 09:13 AM, Luuk wrote:
> On 19-01-2013 15:43, webmaster-Kracked_P_P wrote:
>>
>> I just noticed a difference in the Tools > Options > LibreOffice >
>> General "options" in the 3.6.4 versions.
>>
>> With my 64-bit Debian install, there is a section for "Print dialogs"
>> and the option for that is "Use LibreOffice dialogs".
>>
>> With my install on Windows 7 professional, that "Print dialogs" section
>> is missing.
>>
>>
> 
> i just upgraded my Windows7 to Libreoffice 3.6.4.3  (from 3.6.1)
> This setting did exist in 3.6.1

Yes it was/is: Windows Version 3.6.1.1 (Build ID: 4db6344)
However, it doesn't change from the LO print dialog even if
'experimental' is enabled.

> And it no longer there in 3.6.4.3

Most likely because it didn't do anything (in Windows).

> 
> Enabling 'experimatal features' does not resolve this...
> 




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

[Dan Lewis]

On 01/21/2013 03:00 AM, Paolo Debortoli wrote:

Il 21/01/2013 01:48, Dan Lewis ha scritto:

On 01/20/2013 05:58 PM, Paolo Debortoli wrote:
hi. using base...  is there a way to open masks without borders or 
tools, just the mask, to make it smaller ?


 I an not sure I understand what you mean. The only thing in Base 
that has a mask that I know is a pattern field. It has two of them: 
an edit mask and a literal mask. The properties for this field are 
listed in the Control tool when the pattern field is highlighted.
 Are you talking about a field in a form? Is it a pattern field? 
Do you want to make the mask in the pattern field smaller but not the 
pattern field? If this is true, what you really want to do is to 
change the size of the font for this field. Click the field while 
holding down the Control button. This highlights the field but not 
its label. Then right click the field and select Control from the pop 
up window. Scroll down through the properties until you find the Font 
property. Click the ellipse (...) for the Font property to open the 
Character dialog. Reduce the size of the text, and click OK.
 If this is not what you want, will you please be more specific 
about what you have and what you want to do.


--Dan

sorry, wrong translation... I meant formulary, form, questionnaire, 
the third voice from up on the left in the 'database' menu. if there 
is a way to open an object without window border / controls, just the 
object.  trying resizing.
 OK, you mean form. No, you can not open an object of Base (Table, 
Query, Form, or Report) without a window border. Your operating system 
(probably a version of Windows) places the window border around the 
object you open.
 Have you checked to see of there is a mailing list like this one 
for your native language. Then you should be able to get the information 
you need in your language.


--Dan

--
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] is MSFT running scared ...

[Tom Davies]

Hi :)
There is always 'unexpectedly low' take-up of Windows newest OS when it first 
gets released.  Historically corporate users have learned to leave it until 
after at least the first Service Pack gets released.  One time MS tried to 
boost sales by claiming that Service Pack 1 was included in the initial 
release.    

Usually there is a requirement to upgrade quite a bit of hardware in order to 
run the newer version of Windows and that creates reluctance until people have 
had time to save-up or plan for rolling out new hardware for the new OS.  

Installing Windows always installs their boot-loader (used to be "ntldr") which 
overwrites the MBR of the hard-drive and then ignores any other OSes on the 
machine so that you can only boot into Windows.  To reinstate your MBR just 
boot into a LIveCd or LiveUsb or some other way of booting into a Gnu&Linux and 
just repair or reinstall just the boot-loader of your distro.  You don't need a 
special recovery or repair disk although those sorts of things are just one way 
to boot into a Gnu&Linux.  You also don't need to reinstall the entire distro.  
It's just a case of repairing your boot-loader.  One of the final steps of the 
repair involves 'updating' your boot-loader and if that is one on a unix-based 
platform (such as Gnu&Linux, Bsd or whatever) then it picks up the new version 
of Windows that your just installed.  Fixing the Mbr is really easy once you 
have done it once.  

Typically Windows seem to have 1 bad version followed by 1 good one and then 
the next is bad.  Vista was apparently so bad that many people said they 
"upgraded" from Vista back to Xp.  Even though that was a backwards step many 
considered it an upgrade.  Win7 was quite good.  Before Xp was Millenium which 
was generally considered so appalling that people are more likely to have heard 
of Win98.  So, people might be expecting Win8 to be another dead OS.  

However there is also often quite strong resistance to new things.  Especially 
to new versions of Windows.  people have just about become familiar with the 
older one and don't like the newer ways of doing things and the fact that it's 
difficult to find things or work out how to deal with issues that they had just 
learned how to solve on the previous.  With Gnu&Linux it doesn't matter what 
changes happen to the DE you can always modify it or even just install the old 
one on your new OS.  

Regards from
Tom :)  







>
> From: webmaster-Kracked_P_P 
>To: users@global.libreoffice.org 
>Sent: Monday, 21 January 2013, 16:34
>Subject: Re: [libreoffice-users] is MSFT running scared ...
> 
>On 01/21/2013 10:41 AM, anne-ology wrote:
>>         ... maybe not, but this makes me wonder why they were promoting this
>> new OS and now are plugging a how-to re. it  ;-)
>> 
>> http://www.techsupportalert.com/content/get-free-book-windows-8-microsoft-press.htm?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+gizmosbest+%28Gizmo%27s+Best-ever+Freeware%29
>> 
>>         As for me, I'm very thankful there's LO, and with such a great
>> help-list of fellow users  :-)
>> 
>
>The articles I have read seem to tell Win7 users to forget to upgrade to Win8 
>if you do not have a touch screen.
>
>MS's tablet has had low sales figures, much lower than expected or the hype 
>would let you believe.
>
>So, giving tech people a free e-book about Win8 is a way for them to promote 
>that OS.
>
>I have heard from a few business users where they took their Win8 upgrade and 
>"degrade" it back to XP or Win7.  So maybe MS needs to convince the business 
>users to buy the Win8 upgrade or even new Win8 systems, instead of upgrading 
>to, and/or buying, systems with, Win7.
>
>I just upgraded 32-bit Vista to 64-bit Win7/pro instead of the cheaper priced 
>Win8 deal.  I have it on a laptop that is a dual boot for 64-bit Win7/pro and 
>64-bit Ubuntu 12.10 [with MATE desktop environment].  That upgrade "killed" 
>the dual booting so I need to use the repair disk.  The way I have read seems 
>to be that Win8 would do something with that laptop where it would not be able 
>to dual even after the boot fixing disk. I use the laptop for my main Windows 
>laptop and the Ubuntu boot is where I test out the new version[s] of the OS 
>before I install it onto my main "production" desktop.  I hate the Unity 
>desktop for Ubuntu, so why would I buy Win8 with the same type of desktop 
>"tile" look and feel.
>
>
-- 
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: Problems with "Merge" in Draw

[Tom]

Hi :)
You can use the Nabble way of viewing the mailing list and upload
'attachments' to Nabble instead.  Just either 
1.  follow the links in this email or
2.  from the official LibreOffice website try
"Get Help" - Nabble 
and then navigate to this thread.  

Once here start writing a reply and while doing so click on the "More"
button at the top of the message.  The top option in the "more" button
allows you to upload file and that puts a link to the uploaded file into the
message itself.  

Regards from
Tom :)  




--
View this message in context: 
http://nabble.documentfoundation.org/Problems-with-Merge-in-Draw-tp4030803p4030929.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] #NAME? error in valid formula in xlsx format spreadsheet

[Eric J Owens]

TIA!

I have an xlsx format spreadsheet with several formulas:

=PRODUCT(SUM(months("10/21/2012",NOW(),1),months("11/6/2012",NOW(),1)) ,50)

When I close and re-open the spreadsheet, the cell with the formula gives
me the #NAME? error.  The first time I saw this and after quite a while
trying to determine what was wrong, I figured out that nothing at all was
wrong with the formula.  All it takes for the spreadsheet to do the
calculation is to modify the cell.  For example, changing just one of the
"months()" functions to "MONTHS()" and then pressing enter will allow the
cell to calculate the value, even though only one of the months() functions
has been capitalized.  In fact, thinking that there might be some option
making the function be case specific, when I first noticed the problem, I
had tried to capitalize the months() function, but when I hit enter, the
upper case was subsequently changed to lower case and the calculation was
performed anyway.  When the spreadsheet is saved in ods or xls format, the
formula is calculated as would be expected after a close/re-open and the
months() is upper cased to MONTHS().

Since I know how to fix the error after re-opening, it isn't a big deal,
but it sure would be nice not having to edit all the formulas just to get
my calculations performed.  Any idea why closing and re-opening the xlsx
spreadsheet causes the formula to error when there really is no error?
 Other than saving in ods or xls format, any idea how to fix the issue?

Thanks!

-- 
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] is MSFT running scared ...

[anne-ology]

   same here;
   when I had to purchase a new laptop - previous one's HD was
failing - I received the free option to upgrade to WIN8,
  but have no intention of so doing due to all the negative
comments I've heard of that OS.

   Thus, when I saw this item, I thought all of you computer whizzes on
this list would be interested  ;-)



On Mon, Jan 21, 2013 at 10:34 AM, webmaster-Kracked_P_P <
webmas...@krackedpress.com> wrote:

On 01/21/2013 10:41 AM, anne-ology wrote:
>
>> ... maybe not, but this makes me wonder why they were promoting
>> this
>> new OS and now are plugging a how-to re. it  ;-)
>>
>> http://www.techsupportalert.**com/content/get-free-book-**
>> windows-8-microsoft-press.htm?**utm_source=feedburner&utm_**
>> medium=email&utm_campaign=**Feed%3A+gizmosbest+%28Gizmo%**
>> 27s+Best-ever+Freeware%29
>>
>> As for me, I'm very thankful there's LO, and with such a great
>> help-list of fellow users  :-)
>>
>>
> The articles I have read seem to tell Win7 users to forget to upgrade to
> Win8 if you do not have a touch screen.
>
> MS's tablet has had low sales figures, much lower than expected or the
> hype would let you believe.
>
> So, giving tech people a free e-book about Win8 is a way for them to
> promote that OS.
>
> I have heard from a few business users where they took their Win8 upgrade
> and "degrade" it back to XP or Win7.  So maybe MS needs to convince the
> business users to buy the Win8 upgrade or even new Win8 systems, instead of
> upgrading to, and/or buying, systems with, Win7.
>
> I just upgraded 32-bit Vista to 64-bit Win7/pro instead of the cheaper
> priced Win8 deal.  I have it on a laptop that is a dual boot for 64-bit
> Win7/pro and 64-bit Ubuntu 12.10 [with MATE desktop environment].  That
> upgrade "killed" the dual booting so I need to use the repair disk.  The
> way I have read seems to be that Win8 would do something with that laptop
> where it would not be able to dual even after the boot fixing disk. I use
> the laptop for my main Windows laptop and the Ubuntu boot is where I test
> out the new version[s] of the OS before I install it onto my main
> "production" desktop.  I hate the Unity desktop for Ubuntu, so why would I
> buy Win8 with the same type of desktop "tile" look and feel.
>
>

-- 
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] Problems with "Merge" in Draw

[Regina Henschel]

Hi Kai,


Kai Bettzieche schrieb:

Dear all,

I'm experiencing a problem with Draw's function "merge":

As you can see in attachment #1 (map_1.png), I'm trying to build a
map (yeah, not exactly, what Draw is there for ..) Now I'd like to
merge the "roads" (the long grey boxes) with the "corners" (the grey
circles).

Result: see attachment #2 (map_2.png) - even though I definetly
pressed "merge", the shapes do not get merged at all.


Attachments are stripped from the mail. Please provide them somewhere to 
download.


Please tell, whether you use custom shapes or primitive shapes and 
whether your shapes are filled or not.


Kind regards
Regina

--
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] is MSFT running scared ...

[webmaster-Kracked_P_P]

On 01/21/2013 10:41 AM, anne-ology wrote:

... maybe not, but this makes me wonder why they were promoting this
new OS and now are plugging a how-to re. it  ;-)

http://www.techsupportalert.com/content/get-free-book-windows-8-microsoft-press.htm?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+gizmosbest+%28Gizmo%27s+Best-ever+Freeware%29

As for me, I'm very thankful there's LO, and with such a great
help-list of fellow users  :-)



The articles I have read seem to tell Win7 users to forget to upgrade to 
Win8 if you do not have a touch screen.


MS's tablet has had low sales figures, much lower than expected or the 
hype would let you believe.


So, giving tech people a free e-book about Win8 is a way for them to 
promote that OS.


I have heard from a few business users where they took their Win8 
upgrade and "degrade" it back to XP or Win7.  So maybe MS needs to 
convince the business users to buy the Win8 upgrade or even new Win8 
systems, instead of upgrading to, and/or buying, systems with, Win7.


I just upgraded 32-bit Vista to 64-bit Win7/pro instead of the cheaper 
priced Win8 deal.  I have it on a laptop that is a dual boot for 64-bit 
Win7/pro and 64-bit Ubuntu 12.10 [with MATE desktop environment].  That 
upgrade "killed" the dual booting so I need to use the repair disk.  The 
way I have read seems to be that Win8 would do something with that 
laptop where it would not be able to dual even after the boot fixing 
disk. I use the laptop for my main Windows laptop and the Ubuntu boot is 
where I test out the new version[s] of the OS before I install it onto 
my main "production" desktop.  I hate the Unity desktop for Ubuntu, so 
why would I buy Win8 with the same type of desktop "tile" look and feel.



--
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] Calc sliding scale formulae?

[Hylton Conacher (ZR1HPC)]

Hi,

On 18/01/13 18:04, Tom Davies wrote:

Hi :)
That was my approach too but then i forgot to send my spreadsheet to Hylton and 
by the time i remembered Jay had produced an answer that took it to the next 
level.  I think it's good to see these sorts of problems occasionally because 
it pushes us outside of our normal thought processes.
Regards from
Tom :)


I still await that spreadsheet Tom :)

I hope the further explanation I sent the list makes it thru this time.

Please forward it to me via pvt email.

Tnx

Hylton





From: Dan Lewis 
To: users@global.libreoffice.org
Sent: Friday, 18 January 2013, 15:34
Subject: Re: [libreoffice-users] Calc sliding scale formulae?

   Perhaps the private suggestion was correct. Perhaps your understanding 
of Algebra is not as good as it needs to be. After all this is an Algebra 
problem.
   Now for some questions:
1. How much will 1 to 150 units cost? What is the formula to determine this?
2. How much will 151 to 599 units cost you? What is the formula for this?
3. How much will 600 units cost? What is the formula to determine this?
4. How much will 601 or more units cost you? What is the formula for this?
5. What is the cost per unit for any given number of units? What is the formula 
for this? (Hint: this is a very simple division problem.)
Hint: I have asked you for 5 formula, and that is also the number of cells you 
will need: one cell per formula. You will be using a result in some cells in 
the formula in another cell.

--Dan

On 01/18/2013 07:00 AM, Hylton Conacher (ZR1HPC) wrote:

It has been privately suggested to me that I want my work done for me, however, 
whilst I have had theory from the list on how the formulae should work, I have 
not had anyone indicating how I can get Calc to only use a particular formula 
range until its result exceeds the amount allowed for that formula, and to then 
use a different range for the remaining value.

My email below indicates the scales used, and please see below for the 
calculation of the number of units per pricing bracket obtained, using a 
calculator.

What is the main problem is getting Calc to only use a formula up until a max 
value before moving onto the next formula.

Assuming I purchased R2000 of the unit(electricity). As per the scale I would 
get 150 units at R1.29 which would equate to R193.50, which leaves a further 
R1806.50 that was used to buy electricity, but at different rate per unit.

Taking the remaining R value and dividing it by 1.35(being the next value in 
the sliding scale) provides an answer of 1338.1 units. Only 450 units are 
allowed to be purchased at this price however, so 450*1.35=R607.50.

So all in all we have only spent 193.50 and 607.50 = R801.00 out of R2000.

Therefore the remaining R1199.00 divided by 1.60(being the next value in the 
sliding scale) = 749.38 units.

Therefore our R2000 purchased 150+450+749.38=1349.38 units.

I trust the above better explains what I need Calc to do. Perhaps it is not 
possible, but I challenge you all to solve this one.


On 01/10/2013 10:38 AM, Hylton Conacher (ZR1HPC) wrote:

Hi,

I am using Calc 3.4.5 on openSuSe Linux 11.2

I am working on a spreadsheet to cater for the monthly measurement of
household electricity consumption, new unit purchase and costing of
used units.

The electricity supplier gives me the first 150 units of electricity
at R1.29 per unit. The next 450 units are costed at R1.35 per unit.
Thereafter the units cost me R1.60 per unit. The monetary values per
set amount of unit changes when the electricity provider increases
prices i.e. the first 150 units might increase to R1.50 per purchased
unit, the next 450 units might be costed at R1.55 and thereafter units
will cost R2.00.

Each time I purchase electricity the units I am allocated are based on
the above sliding scale starting from 0.

How can I work out the number of units I will receive for a given
currency value i.e. R2000.00? i.e. x @ R1.29, y @ R1.35 and z @ R1.60=
R2000

In addition how could I work out the value of units consumed using the
above scale?

I am assuming the R values in the scale will change over time and
these can each be averaged to calculate the cost of units used, but
the problem is still to work out the formula.

Anybody have an idea if this is possible and where to start?

I am investigating results found on Google but would appreciate a
pointer or three.

Thanks
Hylton

If I understand your problem, you have a general equation of ax + by +
cz = d where a = 150, b = 350, c is currently unknown, d = 2000 (or any
value you choose), x = 1.29, y = 1.35, and c = 1.60. Solving for c, you
get c = (d - ax - by)/z.

Average cost per unit, ave, is ave = (a + b + c)/d., if I understand
your question The value c must be calculated prior to this step. In
terms of a Calc formula the c value would reference the cell with the
previous calculation.

In your spreadsheet I would set a table with named cells for each val

Fwd: Re: [libreoffice-users] Calc sliding scale formulae?

[Hylton Conacher (ZR1HPC)]

This message never seemed to get thru :(


 Original Message 
Subject: Re: [libreoffice-users] Calc sliding scale formulae?
Date: Fri, 18 Jan 2013 14:00:19 +0200
From: Hylton Conacher (ZR1HPC) 
Reply-To: LibreOffice Users 
To: users@global.libreoffice.org

It has been privately suggested to me that I want my work done for me,
however, whilst I have had theory from the list on how the formulae
should work, I have not had anyone indicating how I can get Calc to only
use a particular formula range until its result exceeds the amount
allowed for that formula, and to then use a different range for the
remaining value.

My email below indicates the scales used, and please see below for the
calculation of the number of units per pricing bracket obtained, using a
calculator.

What is the main problem is getting Calc to only use a formula up until
a max value before moving onto the next formula.

Assuming I purchased R2000 of the unit(electricity). As per the scale I
would get 150 units at R1.29 which would equate to R193.50, which leaves
a further R1806.50 that was used to buy electricity, but at different
rate per unit.

Taking the remaining R value and dividing it by 1.35(being the next
value in the sliding scale) provides an answer of 1338.1 units. Only 450
units are allowed to be purchased at this price however, so
450*1.35=R607.50.

So all in all we have only spent 193.50 and 607.50 = R801.00 out of R2000.

Therefore the remaining R1199.00 divided by 1.60(being the next value in
the sliding scale) = 749.38 units.

Therefore our R2000 purchased 150+450+749.38=1349.38 units.

I trust the above better explains what I need Calc to do. Perhaps it is
not possible, but I challenge you all to solve this one.


On 01/10/2013 10:38 AM, Hylton Conacher (ZR1HPC) wrote:

Hi,

I am using Calc 3.4.5 on openSuSe Linux 11.2

I am working on a spreadsheet to cater for the monthly measurement of
household electricity consumption, new unit purchase and costing of
used units.

The electricity supplier gives me the first 150 units of electricity
at R1.29 per unit. The next 450 units are costed at R1.35 per unit.
Thereafter the units cost me R1.60 per unit. The monetary values per
set amount of unit changes when the electricity provider increases
prices i.e. the first 150 units might increase to R1.50 per purchased
unit, the next 450 units might be costed at R1.55 and thereafter units
will cost R2.00.

Each time I purchase electricity the units I am allocated are based on
the above sliding scale starting from 0.

How can I work out the number of units I will receive for a given
currency value i.e. R2000.00? i.e. x @ R1.29, y @ R1.35 and z @ R1.60=
R2000

In addition how could I work out the value of units consumed using the
above scale?

I am assuming the R values in the scale will change over time and
these can each be averaged to calculate the cost of units used, but
the problem is still to work out the formula.

Anybody have an idea if this is possible and where to start?

I am investigating results found on Google but would appreciate a
pointer or three.

Thanks
Hylton

If I understand your problem, you have a general equation of ax + by +
cz = d where a = 150, b = 350, c is currently unknown, d = 2000 (or any
value you choose), x = 1.29, y = 1.35, and c = 1.60. Solving for c, you
get c = (d - ax - by)/z.

Average cost per unit, ave, is ave = (a + b + c)/d., if I understand
your question The value c must be calculated prior to this step. In
terms of a Calc formula the c value would reference the cell with the
previous calculation.

In your spreadsheet I would set a table with named cells for each value
(a1 is Base_Rate and is 1.29, etc) so you can easily change the values
and see the values used.

--

Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds
largest non profit NGO






--
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] is MSFT running scared ...

[anne-ology]

   ... maybe not, but this makes me wonder why they were promoting this
new OS and now are plugging a how-to re. it  ;-)

http://www.techsupportalert.com/content/get-free-book-windows-8-microsoft-press.htm?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+gizmosbest+%28Gizmo%27s+Best-ever+Freeware%29

   As for me, I'm very thankful there's LO, and with such a great
help-list of fellow users  :-)

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

[Alexander Thurgood]

Le 21/01/13 16:01, Mark Stanton a écrit :

> Isn't hsqldb *still* a (relatively) good choice, as long as it is installed 
> and 
> used *external* to Base?  That does of course mean it's still not the 
> "default" 
> setting.

As I mentioned in my answer to Tom, if you use an external version of
hsqldb, it can only be the same version number as the internal version
provided with LO, else the old ODB files can no longer be opened. In
other words, you can not install an external hsqldb jar and expect your
old ODB(hsqldb) files to keep working, as this will throw an error.

So yes, it still remains a possibility, but one that you may want to
avoid if you still have old ODB files that use the internal hsqldb with
an older revision number than the externa jar you plug into LO.

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

[Alexander Thurgood]

Le 21/01/13 16:17, Tom Davies a écrit :

Hi Tom,

> I thought the back-end stayed external and Base would just link to it?  
> 
> Is the connector for this a bit broken too?  

It has nothing to do with a connector, I was referring to your question
re the possibility of substituting internal hsqldb for an external one.
This is discussed in the Base user guide, I believe, but it no longer
works, if you want to use a different version of hsqldb than the one
that LO uses internally. Anway, this is off topic with regard to the
initial question.


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] Re: Base Report Builder

[Tom Davies]

Hi :)
I thought the back-end stayed external and Base would just link to it?  

Is the connector for this a bit broken too?  
Regards from
Tom :)  





>
> From: Alex Thurgood 
>To: users@global.libreoffice.org 
>Sent: Monday, 21 January 2013, 13:34
>Subject: [libreoffice-users] Re: Base Report Builder
> 
>On 01/21/2013 11:57 AM, Tom Davies wrote:
>> Hi :)
>>>From what i can gather it is better to have the tables as data in an 
>>>external database.  Apparently the internal ancient and heavily tweaked 
>>>version of HSqlDb is a bit problematic but moving the tables to an external 
>>>proper and more recent version (or to a different back-end entirely)  
>
>You can't currently successfully load a second, more recent version of
>hsqldb.jar into LO (via the Java classpath/archive declaration dialog)
>without untoward consequences, i.e. you can no longer open your existing
>hsqldb ODB files without getting a driver loader error...
>
>see here :
>
>https://bugs.freedesktop.org/show_bug.cgi?id=34411
>
>
>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
>
>
>
>
-- 
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 Report Builder

[Mark Stanton]

> If you really need to rely on your data keeping its coherency and
> consistency, my advice would be not to use the default hsqldb/ODB pair
> that is provided as the default. It is a shame really, as hsqldb in
> itself, certainly in its 2.0 version, is a capable db engine. It is just
> the integration with AOO/LO that is one of the root causes of many of
> the problems that users experience.

Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and 
used *external* to Base?  That does of course mean it's still not the "default" 
setting.

Regards
Mark Stanton



-- 
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] Problems with "Merge" in Draw

[Daniel A. Rodriguez]

2013/1/21 Kai Bettzieche 
>
> Dear all,
>
> I'm experiencing a problem with Draw's function "merge":
>
> As you can see in attachment #1 (map_1.png), I'm trying to build a map
(yeah, not exactly, what Draw is there for ..)
> Now I'd like to merge the "roads" (the long grey boxes) with the
"corners" (the grey circles).
>
> Result: see attachment #2 (map_2.png) - even though I definetly pressed
"merge", the shapes do not get merged at all.
>
> The issue is reproducable:
>
> Create a circle with width=1cm and height 1cm.
> Create a rectangle with width=1cm and any height.
> Align the bottom centre of the rectanlge with the centre of the circle.
> Now rotate the rectangle by 60 degree (120 work as well), rotating point
is the bottom centre of the rectangle.
> Now merge: The result shows anything but a merge.
>
> Tested with:
> Libre Office for PortableApps.com on Win7 as well as Libre Office on
Ubuntu (current versions each of them)
>
> Could you advise, please, and tell me what to do, to get those shapes
merged properly?
>
>
>
> Thank you and kind regards,
> Kai
>
> p.s. attached you can find the odp file, too - just in case ..

Remenber that this list doesn't support attached files.

About the issue, try selecting Shapes > Merge from contextual menu. I've
just got a merged shape using LO 4.0.0 RC1.

And finally, use TDF binaries from libreoffice.org/download


regards, hope this helps






--~--~-~--~~~---~--~~
Escuelas Libres :: Porque la educación es mucho mejor cuando es libre
www.escuelaslibres.org.ar
---
LiberTICs Cooperativa Ltda.
www.libertics.com.ar
---
Para entrenar, cualquier programa sirve. Para educar, sólo Software Libre.
(Federico Heinz)
---

-- 
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] Problems with "Merge" in Draw

[Kai Bettzieche]

Dear all,

I'm experiencing a problem with Draw's function "merge":

As you can see in attachment #1 (map_1.png), I'm trying to build a map (yeah, 
not exactly, what Draw is there for ..)
Now I'd like to merge the "roads" (the long grey boxes) with the "corners" (the 
grey circles).

Result: see attachment #2 (map_2.png) - even though I definetly pressed 
"merge", the shapes do not get merged at all.

The issue is reproducable:

Create a circle with width=1cm and height 1cm.
Create a rectangle with width=1cm and any height.
Align the bottom centre of the rectanlge with the centre of the circle.
Now rotate the rectangle by 60 degree (120 work as well), rotating point is the 
bottom centre of the rectangle.
Now merge: The result shows anything but a merge.

Tested with:
Libre Office for PortableApps.com on Win7 as well as Libre Office on Ubuntu 
(current versions each of them)

Could you advise, please, and tell me what to do, to get those shapes merged 
properly?



Thank you and kind regards,
Kai

p.s. attached you can find the odp file, too - just in case ..
-- 
Wir leben im digitalen Zeitalter. 
Durch das Internet wurde ein immenser Wissenspool geschaffen. 
Informationen sind nicht länger das Privileg einer selbsternannten Elite. 
Antworten stehen jedem jederzeit in beliebiger Menge zur Verfügung. 
Jedoch müssen wir wieder lernen, die richtigen Fragen zu stellen.


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

[Alex Thurgood]

On 01/21/2013 11:57 AM, Tom Davies wrote:
> Hi :)
>>From what i can gather it is better to have the tables as data in an external 
>>database.  Apparently the internal ancient and heavily tweaked version of 
>>HSqlDb is a bit problematic but moving the tables to an external proper and 
>>more recent version (or to a different back-end entirely)  

You can't currently successfully load a second, more recent version of
hsqldb.jar into LO (via the Java classpath/archive declaration dialog)
without untoward consequences, i.e. you can no longer open your existing
hsqldb ODB files without getting a driver loader error...

see here :

https://bugs.freedesktop.org/show_bug.cgi?id=34411


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] Problem with IMPRESS - LibreOffice

[reinhol...@t-online.de]

hallo regina, 

ich habe jetzt LIBREOFFICE 3.5.7.2 deinstalliert, dann LIBREOFFICE
4.0.0.1 installiert und jetzt klappt es einwandfrei. 

vielen dank und beste grüsse 

chris  

  Von: Regina Henschel 
 An: reinhol...@t-online.de
 Betreff: Re: [libreoffice-users] Problem with IMPRESS - LibreOffice
 Datum: Fri, 18 Jan 2013 02:35:19 +0100

 Hallo Chris,

 reinhol...@t-online.de [1] schrieb:
 > Hallo Regina,
 >
 > danke schonmal für deine Antwort. Ich schreibe in Deutsch weiter,
wenn
 > es Recht ist.
 >
 > Ich habe nun folgendes versucht:
 >
 > IMPRESS gestartet und über das Menü "Datei - Öffnen" versucht,
direkt
 > aus dem Programm die *.ppt Datei zu öffnen.
 >
 > Klappt leider auch nicht, es erscheint wieder der ASCII FILTER.
 >
 > Dann im Explorer einen Rechtsklick auf die Datei und dann über
"Öffnen
 > mit" IMPRESS ausgewählt, wieder der ASCII FILTER.
 >
 > Übrigens öffnet LIBREOFFICE die Datei, nach Klick auf OK im ASCII
FILTER
 > dann mit dem WRITER !?
 >
 > Die ersten Zeichen kann ich nicht kopieren, sieht alles vollkommen
wirr
 > aus. Einen Datei-Typ kann man daraus nicht erkennen. Irgendetwas
von
 > Photoshop steht dort. Im Anhang ein Bild der ersten Seite.
 >
 > Die Datei gibt es unter folgendem Link, so wie sie auch auf der CD
ist:
 >
 >
http://www.file-upload.net/download-7073986/IMPRESS_CANT_OPEN_THIS_PPT.zip.html
[2]
 >
 >

 Ich habe die Datei runtergeladen. Mit LO4.0 und mit AOO3.4.1 kann ich

 die Datei problemlos öffnen und auch abspielen, wenn ich sie über
das 
 Datei-Menü öffne. Es geht allerdings alles etwas langsam wegen der 
 vielen Bilder.

 WICHTIG!
 >
 > Die Sache ist, dass diese Datei aus der Flash-Oberfläche von CD
während
 > einer Beamer-Präsentation aufgerufen werden muss, deshalb müsste
ich es
 > irgendwie hinbekommen, dass diese Datei sich ohne Umstände
während der
 > Präsentation öffnen lässt.
 >
 > POWERPOINT 2003 weigert sich übrigens, die Präsentation in einem
älteren
 > *.ppt Format zu speichern.
 >
 > "Sie versuchen, einen Dateityp zu speichern, der durch die
 > Registrierungsrichtlinien blockiert wird".

 Das Dateiformat ist schon in Ordnung. Ich habe nur befürchtet, dass
die 
 Datei irgendein Format ist, und jemand einfach die 
 Dateinamen-Erweiterung geändert hat.

 >
 > Ich werde es später mal mit LIBREOFFICE 4.0.0.1 probieren.

 Ich habe auch keinen Unterschied zwischen LibreOffice und Apache 
 OpenOffice feststellen können. Andere Versionen habe ich im Moment
nicht 
 zum Testen, weil ich meinen Rechner gerade neu aufsetze.

 Mit freundlichen Grüßen
 Regina

Links:
--
[1] javascript:void(0)
[2]
?ctl=dereferer&to=aHR0cDovL3d3dy5maWxlLXVwbG9hZC5uZXQvZG93bmxvYWQtNzA3Mzk4Ni9JTVBSRVNTX0NBTlRfT1BFTl9USElTX1BQVC56aXAuaHRtbA%3D%3D

-- 
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] Problem with IMPRESS - LibreOffice

[reinhol...@t-online.de]

hi brian, 

thank u for the "re-saved" copies, but they did not work with
LIBREOFFICE 3.5.7.2, too. 

no way to open them, LIBREOFFICE still asking for ASCII filter and
then freeze. 

i have to be able to start this *.ppt from the cd, because the
complete cd have to be presented via projector to a crowd, so the idea
with "reburning" was good, but the files do not work. 

i now uninstalled LIBREOFFICE 3.5.7.2 and installed LIBREOFFICE
4.0.0.1 and everything works fine. 

best regards from germany 

chris 

  Von: Brian Barker 
 An: Chris Noname 
 Betreff: Re: [libreoffice-users] Problem with IMPRESS - LibreOffice
 Datum: Fri, 18 Jan 2013 02:41:33 +0100

 At 00:43 18/01/2013 +0100, you wrote:
 >danke schonmal für deine Antwort. Ich schreibe 
 >in Deutsch weiter, wenn es Recht ist.

 Sorry, but I don't write German.

 >http://www.file-upload.net/download-7073986/IMPRESS_CANT_OPEN_THIS_PPT.zip.html
[1]

 I'm sending you a link (from an alternative 
 address) to two re-saved copies, one saved from 
 OpenOffice, and the other repaired by Powerpoint 
 2007.  Will either of these open in your LibreOffice?

 >Die Sache ist, dass diese Datei aus der 
 >Flash-Oberfläche von CD während einer 
 >Beamer-Präsentation aufgerufen werden muss, 
 >deshalb müsste ich es irgendwie hinbekommen, 
 >dass diese Datei sich ohne Umstände während der Präsentation
öffnen lässt.

 Can you copy the files to a new CD but include the repaired .ppt
document file?

 I trust this helps.

 Brian Barker - privately

Links:
--
[1]
?ctl=dereferer&to=aHR0cDovL3d3dy5maWxlLXVwbG9hZC5uZXQvZG93bmxvYWQtNzA3Mzk4Ni9JTVBSRVNTX0NBTlRfT1BFTl9USElTX1BQVC56aXAuaHRtbA%3D%3D

-- 
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] PPA for 4.0rc1?

[Tom Davies]

Hi :)
I don't know if the PPAs are still being maintained now that LibreOffice is in 
the main official repos for Ubuntu (and most other distros now).  If you want 
to access different versions of LibreOffice then on the downloads page is an 
innocuous-looking sentence saying something like "to change system or 
language".  The sentence itself is clickable and gives you tons of choices of 
different versions of LO.  After choosing which languae it then gives a choice 
of 4 different versions of LibreOffice.  
Regards from
Tom :)  





>
> From: Fabian Rodriguez 
>To: 
>Cc: "users@global.libreoffice.org"  
>Sent: Monday, 21 January 2013, 2:15
>Subject: Re: [libreoffice-users] PPA for 4.0rc1?
> 
>On 13-01-20 06:15 PM, Tom Davies wrote:
>> It is possible to download LibreOffice directly from the official
>> website.  It's available as a ".deb"  for Debian/Ubuntu family and
>> then just install the download. 
>> https://wiki.documentfoundation.org/Installing_LibreOffice_on_Linux
>
>I already do that, but I was certain I had seen somewhere there was a
>different PPA for dev versions.
>
>F.
>
>-- 
>Fabián Rodríguez
>http://libreoffice.magicfab.ca
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base Report Builder

[Tom Davies]

Hi :)
>From what i can gather it is better to have the tables as data in an external 
>database.  Apparently the internal ancient and heavily tweaked version of 
>HSqlDb is a bit problematic but moving the tables to an external proper and 
>more recent version (or to a different back-end entirely)  

http://hsqldb.org/web/hsqlFAQ.html

Unfortunately HSqlDb is currently written in Java and Java has been 
deteriorating badly over the last 2 years so it might be better to find a 
different back-end.  Apparently Postgresql, MySql/MariaDb are good fairly large 
scale back-ends but they might be a lot heftier than you really need.  I'm 
still trying to find a good one for smaller amounts of data, such as one for a 
reasonable address-book.  


You might find that increasing a lot of the memory/Ram options might reduce 
crashes.  

Tools - Options - Memory
Most of the defaults are set very low because OOo and LO have typically been 
used on very low spec machines.  Now as people are using them on heftier 
machines a lot of those could be bumped up significantly or even doubled or 
more.  


Ii was wondering if other programs also crash.  If so then it might be a wobbly 
graphics card and pushing it in firmly can help.  Also every year or so my home 
machine starts crashing because of dust build-up inside the case.  Hoovering it 
carefully, especially the cpu's heat-sink, solves it.  Of course one of the 
dangers is getting rid of static from the hoover's plastic noozle.  Swiftly 
moving air rubbing over plasitc is a great way to build-up static and any 
movement over carpets is another good way.  Even the tiny static charge 
naturally occuring on skin is enough to fry some components so it's tricky to 
be careful enough.  So, soemtimes i just blow the dust out of the ehat-sink but 
it's a weird choking dust so i keep a glass of milk or mango juice nearby in 
case i breathe the dust in.  Water or wine tend to be tooo dry.


Regards from
Tom :)







>
> From: Hank Alper 
>To: Dan Lewis  
>Cc: users@global.libreoffice.org 
>Sent: Monday, 21 January 2013, 6:14
>Subject: Re: [libreoffice-users] Base Report Builder
> 
>Hi Dan,
>I really appreciate your help in this matter. If I am able to reduce the
>crashes I'll post again to let everyone know.
>Hank
>
>On Sun, Jan 20, 2013 at 11:49 PM, Dan Lewis  wrote:
>
>>       The HSQLDB user guide for version 1.8 (which is what is used in all
>> LO versions) is available at:
>> https://wiki.documentfoundation.org/Documentation/Publications. Scroll
>> down to section 5.2. It should be answer your questions. The AutoRecovery
>> is found: Tools > Options > Load/Save > General. Look in the Save section
>> for settings for backups and AutoRecovery. I have not used MS Word since I
>> used Win 98SE in the 90's so I do not know. (I have used Linux for more
>> than ten years.)
>>      CHECKPOINT DEFRAG might be a good command to use to reduce the size
>> of the database. Another command that you could use when you finish working
>> with Base: SHUTDOWN COMPACT. The user guide explains what this will do. But
>> only use it when you are ready to close Base. Then use Tools > SQL and
>> enter SHUTDOWN COMPACT; in the Command to execute box. The semi-colon is
>> required at the end of the command. After executing this command
>> successfully, close Base. If your database is somewhat bloated, this will
>> reduce its size.
>>      I found this in an email I received earlier, perhaps from this
>> mailing list:
>> - hsqldb embedded databases will now systematically be subjected to a
>> "checkpoint" and/or "checkpoint defrag" on saving of the database file. The
>> aim with this change is to force hsqldb to optimize the size of the db,
>> especially where frequent deletions of data sets are carried out. With a
>> bit of luck, it might actually bring long-term benefits like increased data
>> security and stability (he says, crossing fingers). There may well be a
>> performance hit when closing the ODB file, especially on big databases, but
>> the developer who implemented this change feels that people who want to
>> manipulate large datasets should be using something a bit more appropriate
>> than an embedded hsqldb...
>>      The date on the above email was a couple of weeks ago. So, this
>> statement likely does not apply to LO 3.6.4.3.
>>
>> --Dan
>>
>>
>> On 01/20/2013 10:04 PM, Hank Alper wrote:
>>
>> Hi Dan,
>> Thanks for your quick response. I"m using LO version3.6.4.3 Build ID
>> :2ef5aff on a Windows 7 Pro machine. My machine's processor is an Intel
>> i7-2600K with 8Gig of memory and 1TB hard drive. I use periodic  backups to
>> another machine on my network. As for  AutoRecovery,  whenever there is a
>> catastrophic failure Base auitomatically tries to recover my database file
>> on the next start-up. Is that what you're referring to.? If not, I was
>> unaware that Base has such a feature.Is it similar to that used In MS Word?
>>  As for CHECKPOINT, I have

Re: [libreoffice-users] Re: How to format a date in Inpress

[Giuseppe Greco]

Alex,

It works :-) Thank you very much!

j3d

On 2013-01-21 10:32, Alex Thurgood wrote:

On 01/20/2013 09:00 PM, Giuseppe Greco wrote:

Hi Giuseppe,

Is that possible? It looks like only predefined formats can be 
applied.




I can only think of a workaround :

Open a writer document, type your phrase and insert the date into it
from the Field menu. Then right mouse  button click on the date and
change the format, which means you'll probably have to create a
User-defined format, e.g.  which you then save. Now, select your
sentence from your Writer document, and copy/paste it into your ODP
document. This will create a textbox (in fact it is a Writer object)
with the phrase in it, which you can then fiddle around with to get 
it

positioned how you want on your sheet.


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: How to format a date in Inpress

[Alex Thurgood]

On 01/20/2013 09:00 PM, Giuseppe Greco wrote:

Hi Giuseppe,

> Is that possible? It looks like only predefined formats can be applied.
> 

I can only think of a workaround :

Open a writer document, type your phrase and insert the date into it
from the Field menu. Then right mouse  button click on the date and
change the format, which means you'll probably have to create a
User-defined format, e.g.  which you then save. Now, select your
sentence from your Writer document, and copy/paste it into your ODP
document. This will create a textbox (in fact it is a Writer object)
with the phrase in it, which you can then fiddle around with to get it
positioned how you want on your sheet.


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

[Alex Thurgood]

On 01/20/2013 10:31 PM, Hank Alper wrote:

Hi Hank,

I
> restarted, LO blithely announced it was recovering my database. It did, but
> the new Report and the modifications to a query I made in this session were
> gone. I think* most* of this behavior is due to Report Builder. Has anyone
> else observed this type of behavior before ?.

My own personal advice would be not to use the autorecovery feature for
ODB files. What this feature does is save what is in the volatile memory
of the application at a given moment. This would be all well and good,
BUT, and this is the killer : an ODB file does not load all data from
the tables, reports, queries, etc into LO's volatile memory, only parts
of that data (crap design, I know, but it was done initially for
performance reasons). This means that if you get a crash, only a part of
your whole ODB file data is actually saved to a temporary file, which is
then used during the autorecovery process. The fact that you have not
lost more data/queries/reports is pure luck so far.

Instability of Base ODB files when opened within the LO application in
general is one reason (apart from dependence on Java) why there is a
search on for a replacement backend that would allow for more robust
binary streaming. In the end, it may turn out that the ODB file, as with
other db backends, e.g. server backends like mysql and postgres, will
become just a container for forms, queries and reports, and the actual
data will be held in a separate file. This should actually make the data
handling more robust, but performance might become an issue (not that
current hsqldb/ODB performance is stellar, coz it isn't). Someone was
looking at the possibility of using firebird.  For the moment, however,
nothing has been decided or actually undertaken as far as I know.

If you really need to rely on your data keeping its coherency and
consistency, my advice would be not to use the default hsqldb/ODB pair
that is provided as the default. It is a shame really, as hsqldb in
itself, certainly in its 2.0 version, is a capable db engine. It is just
the integration with AOO/LO that is one of the root causes of many of
the problems that users experience.



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 masks

[Alex Thurgood]

On 01/21/2013 09:00 AM, Paolo Debortoli wrote:

Hi Paolo,

> sorry, wrong translation... I meant formulary, form, questionnaire, the
> third voice from up on the left in the 'database' menu. if there is a
> way to open an object without window border / controls, just the
> object.  trying resizing.
> 

A form is a ODF document. There are probably ways to hide the toolbars
by messing with the XCU configuration files of ODB file used to contain
your forms, queries, etc, or even with the general XCU files of
LibreOffice, but then you might mess up much more than just your form.
You may also be able to set the size of your form (dimensions x,y) via
the Form Properties.

Seems to me that a dialog box might be a better alternative for what you
want, but that would require you to mess around with the LO Basic IDE
editor.


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 masks

[Paolo Debortoli]

Il 21/01/2013 01:48, Dan Lewis ha scritto:

On 01/20/2013 05:58 PM, Paolo Debortoli wrote:
hi. using base...  is there a way to open masks without borders or 
tools, just the mask, to make it smaller ?


 I an not sure I understand what you mean. The only thing in Base 
that has a mask that I know is a pattern field. It has two of them: an 
edit mask and a literal mask. The properties for this field are listed 
in the Control tool when the pattern field is highlighted.
 Are you talking about a field in a form? Is it a pattern field? 
Do you want to make the mask in the pattern field smaller but not the 
pattern field? If this is true, what you really want to do is to 
change the size of the font for this field. Click the field while 
holding down the Control button. This highlights the field but not its 
label. Then right click the field and select Control from the pop up 
window. Scroll down through the properties until you find the Font 
property. Click the ellipse (...) for the Font property to open the 
Character dialog. Reduce the size of the text, and click OK.
 If this is not what you want, will you please be more specific 
about what you have and what you want to do.


--Dan


sorry, wrong translation... I meant formulary, form, questionnaire, the 
third voice from up on the left in the 'database' menu. if there is a 
way to open an object without window border / controls, just the 
object.  trying resizing.


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