Hi,
I am trying to write a macro that will, amongst other things, lock a single
cell in a Calc sheet. I can easily test to see if the cell is locked,
using "CellProtection.IsLocked", but I don't see how to change the value.
Any ideas?
Graham
--
For unsubscribe instructions e-mail to: users+h.
Hi,
menu:Find&Replace...
Search:
button: [Select All]
Now you have a multiple selection which can be formatted by a character
style (character styles can be assigned to shortcuts) or by hard formatting.
--
View this message in context:
http://nabble.documentfoundation.org/Can-words-in-LibreOffic
On 19/07/12 11:19, Graham Luffrum wrote:
Hi,
I am trying to write a macro that will, amongst other things, lock a single
cell in a Calc sheet. I can easily test to see if the cell is locked,
using "CellProtection.IsLocked", but I don't see how to change the value.
Any ideas?
Graham
Way out
2012/7/19 Graham Luffrum :
> Hi,
>
> I am trying to write a macro that will, amongst other things, lock a single
> cell in a Calc sheet. I can easily test to see if the cell is locked,
> using "CellProtection.IsLocked", but I don't see how to change the value.
>
> Any ideas?
>
> Graham
I tried to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/18/2012 08:04 PM, webmaster-Kracked_P_P wrote:
>
> The LibreOffice North American Community DVD Project's 3.5.5-1 DVD is
now online at LO's download pages. [..]
Most excellent news!
I am going to Haïti for an IT project that includes some Libr
Hi Tom,
I'm back on deck again now.
Thanks for this URL - I've bookmarked it for future reference.
Noel
--
Noel Lodge
lodg...@gmail.com
On 8 July 2012 06:06, Tom wrote:
> Hi :)
> There is an excellent guide on writing Macros
> https://wiki.documentfoundation.org/Documentation/Publications#Pro
Lluís de Yzaguirre wrote
>
> Thanks, but could you teach a macro to do so?
>
Of course. Go ahead and write your macro if you are a programmer.
But what is it good for? Save 3 keystrokes per day or 30? Forget it.
--
View this message in context:
http://nabble.documentfoundation.org/Can-words-in
Just installed 3.5.5 and now my functions just show ### as results.
The functions are basic like min, max and sum. Any ideas why ?
--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446.html
Sent from the Users mailing list archive at Nabb
On 07/19/2012 11:55 AM, digisan wrote:
Just installed 3.5.5 and now my functions just show ### as results.
The functions are basic like min, max and sum. Any ideas why ?
--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446.html
Sent fro
That was my first thought. I tried widening the cells - drastically as well
as different formatting options. I have it set for only 3 decimal places.
--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996453.html
Sent from the Users ma
On Wed, Jul 18, 2012, at 01:06 PM, Andreas Säger wrote:
> [Tutorial] Read-Only in Base:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=26448
>
> --
>
To quote the tutorial:
0. All input forms in Base indicate "read-only" in the title bar, but
this does not matter at all
A
On Wed, Jul 18, 2012, at 01:32 PM, Andrew Brager wrote:
> On 7/18/2012 1:05 PM, Jay Lozier wrote:
> > It sounds like the file ownership got messed up.
> >
> > Depending on how comfortable you are with using the terminal I would
> > use the following to change the ownership
> >
> > chown
> >
>
>
> On Wed, Jul 18, 2012, at 01:06 PM, Andreas Säger wrote:
> > [Tutorial] Read-Only in Base:
> > http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=26448
> >
Andreas, I owe you an apology. I was irritated by the replies on
permissions and failed to read far enough in the tutori
digisan wrote:
Just installed 3.5.5 and now my functions just show ### as results.
The functions are basic like min, max and sum. Any ideas why ?
--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446.html
Sent from the Users mailing list
Here is a sample of what I'm dealing with. Thanks for the suggestion Dan.
http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods
UploadTroubleShooting.ods
--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p399648
On 2012-07-20 06:01, digisan wrote:
Here is a sample of what I'm dealing with. Thanks for the suggestion Dan.
http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods
UploadTroubleShooting.ods
--
View this message in context:
http://nabble.documentfoundation.org/Function-i
Steve,
I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot.
Does anyone know where to download 3.4, it looks like it is no longer
available on the website.
http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png
--
View this message in
Steve Edmonds wrote:
On 2012-07-20 06:01, digisan wrote:
Here is a sample of what I'm dealing with. Thanks for the suggestion Dan.
http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods
UploadTroubleShooting.ods
--
View this message in context:
http://nabble.documentfou
please nsubscribe
--
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
Just got my mac from the car, in 3.5.4.2 it is showing fine. Is your
font Arial (shows that here).
Steve
On 20/07/12 7:39 AM, digisan wrote:
Steve,
I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot.
Does anyone know where to download 3.4, it looks like it is no longer
av
digisan schrieb:
Steve,
I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot.
Does anyone know where to download 3.4, it looks like it is no longer
available on the website.
http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png
You h
Hi :)
This guide migth help you unsubscribe
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Good luck and regards from
Tom :)
--- On Thu, 19/7/12, Naipaul Ojar wrote:
From: Naipaul Ojar
Subject: [libreoffice-users] unsubscribe
To: users@global.libreoffice.org
Date: Thurs
Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas in A1621:A2000, at the moment, return empty
strings, all of them, so it looks like only the 1620 first rows
contains data.
So the formulas look
That's it. I had Formulas checked. In 3.5.5.3 on the Mac it is under
preferences. Thanks so much to all for the help.
--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996518.html
Sent from the Users mailing list archive at Nabble.com
I'd like to create a macro for a user-defined date format (H:MMa/p). As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats. So my thought is to create a macro
which creates the
On 19/07/2012 at 07:02, NoOp wrote:
> IMO, reading/replying to a high volume mailing list via
> email
IYO, what is wrong with reading/replying to a high volume mailing list via
e-mail?
I must have missed something in past year or so.
--
Best regards
Mirosław Zalewski
--
For unsubscribe instr
I have the original, complete version still on my machine -
if there's some way to get it to you, I'd be happy to so do.
[just need to know how & where to upload it]
On Thu, Jul 19, 2012 at 2:39 PM, digisan wrote:
Steve,
> I was using 3.4 and installed 3.5.5. Here is
On 07/19/2012 03:33 PM, Mirosław Zalewski wrote:
> On 19/07/2012 at 07:02, NoOp wrote:
>
>> IMO, reading/replying to a high volume mailing list via
>> email
>
> IYO, what is wrong with reading/replying to a high volume mailing list via
> e-mail?
> I must have missed something in past year or so
There is an archive of LO's installs.
But if you tell me what OS you have, I should be able to find it.
On 07/19/2012 08:32 PM, anne-ology wrote:
I have the original, complete version still on my machine -
if there's some way to get it to you, I'd be happy to so do.
Dear all,
There is a workaround for the Java 1.7.x compatibility problem
on the Windows platform mentioned in earlier discussion. Please refer to
Bugzilla " https://bugs.freedesktop.org/show_bug.cgi?id=50371 " to
install "MSVC2010 redistributable" from "
http://www.microsoft.com/en-us/down
I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze.
The progress bar on the splash screen stops part-way during startup for about
10 seconds. During this time LO sends a request of some sort over the network
connection (lights flash on router) every 2 seconds, 5 times in all. L
On 07/18/2012 09:22 PM, Larry Blanchard wrote:
Hi Larry,
I purged OO and installed LO. Still using Ubuntu 10.04.
Did you also purge (or otherwise rename) your OOo user configuration
folder ?
If I open one of my databases in LibreOffice 3.5.4.2 it works fine. If
I open the other, I can
32 matches
Mail list logo