Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
On Mon, Jun 6, 2011 at 3:40 PM, plino wrote: > Hi Jack > > I couldn't make it work. In fact I just found out that array functions > don't > work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) > > I don't know if it ever worked (I use it every now and then, so I couldn't > say if I used it before in OOo/LO) but if it did, someone broke it :) > > Another bug to fix for 3.5 :) > > -- > View this message in context: > http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3032323.html > Sent from the Users mailing list archive at Nabble.com. > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to > postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > From nvrk - Here's a crude attempt at efficiently finding non numerical entries in a long column of numbers. For each entry =if(isnumber(A1)<>1;Row();"") conditionally formatted in a bright color if desired. Single cell of =min(A1:Axxx) -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] infinite pagination loop on open of docx
Jeff On Mon, 2011-06-06 at 23:44 +, jha...@comcast.net wrote: > Hi, > > I attempt to open a 53 page .docx document (from MS Office 2010) with > LibreOffice 3.3.1 (Suse Linux 11.2). The document opens (shows "Page 1/53" in > the lower left corner) and is pretty much readable but then if I scroll down > a couple of pages, its interface will freeze and in the lower left corner > where it did show "Page 1/53" the "53" is an ever increasing number. I let it > get up to about 8000 once before I killed the program to make it stop. Once, > it froze the KDE GUI. I had to ctrl-alt-F1 to get to a console login and kill > LibreOffice with the bash kill command. > > It does the same thing if I try to export the file as a PDF. > > The document does have some complicated diagrams. Perhaps they are throwing > it. > > I just want to read this document. No immediate need to edit it. > > Any clues as to settings or options to keep the page counter from going > ballistic when I open this thing? > > Thanks, > > Jeff Haran LO 3.3.x has trouble successfully opening .docx format files. Success seems to be hit or miss with 3.3.x. I have heard reports that 3.4.0 has better success opening .docx formats but I have not confirmed this. I have seen macro generated documents in particular be very troublesome with 3.3.x. LO 3.4.0 is not all the repositories yet so I do not know if you can currently upgrade with Suse or if you wish to try downloading it and installing. I check the Ubuntu repository and the current LO release is 3.3.2 and I am not sure when 3.4.0 will be pushed out. -- Jay Lozier jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] infinite pagination loop on open of docx
Hi, I attempt to open a 53 page .docx document (from MS Office 2010) with LibreOffice 3.3.1 (Suse Linux 11.2). The document opens (shows "Page 1/53" in the lower left corner) and is pretty much readable but then if I scroll down a couple of pages, its interface will freeze and in the lower left corner where it did show "Page 1/53" the "53" is an ever increasing number. I let it get up to about 8000 once before I killed the program to make it stop. Once, it froze the KDE GUI. I had to ctrl-alt-F1 to get to a console login and kill LibreOffice with the bash kill command. It does the same thing if I try to export the file as a PDF. The document does have some complicated diagrams. Perhaps they are throwing it. I just want to read this document. No immediate need to edit it. Any clues as to settings or options to keep the page counter from going ballistic when I open this thing? Thanks, Jeff Haran -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] OOo extension services back up again - with some updated dictionaries
http://extensions.services.openoffice.org is back running again - finally Plus they have the French dictionary updates, with others as well. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Hi Jack I couldn't make it work. In fact I just found out that array functions don't work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) I don't know if it ever worked (I use it every now and then, so I couldn't say if I used it before in OOo/LO) but if it did, someone broke it :) Another bug to fix for 3.5 :) -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3032323.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Delete key doesn't work in the Basic Macro editor!
2011/6/6 Nuno J. Silva : > Johnny Rosenberg writes: > >> LibreOffice 3.4 (the one at the Libre Office site, the most recent one >> released 2011-06-03) >> Ubuntu 10.10 >> >> When writing BASIC macros I can't delete with the Delete key, so I >> need to move the cursor and delete using the Backspace key instead. > > Someone already noticed that: > https://bugs.freedesktop.org/show_bug.cgi?id=37170 > > The bug is already RESOLVED FIXED, and quoting the last comment: > > ,[Comment by clio on 2011-05-31] > | The fix is going to be in 3.4.1 if not accepted as stopper. See > | http://nabble.documentfoundation.org/REVIEW-for-fix-37211-td2953176.html > ` > > So I guess it didn't make to 3.4.0 but will be fixed in the next > release. Okay, thanks for the info. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > -- > Nuno J. Silva (aka njsg) > gopher://sdf-eu.org/1/users/njsg > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Delete key doesn't work in the Basic Macro editor!
Johnny Rosenberg writes: > LibreOffice 3.4 (the one at the Libre Office site, the most recent one > released 2011-06-03) > Ubuntu 10.10 > > When writing BASIC macros I can't delete with the Delete key, so I > need to move the cursor and delete using the Backspace key instead. Someone already noticed that: https://bugs.freedesktop.org/show_bug.cgi?id=37170 The bug is already RESOLVED FIXED, and quoting the last comment: ,[Comment by clio on 2011-05-31] | The fix is going to be in 3.4.1 if not accepted as stopper. See | http://nabble.documentfoundation.org/REVIEW-for-fix-37211-td2953176.html ` So I guess it didn't make to 3.4.0 but will be fixed in the next release. -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Re: LibreOffice 3.4.0
tronkel writes: >> On 06/05/2011 11:06 AM, tronkel wrote: > >> > 3.4.0 shows a correctly installed CUPS printer but refuses to actually >> > print >> > the job. [...] > > The 2 systems on which I have tried LO 3.4.0 are Slackware 13.37 and Puppy > Linux Wary 5.1.2. The printer itself is a Brother DCP7030 whose linux > driver is supplied via the Brother website. Neither of these systems have a > printing problem with LO 3.2.2. LO has never before given trouble when > printing via any version of CUPS > > Something has been changed in the latest LO 3.4.2 to stop printing working. > I suspect it may be a permissions problem with USB. If you're using CUPS, USB permission issues should happen on the CUPS side, or probably udev. (At least for the [Brother] scanner part you need to add some udev rules, and these might get overwritten by some system update.) But as your problem is only with a specific version of a specific program (LibreOffice), I seriously doubt USB permissions are the issue. Does LibO even attempt to print? Check the CUPS log at /var/log/cups/error_log and see if it mentions the job you're trying to print (just go to the end of file and check the last lines). The log here mentions jobs, even if there is no error (yes, in a file called error_log). But of course this might depend on CUPS verbosity settings. Sorry for not providing feedback on printing with 3.4.0, I don't have that version around here. -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Delete key doesn't work in the Basic Macro editor!
LibreOffice 3.4 (the one at the Libre Office site, the most recent one released 2011-06-03) Ubuntu 10.10 When writing BASIC macros I can't delete with the Delete key, so I need to move the cursor and delete using the Backspace key instead. Works perfectly with OpenOffice.org 3.2 (Ubuntu version) though. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
- Original Message > From: Johnny Rosenberg > To: users@libreoffice.org > Sent: Mon, 6 June, 2011 22:24:22 > Subject: Re: [libreoffice-users] Re: [libreoffice-users] Re: >[libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work >properly with string argument > > 2011/6/6 Clio : > > 06.06.2011 16:54, Regina Henschel пишет: > >>> > >>> Is this a bug? > >> > >> > >> No, see help text. > >> > > If the separator is dot, then no problems, but if the separator is comma, > > then this is the bug, see > > http://openoffice.org/bugzilla/show_bug.cgi?id=70236 > > Okay, I see. Thanks, Clio! > > > Best regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ > > > > > > -- > > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > > In case of problems unsubscribing, write to > > postmas...@documentfoundation.org > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/www/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
2011/6/6 Clio : > 06.06.2011 16:54, Regina Henschel пишет: >>> >>> Is this a bug? >> >> >> No, see help text. >> > If the separator is dot, then no problems, but if the separator is comma, > then this is the bug, see > http://openoffice.org/bugzilla/show_bug.cgi?id=70236 Okay, I see. Thanks, Clio! Best regards Johnny Rosenberg ジョニー・ローゼンバーグ > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to > postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
2011/6/6 Regina Henschel :
> Hi Johnny,
>
> Johnny Rosenberg schrieb:
>>
>> CDbl returns an integer when the argument is a text string.
>>
>> LibreOffice 3.4.0
>> OOO340m1 (Build:12)
>>
>> OpenOffice.org 3.2.1
>> OOO320m19 (Build:9505)
>> ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1
>>
>> Ubuntu 10.10
>>
>>
>> REM * BASIC *
>>
>> Option Explicit
>>
>> Sub Main
>> Print CDbl("123.45")
>> ' This gives an error message since my locale is Swedish (Sweden) →
>> decimal separator=comma.
>> End Sub
>
> Help: the number must be entered as normal text ("123.5") using the default
> number format of your operating system.
Yes, I know, which is ”123,5” in my case (Swedish standard is a decimal comma).
>
>>
>>
>>
>>
>> REM * BASIC *
>>
>> Option Explicit
>>
>> Sub Main
>> Print CDbl("123,45")
>> ' Prints 123, the decimals are gone.
>> End Sub
>>
>>
>> Is this a bug?
>
> No, see help text.
The Help text says nothing about CDbl removing decimals
(CDbl("123,45") → 123 when it should be 123,45, right?.
>
>> Are there other ways to convert from text to a numerical value?
>
> Try Val function.
Ooops, yes, you are right! Seems like my brain just doesn't work
today… Maybe it's because it was a very long time now since I wrote
any macros…
Still, even if I don't need CDbl, it doesn't seem to me to give the
expected results.
>
> Kind regards
> Regina
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> In case of problems unsubscribing, write to
> postmas...@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
06.06.2011 16:54, Regina Henschel пишет: Is this a bug? No, see help text. If the separator is dot, then no problems, but if the separator is comma, then this is the bug, see http://openoffice.org/bugzilla/show_bug.cgi?id=70236 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
06.06.2011 16:26, Johnny Rosenberg пишет:
CDbl returns an integer when the argument is a text string.
LibreOffice 3.4.0
OOO340m1 (Build:12)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1
Ubuntu 10.10
REM * BASIC *
Option Explicit
Sub Main
Print CDbl("123.45")
' This gives an error message since my locale is Swedish (Sweden) →
decimal separator=comma.
End Sub
REM * BASIC *
Option Explicit
Sub Main
Print CDbl("123,45")
' Prints 123, the decimals are gone.
End Sub
Is this a bug?
Are there other ways to convert from text to a numerical value?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
This is the bug http://openoffice.org/bugzilla/show_bug.cgi?id=70236
(CDbl truncates values with locale setting passed by an environment
variable)
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I have to ask (four qustions)
Johnny Rosenberg writes:
> 2011/6/5 Nuzhna Pomoshch :
>> --- On Sat, 5/28/11, Johnny Rosenberg wrote:
>>
>>> > 3. How do I get hidden ("dot" directories) to
>>> > appear in the open and save dialog boxes (they
>>> > appear in all of the window manager dialog
>>> > boxes)?
>>>
>>> On my system they appear.
>>>
>>> At Tools → Options → LibreOffice → General, the
>>> option ”☐ Use LibreOffice dialogue boxes” (or
>>> something like that; I run LibreOffice in
>>> Swedish) is unchecked. I don't remember if I
>>> unchecked> it or if it's unchecked by default,
>>> though.
>>
>> I don't have any option like that at all. Just
>> a few things (under LibreOffice / General) for
>> "help" (enabling tips and help agent), "document
>> status" (whether printing sets the "document
>> modified" status), and how to handle a two digit
>> year.
>
> Okay, I just started LibreOffice with English GUI, to make sure to get
> it right. On my system it is:
> Tools → Options… → LibreOffice → General → Open/Save dialogs → ☐ Use
> LibreOffice dialogs
> I have it unticked.
>
> ”Open/Save dialogs” is between ”Help” and ”Document status”.
This probably depends on compile options. I don't know if the OP is
using the official binaries or a modified version.
Here I don't see that option with my compiled libreoffice install (the
package manager flags include, among others, -gnome -gtk -kde),
LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2
But I see it in another computer where I installed the binary version of
libreoffice (it uses the official binaries, AFAIK),
LibreOffice 3.3.1
OOO330m19 (Build:8)
tag libreoffice-3.3.1.2
--
Nuno J. Silva (aka njsg)
gopher://sdf-eu.org/1/users/njsg
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells
On 6 Jun 2011 at 21:59, Andreas Säger wrote: To: users@libreoffice.org From: Andreas Säger Subject:[libreoffice-users] Re: Multuple rules/conditions to range of cells Date sent: Mon, 06 Jun 2011 21:59:48 +0200 Send reply to: users@libreoffice.org > Am 06.06.2011 15:12, Michael D. Setzer II wrote: > > > > I've tried another method that seems to give the results. > > Unfortunately, it appears the current() doesn't give the results of > > what is before the style when used in a formula? > > > > Difficult to tell without concrete formula. I had an earlier formula that was working using the reference to a cell like A1, but when I replaced that with current(), it did not work correctly. I assuming that since the current() was inside the other functions that it was giving some other value. The lookup options is also something I've used, and it is very useful, but just another option that is available. > > > > =(A1)+STYLE(CHOOSE(MIN(INT(((A1)-((A1) > >> 1000))/1000)+1,6),"Red_bold","red","blue_bold","blue","orange","default")) > > > > I used a single cell for the formula, but the (A1) could be replaced > > with the formula (SUM((N151+L152)-(P152+R152))) or > > (N151+L152-P152-R152) to give the same results. > > > > Would have been simpler if all the options where< multiples of > > 1000 or all<=. I also added max and min, so a negative or higher > > value would fall into the ranges. > > > > I created styles with the matching names giving the styles. > > > > Looking up the style name has 2 advantages: You can easily modify the > style names in the stylist and in the lookup table and you can modify > the threshold values in one place for all calculations including > conditional formattings. Quite often such a lookup table includes more > than 2 columns. Finding all occurrences of a particular format conditon > can be difficult. > > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +--+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI10840698.799905 | EINSTEIN 5978952.530851 ROSETTA 3215702.700203 | ABC 6158864.767707 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
Hi Johnny,
Johnny Rosenberg schrieb:
CDbl returns an integer when the argument is a text string.
LibreOffice 3.4.0
OOO340m1 (Build:12)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1
Ubuntu 10.10
REM * BASIC *
Option Explicit
Sub Main
Print CDbl("123.45")
' This gives an error message since my locale is Swedish (Sweden) →
decimal separator=comma.
End Sub
Help: the number must be entered as normal text ("123.5") using the
default number format of your operating system.
REM * BASIC *
Option Explicit
Sub Main
Print CDbl("123,45")
' Prints 123, the decimals are gone.
End Sub
Is this a bug?
No, see help text.
Are there other ways to convert from text to a numerical value?
Try Val function.
Kind regards
Regina
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Consistent 3.4.0 crash in Calc when Linking to External Data
Andy M wrote (06-06-11 22:25) OK, I see this bug has already been reported: https://bugs.freedesktop.org/show_bug.cgi?id=37673 Hope they fix it soon! Yip! And thanks for reporting back that you found the issue, Andy. Many hands make heavy work light ;-) -- - Cor - http://nl.libreoffice.org -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument
CDbl returns an integer when the argument is a text string.
LibreOffice 3.4.0
OOO340m1 (Build:12)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1
Ubuntu 10.10
REM * BASIC *
Option Explicit
Sub Main
Print CDbl("123.45")
' This gives an error message since my locale is Swedish (Sweden) →
decimal separator=comma.
End Sub
REM * BASIC *
Option Explicit
Sub Main
Print CDbl("123,45")
' Prints 123, the decimals are gone.
End Sub
Is this a bug?
Are there other ways to convert from text to a numerical value?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Consistent 3.4.0 crash in Calc when Linking to External Data
OK, I see this bug has already been reported: https://bugs.freedesktop.org/show_bug.cgi?id=37673 Hope they fix it soon! -- View this message in context: http://nabble.documentfoundation.org/Consistent-3-4-0-crash-in-Calc-when-Linking-to-External-Data-tp3026245p3031776.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Multuple rules/conditions to range of cells
Am 06.06.2011 15:12, Michael D. Setzer II wrote: I've tried another method that seems to give the results. Unfortunately, it appears the current() doesn't give the results of what is before the style when used in a formula? Difficult to tell without concrete formula. =(A1)+STYLE(CHOOSE(MIN(INT(((A1)-((A1) 1000))/1000)+1,6),"Red_bold","red","blue_bold","blue","orange","default")) I used a single cell for the formula, but the (A1) could be replaced with the formula (SUM((N151+L152)-(P152+R152))) or (N151+L152-P152-R152) to give the same results. Would have been simpler if all the options where< multiples of 1000 or all<=. I also added max and min, so a negative or higher value would fall into the ranges. I created styles with the matching names giving the styles. Looking up the style name has 2 advantages: You can easily modify the style names in the stylist and in the lookup table and you can modify the threshold values in one place for all calculations including conditional formattings. Quite often such a lookup table includes more than 2 columns. Finding all occurrences of a particular format conditon can be difficult. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Request for Technical assistance.
Hello Ruth, On Mon, 06 Jun 2011 11:58:53 -0400 (your time) you said: >> so I can't type documents and I can't access my files. When I hit Libre >> Office on my Desktop, nothing happens. I don't know what to do. Please >> help me. If you using Windows, then you could open Control Panel, Select the Add or Remove Programs (Programs and Features in Windows 7) and select the entry for LibreOffice. If using Windows 7 I believe you should see an entry named 'Repair' on the toolbar (someone else will have to confirm this) and in Windows XP just double click the entry and choose Repair form the three options. -- Si (PLO) #24852. Wig Row Hone Des? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Request for Technical assistance.
Hi :) Answer are often given at the bottom of threads rather than at the top so it's worth checking there if there appears to be no answer in a reply. From what i have seen here so far i think that downloading and saving the attachment before trying to open it might work better. Also when you next try to open LibreOffice if it asks if you want to attempt to recover a document click on "cancel" or "no" or whatever to avoid trying to recover the document. Then you should be able to open normal documents in LibreOffice again. Good luck and regards from Tom :) - Original Message > From: Ruth C. Reidbord > To: users@libreoffice.org > Sent: Mon, 6 June, 2011 16:58:53 > Subject: [libreoffice-users] Request for Technical assistance. > > My son-in-law installed Libre Office for me last month when I purchased > > a new computer. It worked fine until last week. Last week I received a > > document as an attachment on my Email which contained a survey to which > > I wanted to reply. I couldn't type in the answers so I cut and pasted > > it to a new document on Libre and when I was finished I hit Send. > > Immediately I got a message that I had done something wrong and Libre > > was closing. Since that time, 5 days ago, I can't open Libre, so I can't > > type documents and I can't access my files. When I hit Libre Office on my >Desktop, nothing happens. I don't know what to do. > > Please help me. Ruth Reidbord > > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Request for Technical assistance.
My son-in-law installed Libre Office for me last month when I purchased > a new computer. It worked fine until last week. Last week I received a > document as an attachment on my Email which contained a survey to which > I wanted to reply. I couldn't type in the answers so I cut and pasted > it to a new document on Libre and when I was finished I hit Send. > Immediately I got a message that I had done something wrong and Libre > was closing. Since that time, 5 days ago, I can't open Libre, so I can't > type documents and I can't access my files. When I hit Libre Office on my Desktop, nothing happens. I don't know what to do. > Please help me. Ruth Reidbord -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multuple rules/conditions to range of cells
Hi :) You should be able to just double-click on documents that were written in Word and they should just open in LibreOffice now. If not then right-click on the Word file and choose "Open with ..." and then find LibreOffice or Writer in the list. It is smart to create a back-up copy before doing something unfamiliar just in case something unexpected happens. So that was still a smart move. Please note that a lot of people on this list like to post their answers at the bottom of a thread. So Sigrid's idea is worth trying. Good luck and regards from Tom :) - Original Message > From: Sigrid Carrera > To: users@libreoffice.org > Cc: life48dan...@att.net > Sent: Mon, 6 June, 2011 15:12:15 > Subject: Re: [libreoffice-users] Multuple rules/conditions to range of cells > > Hi Lynn, > > On Sun, 5 Jun 2011 22:32:20 -0700 (PDT) > Lynn Wilde wrote: > > > I do have a question. I copied a book that I wrote with MS Word on to > > LibreOffice, but none of the pictures transferred, only boxes where the >pictures > > > would be. The computer on which I wrote the document ran Win XP Home >Edition. > > > I transferred all my files to this new computer, runs Win 7, downloaded > > LibreOffice and copied and pasted the book to LibreOffice. No pictures. >Much > > > frustration as there are many pictures. What's the fix? Or, will > > someone >fix > > > this problem in LibreOffice. It must be a common one. > > Please check the following setting within LibreOffice: > Tools > Options > LibreOfficee Writer > View > Is there a checkmark in front of the text "Graphics and Objects" under >Display? If not, check it and see, if the pictures appear in your text. > > > Sigrid -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Native MySQL-connection
Hello Roland, In Debian Squeeze deleting /tmp is supposedly controlled by setting TMPTIME=x in /etc/default/rcS. "0" means - delete /tmp, a negative number means don't ever delete it, while a positive number indicates the number of days till deletion. By the way - even though I reverted to using the odbc-connection to MySQL (it works just fine), I tried to install libreoffice-mysql-connector. In doing so, it "broke" my LibreOffice system (I couldn't open ANY files anymore!). The reason seems to be the Libre..-connector goes together with 3.3.2, while I had 3.4.0 installed. I obiously ended up with a "mixed-up" system. So, for me - it's odbc for the moment... Thanks for your help Regards H On Mon, 06 Jun 2011 16:23:53 +0200, Roland Hughes wrote: There are flags that you need to set. Do a search on-line. In OpenSuSE you set them with YAST, I forget where you set them with Ubuntu. /tmp is only cleaned at system boot, when it "should" be empty. Ubuntu has a lot of bugs with respect to cleaning of /tmp at system boot. It basically doesn't work if /tmp is on a different disk drive than the system disk. On Sun, 2011-06-05 at 21:25 +0200, Heinrich Stoellinger wrote: Hi Roland, I use Debian-Squeeze at the moment. Having spent too much time already doing things where I don't understand all the possible ramifications - I hesitate to delete /tmp. Is it o.k. for sure to do so or might I "hurt" something in doing so down in the depth of Linux? Regards H On Sun, 05 Jun 2011 19:58:52 +0200, Roland Hughes wrote: > I don't think it is a bug...I'm willing to bet the "connector" you have > is for a different version of MySQL or a different version of the > client. > > What distribution are you using? Not all Linux distros delete /tmp on > boot. You need to ensure that your distro is deleting /tmp on boot, > delete the user directory, REBOOT, then try your MySQL thing. OpenSuSE > does not delete /tmp by default to speed booting. Ubuntu has a lot of > bugs and only deletes it randomly under certain situations. A lot of > stuff, especially for uno it appears, gets left out in /tmp. > > > On Sun, 2011-06-05 at 18:57 +0200, Heinrich Stoellinger wrote: > >> Hi Tom, >> For me, the suggestion to delete the user directory did not work. The weird >> thing is that when downloading and then trying to activate the mysql-connector, >> I get the message that loading "mysqlc.uno.so" failed. That module is present >> in the directory mentioned in the message. >> As I mentioned before - I have gone over to usinge odbc and I am quite happy >> doing so. I hope that some time in the future somebody cleverer than me will >> fix the bug... >> Regards >> H >> >> >> On Sun, 05 Jun 2011 16:27:06 +0200, Tom Davies wrote: >> >> > /home/user/.libreoffice/3/user >> >> >> -- >> Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ >> > > -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Native MySQL-connection
There are flags that you need to set. Do a search on-line. In OpenSuSE you set them with YAST, I forget where you set them with Ubuntu. /tmp is only cleaned at system boot, when it "should" be empty. Ubuntu has a lot of bugs with respect to cleaning of /tmp at system boot. It basically doesn't work if /tmp is on a different disk drive than the system disk. On Sun, 2011-06-05 at 21:25 +0200, Heinrich Stoellinger wrote: > Hi Roland, > I use Debian-Squeeze at the moment. Having spent too much time already doing > things where I don't understand all the possible ramifications - I hesitate > to delete /tmp. Is it o.k. for sure to do so or might I "hurt" something > in doing so down in the depth of Linux? > Regards > H > > On Sun, 05 Jun 2011 19:58:52 +0200, Roland Hughes > wrote: > > > I don't think it is a bug...I'm willing to bet the "connector" you have > > is for a different version of MySQL or a different version of the > > client. > > > > What distribution are you using? Not all Linux distros delete /tmp on > > boot. You need to ensure that your distro is deleting /tmp on boot, > > delete the user directory, REBOOT, then try your MySQL thing. OpenSuSE > > does not delete /tmp by default to speed booting. Ubuntu has a lot of > > bugs and only deletes it randomly under certain situations. A lot of > > stuff, especially for uno it appears, gets left out in /tmp. > > > > > > On Sun, 2011-06-05 at 18:57 +0200, Heinrich Stoellinger wrote: > > > >> Hi Tom, > >> For me, the suggestion to delete the user directory did not work. The weird > >> thing is that when downloading and then trying to activate the > >> mysql-connector, > >> I get the message that loading "mysqlc.uno.so" failed. That module is > >> present > >> in the directory mentioned in the message. > >> As I mentioned before - I have gone over to usinge odbc and I am quite > >> happy > >> doing so. I hope that some time in the future somebody cleverer than me > >> will > >> fix the bug... > >> Regards > >> H > >> > >> > >> On Sun, 05 Jun 2011 16:27:06 +0200, Tom Davies > >> wrote: > >> > >> > /home/user/.libreoffice/3/user > >> > >> > >> -- > >> Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ > >> > > > > > > > -- > Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ > -- Roland Hughes, President Logikal Solutions (630)-205-1593 http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net No U.S. troops have ever lost their lives defending our ethanol reserves. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Problem in 3.4.0 - external links in CALC
Hi, on WIN XP i had installed LO 3.4.0. and there occured this problem: I have several files - Comp1report.ods with sheets Data,Param,report - Comp2report.ods with sheets Data,Param,report - Comp3report.ods with sheets Data,Param,report (each file has a range A1:E30 named as "Report" in the "report" sheet) and - Companies.ods with sheets C1,C2,C3,Group In Companies.ods I have named ranges C1Report in C1 sheet, C2Report in C2 sheet, C3Report in C3 sheet I used to select the range "Report" in the "report" sheet of the Comp1report.ods file by expanding the select box, then CTRL+C, then switched to Companies.ods, selected the proper range C1Report to delete the old contents and pasted as unformated text. In 3.4.0. when Companies.ods and Comp1report.ods are open the names of named ranges of Companies.ods disappeared and only a range named "Report" (which is in the other file) is displayed in the select box. After closing the files and reopening Companies.ods the range names appeared again in the select box correctly. I had to uninstall 3.4.0 and reinstal 3.3.2 due another problem with linking to external .ods files (which bug I am not able to describe with my poor english). Again I had a problem with renamed linked sheet - when I need to repair link to some external sheet I can only choose the filename but not the sheet. Best regards, Ing. Jiří Hladůvka OBUTEX spol. s r.o. EU Slovakia -- mailto:ad...@obutex.com http://www.obutex.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multuple rules/conditions to range of cells
Hi Lynn, On Sun, 5 Jun 2011 22:32:20 -0700 (PDT) Lynn Wilde wrote: > I do have a question. I copied a book that I wrote with MS Word on to > LibreOffice, but none of the pictures transferred, only boxes where the > pictures > would be. The computer on which I wrote the document ran Win XP Home > Edition. > I transferred all my files to this new computer, runs Win 7, downloaded > LibreOffice and copied and pasted the book to LibreOffice. No pictures. > Much > frustration as there are many pictures. What's the fix? Or, will someone > fix > this problem in LibreOffice. It must be a common one. Please check the following setting within LibreOffice: Tools > Options > LibreOfficee Writer > View Is there a checkmark in front of the text "Graphics and Objects" under Display? If not, check it and see, if the pictures appear in your text. Sigrid -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells
On 6 Jun 2011 at 10:55, Andreas Säger wrote: To: users@libreoffice.org From: Andreas Säger Subject: [libreoffice-users] Re: Multuple rules/conditions to range of cells Date sent: Mon, 06 Jun 2011 10:55:43 +0200 Send reply to: users@libreoffice.org > Am 05.06.2011 18:47, PLO wrote: > > Hello LO Users, > > > > I've been trying - without success - to apply five separate conditional > > formatting rule to a column based on their value. Each of the 365 cells in > > the column contain a simple formula. E.g > > > > =SUM((N151+L152)-(P152+R152)) > > > > I need the result in each of the cells to be formatted in different colour > > if it is over or below a certain value. I need five rules in total. So > > formatting would be: > > > > < 1000 Red/Bold > > => 1000< 2001 Red > > => 2001< 3001 Blue/Bold > > => 3001< 4001 Blue > > => 4001< 5001 Orange > > => 5001 Default > > > > I have used conditional formatting with success, except that it is limited > > to three conditions...which isn't enough. > > > > In MS Office 2007 I can apply any number of rules to a range of cells > > simply by selecting Conditional Formatting from 'Styles' on the Ribbon and > > adding a rule for each. > > > > Maybe there is another way in LibreOffice but I can't find it. > > I've tried another method that seems to give the results. Unfortunately, it appears the current() doesn't give the results of what is before the style when used in a formula? =(A1)+STYLE(CHOOSE(MIN(INT(((A1)-((A1) >1000))/1000)+1,6),"Red_bold","red","blue_bold","blue","orange","default")) I used a single cell for the formula, but the (A1) could be replaced with the formula (SUM((N151+L152)-(P152+R152))) or (N151+L152-P152-R152) to give the same results. Would have been simpler if all the options where < multiples of 1000 or all <=. I also added max and min, so a negative or higher value would fall into the ranges. I created styles with the matching names giving the styles. > > > This requires some preparing set up work. > 1. Create a set of 5 cell styles comprising the attributes you want to > see. (hit F11, right-click>New...) > > 2. Take some free cell range of 6 rows and 2 columns, say $X$1:$Y$5. > 0Red_Bold > 1000Red > 2000Blue_Bold > 3000Blue > 4000Orange > 5000Default > First column has threashold values, second column has your style names > which represent the formatting attributes you want to see up to the > respective threashold. > > 3. Select the cell range you want to color. Notice the row number of the > currently active input cell. > > 4. menu:Format>Conditional... > Change to for condition #1. > Formula: STYLE(VLOOKUP($H1;$X$1:$X$6;2)) > (assuming the active cell in row #1, compare values in column H and the > compare list in X1:X6). > For the active cell in row 99 and your compare values in column M the > formula would be: > STYLE(VLOOKUP($M99;$X$1:$X$6;2)) > > Greetings, > Andreas > > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +--+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI10840698.799905 | EINSTEIN 5978952.530851 ROSETTA 3215702.700203 | ABC 6158864.767707 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Consistent 3.4.0 crash in Calc when Linking to External Data
Full clean install did not fix the problem. The exception apparently occurs in MSVCR90.DLL, the Visual C++ 2008 runtime library. The version of that DLL is different between my 32-bit WinXP system and the 64-bit Win7 AMD system, which might explain why it's not failing on the Win7. It looks like LibreOffice requires at least version 9.0.30729.4148 (LibreOffice install bundle includes an installer for it, if required), and I have version 9.0.30729.5570, because of the MS security update relating to KB246174. I did try backing off that newer version of MSVCR90.DLL, so that LibreOffice was using the 4148 version, but it still crashed. Is anyone else seeing this problem? I might have to go back to 3.3.2 until this is fixed. -- View this message in context: http://nabble.documentfoundation.org/Consistent-3-4-0-crash-in-Calc-when-Linking-to-External-Data-tp3026245p3029860.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Incredibly annoying highlight problem!
I believe this is related to: https://bugs.freedesktop.org/show_bug.cgi?id=37955 Regards Jack -- View this message in context: http://nabble.documentfoundation.org/Incredibly-annoying-highlight-problem-tp3022377p3029830.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
plino wrote:
>
> But as you said, I really don't want to browse 300.000 lines to spot
> errors ;)
>
Hi plino,
for your specific case I might have a possible workaround. The following
formula (place it in any cell) would give you the row number for the first
non-numeric value in the range A1:A3.
{= MIN(IF(ISNUMBER(A1:A3), "ALL GOOD", ROW(A1:A3)))}
Do not explicitly the curly braces, they appear automatically. It must be
entered as an array function, therefore press CTRL+SHIFT+ENTER to accept the
formula, not just ENTER.
Change the 2 references (A1:A3) to the cells you want to check. If you've
corrected the value (i.e. went to the row where the non-numeric value
appears and made it numeric) then it will refer to the next non-numeric row.
This way you can systematically address each issue (if there aren't too
many).
It's not a solution for the problem, just a workaround. Nevertheless, I
hope it helps.
Regards
Jack
--
View this message in context:
http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3029781.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [Bug] LibreOffice 3.4.0 - Explorer crashes
Good point about it being explorer rather than internet explorer! I don't know why i missed that. So, it's even more important to post a bug-report about it because there isn't an easy alternative to the file-browser! Thanks and regards from Tom :) - Original Message > From: Darkguy > To: users@libreoffice.org > Sent: Mon, 6 June, 2011 11:55:43 > Subject: [libreoffice-users] Re: [Bug] LibreOffice 3.4.0 - Explorer crashes > > Same behaviour with 3.3.2. > > Basically a virgin Windows 7 Starter, not even any Samsung tools/drivers > installed. > > Only other software is IE9, Chrome (current version), Intel GMA driver, JAVA > 6u25, MS Security Essentials, Silverlight, MS VC++ 2008 redistributable > 9.0.30729.17 and 3.30729.4148, .NET Framework 4 (+ German language pack), > Adobe Reader X 10.01, and the D-Link Connection Manager for an external > HSDPA broadband stick as well as Virtual Clone Drive. > > -- > View this message in context: >http://nabble.documentfoundation.org/Bug-LibreOffice-3-4-0-Explorer-crashes-tp3029321p3029438.html > > Sent from the Users mailing list archive at Nabble.com. > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [Bug] LibreOffice 3.4.0 - Explorer crashes
Explorer.exe, as in the Windows Explorer and a Windows core component, as would be Finder in Mac OS X and Nautilus in GNOME. ;) Internet Explorer (iexplore.exe) has nothing to do with it. ;) -- View this message in context: http://nabble.documentfoundation.org/Bug-LibreOffice-3-4-0-Explorer-crashes-tp3029321p3029445.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [Bug] LibreOffice 3.4.0 - Explorer crashes
Same behaviour with 3.3.2. Basically a virgin Windows 7 Starter, not even any Samsung tools/drivers installed. Only other software is IE9, Chrome (current version), Intel GMA driver, JAVA 6u25, MS Security Essentials, Silverlight, MS VC++ 2008 redistributable 9.0.30729.17 and 3.30729.4148, .NET Framework 4 (+ German language pack), Adobe Reader X 10.01, and the D-Link Connection Manager for an external HSDPA broadband stick as well as Virtual Clone Drive. -- View this message in context: http://nabble.documentfoundation.org/Bug-LibreOffice-3-4-0-Explorer-crashes-tp3029321p3029438.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Bug] LibreOffice 3.4.0 - Explorer crashes
Tom Davies writes: > Darkguy wrote: >> >> Problem: Windows loads, user logs in, as soon as the Desktop loads, >> explorer.exe crashes, then auto-restarts, then crashes again, things go in a >> loop from there > > However, none of that is really the point. LO 'should' be able to work > without > messing up IE as there are still a lot of people using it so a bug-report > would > be a big help. Darkguy didn't mention Internet Explorer, what crashes is Windows Explorer. Although since windows 98 (or 95?) they're closely connected, sharing some parts, they're not the same thing. Unless you're running some alternative shell, you need explorer.exe to be running in order to use the windows GUI. (Also, IIRC, IE's executable is iexplore.exe, not explorer.exe.) -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Bug] LibreOffice 3.4.0 - Explorer crashes
Hi :) That is worth posting a bug-report about http://wiki.documentfoundation.org/BugReport Obviously it's better practice to minimise the number of things that automatically start at boot-up but users can be a bit strange sometimes and we should be able to cater to that. FireFox or almost any other web-browser tends to be much more robust, safer and faster. I've not tried IE9 yet, nor FF4 so things might have radically changed. Also Firefox tends to look similar across releases whereas IE keeps changing quite dramatically without changing it's under-laying security flaws in any helpful way. So, once people have got past the initial terrors of using something they are unfamiliar with they are well set for the future. The various 'skins'/add-ons allow people to get a UI they are more comfortable with anyway. However, none of that is really the point. LO 'should' be able to work without messing up IE as there are still a lot of people using it so a bug-report would be a big help. Regards from Tom :) - Original Message > From: Darkguy > To: users@libreoffice.org > Sent: Mon, 6 June, 2011 11:12:35 > Subject: [libreoffice-users] [Bug] LibreOffice 3.4.0 - Explorer crashes > > Found this when trying to "repair" a user netbook at our university's > helpdesk: > > -) Samsung NF 310 (Atom N550, 2 GB RAM, 250 GB HDD, Windows 7 Starter/32 > Bit) > > Problem: Windows loads, user logs in, as soon as the Desktop loads, > explorer.exe crashes, then auto-restarts, then crashes again, things go in a > loop from there > > -) when you enter Computer Management, the error log for the > Explorer-crashes says that MSVCR90.dll is faulty, causing the crash > > -) as soon as you get another window to go full screen and thus cover the > Desktop, the crash-loop stops > > -) if you bring up the Desktop folder in Windows Explorer, Explorer starts > crashing again > > -) if you enter a folder containg files that LO can open, Explorer crashes > (it did when accessing a USB drive that contained a few documents) > > Solution: Was for me to just uninstall LibreOffice 3.4, will try if 3.3.2 > shows the came behaviour > > -- > View this message in context: >http://nabble.documentfoundation.org/Bug-LibreOffice-3-4-0-Explorer-crashes-tp3029321p3029321.html > > Sent from the Users mailing list archive at Nabble.com. > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multuple rules/conditions to range of cells
Hi :) The "Insert>Images etc" refers to the menus at the top of the Writer window. Note that the menus at the top are File EditViewInsertHelp So click on the Insert menu. The menu drops down and contains similar items grouped together rather than being alphabetical. The various "Picture" (or "Image" in other releases and Word i guess) are near the bottom. "Object" just below it is for video or sound. If you select "Picture" then a sub-menu appears offering "From File" or "Scan ...". The "Scan ... " option is for scanner/printers so you probably want the "From file" choice. A 'pop-up' 'dialogue box' will appear so that you can navigate to the picture/image you want to include. Some of the terms are quite geeky but if you follow the instructions then you will quickly understand what they mean. Good luck and regards from Tom :) - Original Message > From: Lynn Wilde > To: users@libreoffice.org > Sent: Mon, 6 June, 2011 8:19:26 > Subject: Re: [libreoffice-users] Multuple rules/conditions to range of cells > > Thank you so much, Jean-Francois. The only information given about joining >this > > was that I could post a question, nothing was said about receiving e-mails > of > every question posted. If that had been made clear, I would not have joined. > > Your answer to my question, I'm afraid, makes no sense to me because I do > not > know where I should look for "Insert>Images, etc." original MS Word > document >or > > the one I copied to Libre Office? With the original document, as I changed > picture sizes, the whole document reformatted to accommodate changes. In > the > Lib. Off one I have only black boxes with red lettering inside showing some >type > > of designation for each picture. Can you clarify your response considering >the > > above information? Often I have problems with help because the helpers >assume > > I have more technical knowledge than I do. I'm just a retired teacher who >uses > > e-mail, writes with WORD and does web searches. I have no technical > computer > background. > Lynn > > > > > > From: Jean-Francois Nifenecker > To: users@libreoffice.org > Sent: Sun, June 5, 2011 10:59:33 PM > Subject: Re: [libreoffice-users] Multuple rules/conditions to range of cells > > > Le 06/06/2011 07:32, Lynn Wilde a écrit : > > I don't know why I got this e-mail. Please don't send me such > > e-mails again. > > You get the emails from this list because you decided to subscribe :) > > Subscribing to a mailing list such as this one has many advantages: you may >ask > > questions and read the answers and you may answer the questions for which > you > know the solution. Mailing lists are very valuable mutual help sources. > > Would you decide to unsubscribe, just have a look at the bottom of the >messages, > > where the mailing list server adds a few information: > > Unsubscribe instructions: > > Send a (empty) message to the server at E-mail to > users+h...@libreoffice.org. >A > > few moments after, you should receive an email giving more details about the > unsubscription process. > In short, you'll have to send a (empty) message to the unsubscription > address > then wait a minute for an answer from the server. Then you'll have to answer > back (another empty message) to that last message in order to confirm your > desire. > > Be aware that: > a. You'll have to run the unsubsription process using the very address you >used > > for subscription; > b. Your mailing program could consider the answers from the server as being > spam. If you don't seem to receive any answer within a few minutes, just > look > there, just in case. > > > Now, back to your question... > > > > > I do have a question. I copied a book that I wrote with MS Word on > > to LibreOffice, but none of the pictures transferred, only boxes > > where the pictures would be. The computer on which I wrote the > > document ran Win XP Home Edition. I transferred all my files to this > > new computer, runs Win 7, downloaded LibreOffice and copied and > > pasted the book to LibreOffice. No pictures. Much frustration as > > there are many pictures. What's the fix? Or, will someone fix this > > problem in LibreOffice. It must be a common one. Lynn > > > > Embedding images within a document can be made under two options: > > 1. The images are actually made part of the document, causing it to get > bigger > > and bigger, according to the images size. The advantage being that you've > got >an > > all-in-one item that is easy to carry along. > > 2. They can be just *linked* to the document. This way, the document size > remains small. The drawback is that you have to carry the whole lot > (document >+ > > images) together everytime you want to move things around. > > > Now for two new questions... > > -- How do we
Re: [libreoffice-users] Multuple rules/conditions to range of cells
Hello Lynn, On Sun, 5 Jun 2011 22:32:20 -0700 (PDT) (your time) you said: > I don't know why I got this e-mail. Please don't send me such e-mails again. As Jean-Francois has already replied, you received my message reply because you subscribed to the LibreOffice mailing list. So it was not my intention to SPAM you ;-), but then it is not within my power to prevent you receiving replies made to this list so you'll have to unsubscribe from the list if you don't want to receive any replies from me again. :-) > I do have a question. [...] Although Jean-Francois has already replied to your question, when (or if) you ask another question you would really be better off starting a new thread rather than replying to an existing one. When you reply to an existing thread that has a specific question in the message subject line your own question would inevitably become 'lost' in a thread that was started to ask a different question. That's because each email message sent contains a unique message ID which email clients are able to use to 'thread' related messages. If you reply to an existing message and the subject line is unmodified no one will know that your reply doesn't relate to to the original question, and if mailing list users are ignoring a thread your question may be ignored as well. Hope this helps. -- Si (PLO) # 7082. Sow Ngwee Or Hid? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] [Bug] LibreOffice 3.4.0 - Explorer crashes
Found this when trying to "repair" a user netbook at our university's helpdesk: -) Samsung NF 310 (Atom N550, 2 GB RAM, 250 GB HDD, Windows 7 Starter/32 Bit) Problem: Windows loads, user logs in, as soon as the Desktop loads, explorer.exe crashes, then auto-restarts, then crashes again, things go in a loop from there -) when you enter Computer Management, the error log for the Explorer-crashes says that MSVCR90.dll is faulty, causing the crash -) as soon as you get another window to go full screen and thus cover the Desktop, the crash-loop stops -) if you bring up the Desktop folder in Windows Explorer, Explorer starts crashing again -) if you enter a folder containg files that LO can open, Explorer crashes (it did when accessing a USB drive that contained a few documents) Solution: Was for me to just uninstall LibreOffice 3.4, will try if 3.3.2 shows the came behaviour -- View this message in context: http://nabble.documentfoundation.org/Bug-LibreOffice-3-4-0-Explorer-crashes-tp3029321p3029321.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells
Hello Andreas, On Mon, 06 Jun 2011 11:00:26 +0200 (your time) you said: > Second method is much easier but resticted to the formula cells you > mentioned. > 1. Create your set of cell styles as in the above solution. > 2. =SUM((N151+L152)-(P152+R152))+STYLE(VLOOKUP(CURRENT();$X$1:$Y$6;2) > Function STYLE returns zero, so the cell value won't be affected. Thanks. I shall give that a try that later today. :-) -- Si (PLO) #17510. Rho Win Wed Egos? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Multuple rules/conditions to range of cells
Am 05.06.2011 18:47, PLO wrote: Hello LO Users, I've been trying - without success - to apply five separate conditional formatting rule to a column based on their value. Each of the 365 cells in the column contain a simple formula. E.g =SUM((N151+L152)-(P152+R152)) Second method is much easier but resticted to the formula cells you mentioned. 1. Create your set of cell styles as in the above solution. 2. =SUM((N151+L152)-(P152+R152))+STYLE(VLOOKUP(CURRENT();$X$1:$Y$6;2) Function STYLE returns zero, so the cell value won't be affected. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Is this list unmoderated?
+1 - Original Message > From: plino > To: users@libreoffice.org > Sent: Mon, 6 June, 2011 9:53:30 > Subject: [libreoffice-users] Re: Is this list unmoderated? > > Nabble just LOOKS like a forum. > > Functionally, it's not. You have to subscribe to each "section" because each > is a separate mailing list. > > If Mono works in the same way, then it's not an alternative. > > Please TDF consider setting up an OFFICIAL forum! > > -- > View this message in context: >http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3029116.html > > Sent from the Users mailing list archive at Nabble.com. > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Multuple rules/conditions to range of cells
Am 05.06.2011 18:47, PLO wrote: Hello LO Users, I've been trying - without success - to apply five separate conditional formatting rule to a column based on their value. Each of the 365 cells in the column contain a simple formula. E.g =SUM((N151+L152)-(P152+R152)) I need the result in each of the cells to be formatted in different colour if it is over or below a certain value. I need five rules in total. So formatting would be: < 1000 Red/Bold => 1000< 2001Red => 2001< 3001Blue/Bold => 3001< 4001Blue => 4001< 5001Orange => 5001 Default I have used conditional formatting with success, except that it is limited to three conditions...which isn't enough. In MS Office 2007 I can apply any number of rules to a range of cells simply by selecting Conditional Formatting from 'Styles' on the Ribbon and adding a rule for each. Maybe there is another way in LibreOffice but I can't find it. This requires some preparing set up work. 1. Create a set of 5 cell styles comprising the attributes you want to see. (hit F11, right-click>New...) 2. Take some free cell range of 6 rows and 2 columns, say $X$1:$Y$5. 0 Red_Bold 1000Red 2000Blue_Bold 3000Blue 4000Orange 5000Default First column has threashold values, second column has your style names which represent the formatting attributes you want to see up to the respective threashold. 3. Select the cell range you want to color. Notice the row number of the currently active input cell. 4. menu:Format>Conditional... Change to for condition #1. Formula: STYLE(VLOOKUP($H1;$X$1:$X$6;2)) (assuming the active cell in row #1, compare values in column H and the compare list in X1:X6). For the active cell in row 99 and your compare values in column M the formula would be: STYLE(VLOOKUP($M99;$X$1:$X$6;2)) Greetings, Andreas -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Is this list unmoderated?
Nabble just LOOKS like a forum. Functionally, it's not. You have to subscribe to each "section" because each is a separate mailing list. If Mono works in the same way, then it's not an alternative. Please TDF consider setting up an OFFICIAL forum! -- View this message in context: http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3029116.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multuple rules/conditions to range of cells
Thank you so much, Jean-Francois. The only information given about joining this was that I could post a question, nothing was said about receiving e-mails of every question posted. If that had been made clear, I would not have joined. Your answer to my question, I'm afraid, makes no sense to me because I do not know where I should look for "Insert>Images, etc." original MS Word document or the one I copied to Libre Office? With the original document, as I changed picture sizes, the whole document reformatted to accommodate changes. In the Lib. Off one I have only black boxes with red lettering inside showing some type of designation for each picture. Can you clarify your response considering the above information? Often I have problems with help because the helpers assume I have more technical knowledge than I do. I'm just a retired teacher who uses e-mail, writes with WORD and does web searches. I have no technical computer background. Lynn From: Jean-Francois Nifenecker To: users@libreoffice.org Sent: Sun, June 5, 2011 10:59:33 PM Subject: Re: [libreoffice-users] Multuple rules/conditions to range of cells Le 06/06/2011 07:32, Lynn Wilde a écrit : > I don't know why I got this e-mail. Please don't send me such > e-mails again. You get the emails from this list because you decided to subscribe :) Subscribing to a mailing list such as this one has many advantages: you may ask questions and read the answers and you may answer the questions for which you know the solution. Mailing lists are very valuable mutual help sources. Would you decide to unsubscribe, just have a look at the bottom of the messages, where the mailing list server adds a few information: Unsubscribe instructions: Send a (empty) message to the server at E-mail to users+h...@libreoffice.org. A few moments after, you should receive an email giving more details about the unsubscription process. In short, you'll have to send a (empty) message to the unsubscription address then wait a minute for an answer from the server. Then you'll have to answer back (another empty message) to that last message in order to confirm your desire. Be aware that: a. You'll have to run the unsubsription process using the very address you used for subscription; b. Your mailing program could consider the answers from the server as being spam. If you don't seem to receive any answer within a few minutes, just look there, just in case. Now, back to your question... > > I do have a question. I copied a book that I wrote with MS Word on > to LibreOffice, but none of the pictures transferred, only boxes > where the pictures would be. The computer on which I wrote the > document ran Win XP Home Edition. I transferred all my files to this > new computer, runs Win 7, downloaded LibreOffice and copied and > pasted the book to LibreOffice. No pictures. Much frustration as > there are many pictures. What's the fix? Or, will someone fix this > problem in LibreOffice. It must be a common one. Lynn > Embedding images within a document can be made under two options: 1. The images are actually made part of the document, causing it to get bigger and bigger, according to the images size. The advantage being that you've got an all-in-one item that is easy to carry along. 2. They can be just *linked* to the document. This way, the document size remains small. The drawback is that you have to carry the whole lot (document + images) together everytime you want to move things around. Now for two new questions... -- How do we opt for 1.or 2.? Look at the Insert > Images > From file dialog. You'll notice there's a checkbox saying something like "Insert as link" (not sure about the English phrasing as I'm using a French version). Make sure it is UNchecked to embed the images within the document. Note that this checkbox state is saved from a session to another. This can lead to some "strange" behaviour if it was (un)checked by mistake once. If the images size is not gigantic, I'd suggest embedding them within the document. -- What if the images are simply linked and you want to store them in the document? Go to the Edit > Links dialog, select the images (multi selection is possible) and click the "Unlink" button (once again, I'm not sure about the exact wording of the button but you get the idea). Wait a few moments and you're done. Save. Hope this helps, -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@doc
[libreoffice-users] Re: LibreOffice 3.4 Base Form Background Colour
Le 06/06/11 06:23, dreamquartz a écrit : Hi, > Cannot select background colour when starting form in LO 3.4 Base. > > Any thoughts? https://bugs.freedesktop.org/show_bug.cgi?id=37626 https://bugs.freedesktop.org/show_bug.cgi?id=36107 https://bugs.freedesktop.org/show_bug.cgi?id=37619 Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Is this list unmoderated?
Just thought I'd mention the Nabble interface, for those people who want a forum-like interface. It's not perfect, but it's something. http://www.libreoffice.org/get-help/nabble-mailing-list-interface/ Regards Jack -- View this message in context: http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3028887.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
