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:
Hi,
menu:FindReplace...
Search: whatever
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:
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
2012/7/19 Graham Luffrum grhmlf...@gmail.com:
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
-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
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 tomdavie...@yahoo.co.uk wrote:
Hi :)
There is an excellent guide on writing Macros
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:
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
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
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
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=83t=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
And I
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 username
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=83t=26448
Andreas, I owe you an apology. I was irritated by the replies on
permissions and failed to read far enough in the tutorial. The
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
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:
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:
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
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:
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:
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
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
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 naipaul.o...@gmail.com wrote:
From: Naipaul Ojar naipaul.o...@gmail.com
Subject: [libreoffice-users] unsubscribe
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
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
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
On 19/07/2012 at 07:02, NoOp gl...@sbcglobal.net 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
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 digi...@sbcglobal.net wrote:
Steve,
I was using 3.4 and
On 07/19/2012 03:33 PM, Mirosław Zalewski wrote:
On 19/07/2012 at 07:02, NoOp gl...@sbcglobal.net 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
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
30 matches
Mail list logo