I have a spreadsheet consisting of 4 sheets with totally different data on
each sheet.
When I enter data on sheet 1 it is automatically copied into sheet 2 and 3.
Sheet 4 remains unchanged.
How can I limit the change only to sheet 1?
--
View this message in context:
Remove the formula on the cells on sheets 2 and 3
-
from twohot@device.mobile :)
-Original Message-
From: sovdia sa...@selectspecs.com
Date: Sat, 20 Aug 2011 23:53:27
To: users@global.libreoffice.org
Reply-To: users@global.libreoffice.org
You have probably sheets 1,2,3 selected.
Right-click on the sheet bookmark (left down corner of the sheet)
an choose Deselect All Sheets
(to select some multiple sheets hold down CTRL and left click the sheets
bookmarks).
May it helps :)
Regards,
Jiri
Dne 21.8.2011 8:53, sovdia napsal(a):
Hi :)
If you don't need Sheets2 3 you can delete the entire sheets. Err, actually
you could delete them even if you do need them so it might be good tio find out
why they are there.
Regards from
Tom :)
From: Onyeibo Oku twoho...@gmail.com
To: Libre, Users
I would like to create layouts which I could use repeatedly without having to
specify all of the details every time.
I am guessing that the way to do this is by adding them to the 'predefined
layouts'.
I thought it probably had something to do with the master page, but I really
don't know.
Hi Ya'akov,
Yaakov Yehudi wrote (21-08-11 11:27)
I would like to create layouts which I could use repeatedly without having to
specify all of the details every time.
I am guessing that the way to do this is by adding them to the 'predefined
layouts'.
I thought it probably had something to
Thanks.
The error was mine; on the Mac I was tabbing through the sheets using
shift+command +page down. This actually combines the sheets. The correct way
to tab through sheets is command+page down or command+page up.
Regards
David McMillan
SelectSpecs.com
--
View this message in context:
I have somehow acquired a lot of extensions that I will never use, i.e..
Languages
Unfortunately they are all locked.
How can I remove the lock, or delete them any other way?
Tink.
--
View this message in context:
Hi,
Am looking for a way to change the dark gray background color LibreOffice
currently uses in menus, buttons, dialogs (for example, Ctrl+O Open file
dialog) and so on for something lighter. The problem is that under my monitor
setting it's difficult for me to read black text on dark gray
At 05:06 21/08/2011 -0700, J Taylor wrote:
I have somehow acquired a lot of extensions that I will never use,
i.e.. Languages Unfortunately they are all locked. How can I
remove the lock, or delete them any other way?
Extensions that are installed for all users can be removed only if
you
I am the root user on a Mac 10.6.8, Libre 3.4.2
I can alter all the Preferences, I can add Extensions but I cannot unlock
these Extensions.
The list is far too long and I want to shorten it.
Tink
--
View this message in context:
Hi Tink,
Tinkerer schrieb:
I have somehow acquired a lot of extensions that I will never use, i.e..
Languages
Unfortunately they are all locked.
How can I remove the lock, or delete them any other way?
You have to call setup again. I have only a German UI, but you will find
it surely. Choose
On 08/21/2011 09:53 AM, Regina Henschel wrote:
Hi Tink,
Tinkerer schrieb:
I have somehow acquired a lot of extensions that I will never use, i.e..
Languages
Unfortunately they are all locked.
How can I remove the lock, or delete them any other way?
You have to call setup again. I have only a
Hi,
whenever I try to change settings other than my personal data in LO unde
Lion 1.7.1 the program crashes.
a few seconds after i click on the list at the left hand side of the
options-window the program crashes and can only be terminated via the dock.
The problem exists on my new Macook Air and
Hi,
On Sat, 20 Aug 2011 23:53:27 -0700 (PDT)
sovdia sa...@selectspecs.com wrote:
I have a spreadsheet consisting of 4 sheets with totally different data on
each sheet.
When I enter data on sheet 1 it is automatically copied into sheet 2 and 3.
Sheet 4 remains unchanged.
How can I
No luck there. I want to remove others as well, such as Java script provider
and Python script provider.
There is about twelve in all, all firmly locked.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/How-do-I-delete-unwanted-Extensions-tp3272690p3272952.html
I have a rather long writer document that was apparently resaved during a
time when I had a server on my desktop (Mac OS X Lion). Now, if I do a
Save as... with this document open, I get a dialog box saying There is a
problem connecting to the server 'x' [where x is the same of that
A little additional information on the above--
I get that message at least twice while the Open/Save as... dialog box is
open but only when doing a Save as... If I pick another file format (such
as Microsoft Office) to save the file in, I get the error message one more
time.
It doesn't happen
Hi :)
You could always try a cheat to get the whole of LibreOffice back to default
settings. First find the pathname
Tools - Options - LibreOffice - Paths
and they should all show something like
/home/username/.libreoffice/3/blah blah
Now in your file-manager try finding that folder
...
Hi :)
Is there something in
Tools - Options - LibreOffice - View
perhaps untick Use system font for user interface? There might be other
schemes/skins available from the Design teams wiki?
Regards from
Tom :)
From: T Elcor tel...@yahoo.com
To:
Hi
On Sun, 2011-08-21 at 08:35 -0700, noibs wrote:
A little additional information on the above--
I get that message at least twice while the Open/Save as... dialog box is
open but only when doing a Save as... If I pick another file format (such
as Microsoft Office) to save the file in,
2011/8/20 Andreas Säger ville...@t-online.de:
Very easy: F2, Space, Enter applies a dummy change to the formula which is
forced to recalculate then.
Like any other cell function, RANDBETWEEN(min ; max) recalculates when any
of the input values change.
=RANDBETWEEN(A1;B1) recalculates when
2011/8/20 Andreas Säger ville...@t-online.de:
Do yourself a favour and switch to some mature programming language. It is a
shame that this office suite is one of the last reservations for this clunky
underdog language called Basic.
I think that would be more like doing you a favour, but that
2011/8/20 Andreas Säger ville...@t-online.de:
Johnny Rosenberg wrote:
I have never seen that validation thing before, but I can see it isuseful,
and it will probably solve a few of my problems I've had thatI previously
gave up on… :DStill there are cases when form controls are the right way
I have a presentation that was prepared in Powerpoint 2007. When I used LO
Presentation to display it the footer was rotated to a vertical column on
the left. Some bullets are also rendered as Japanese / Chinese characters.
OS is Windows 7 Home Premium 32 bit. Installed directly from media into a
Hi steelje,
steelej wrote (21-08-11 20:30)
I have a presentation that was prepared in Powerpoint 2007. When I used LO
Presentation to display it the footer was rotated to a vertical column on
the left. Some bullets are also rendered as Japanese / Chinese characters.
OS is Windows 7 Home
Hello,
I want to learn how to create a button to recalculate a cell with randbetween
function.
--
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:
In Ubuntu 11.04 I am using serveral spreadsheets that come from OpenOffice,
which came with previous versions of Ubuntu. I recently noticed that formula
cells are not always automatically adjusted according to changes in cells
used in that formula. When I even notice inconstant behaviour, I have
The problem here is that this...
Public Const STRING=4
… should not be possible. String is a reserved word and it should not be
possible to use as a name for variable. Exchange it with Public Const
sSTRING=4 and both situations you described will work just fine.
--
View this message in context:
Can i download libre office to an iPad ?
--
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:
Im using Impress to build a presentation which will be used on a kiosk in a
museum to give information about things.
Ive added a forward/backward arrow on each slide as well as a home icon
which are setup to goto the next/previous/first slides respectively.
this works fine but what I also want
On 2011-08-21 7:36 AM Tinkerer wrote:
I am the root user on a Mac 10.6.8, Libre 3.4.2
I can alter all the Preferences, I can add Extensions but I cannot unlock
these Extensions.
The list is far too long and I want to shorten it.
LibreOffice installs a bunch of unwanted extensions by default.
Thanks for the reply. I had one custom path that I redid a few minutes ago.
I went to my office today (where the server is located) and found three
LibreOffice documents (one writer and two calc) where, if they were opened,
would also connect to the server in question and the server would then
Larry Gusaas wrote:
On 2011-08-21 7:36 AM Tinkerer wrote:
I am the root user on a Mac 10.6.8, Libre 3.4.2
I can alter all the Preferences, I can add Extensions but I cannot unlock
these Extensions.
The list is far too long and I want to shorten it.
LibreOffice installs a bunch of unwanted
Hi :)
Congrats and nicely found! It's interesting to hear about problems on the
Mac because it gives us more insight into the differences. If y9uo look at
the page just after the Table of Contents in the documentation guides then
you will see a table showing some of the differences
Hi
On Sun, 2011-08-21 at 15:38 -0700, noibs wrote:
Thanks for the reply. I had one custom path that I redid a few minutes ago.
I went to my office today (where the server is located) and found three
LibreOffice documents (one writer and two calc) where, if they were opened,
would also
Hi,
On Fri, 2011-08-19 at 10:30 -0400, guin...@aol.com wrote:
Can i download libre office to an iPad ?
I do not think the iPad is supported, but the Mac is definitely
supported. I am not sure what would happen if tried to install LO on an
iPad because I am not sure of the differences
Hello,
I didn't notice the link to example file at first glance, but the
alternative of using the Data Validation tool is really very powerful!
I would never found it by myself without your example! It is really an nice
solution and it surely deserve a better publicity in the doc.
Thanks a lot
Hi,
On Fri, 2011-08-19 at 00:38 -0700, 10o wrote:
In Ubuntu 11.04 I am using serveral spreadsheets that come from OpenOffice,
which came with previous versions of Ubuntu. I recently noticed that formula
cells are not always automatically adjusted according to changes in cells
used in that
Hi
Many days ago some of us were talking about BASE and its problems. One
of you noted about Kexi base program that's part of Office Suite of
KDE ... as alternative of BASE.
I installed that Office suite in Fedora 15 and opened access 2003 data
base that I have. I can't probe
** Reply to message from Tinkerer j_taylo...@btinternet.com on Sun, 21 Aug
2011 06:36:14 -0700 (PDT)
I am the root user on a Mac 10.6.8, Libre 3.4.2
I can alter all the Preferences, I can add Extensions but I cannot unlock
these Extensions.
The list is far too long and I want to shorten it.
Hi :)
Kexi is the database app in Calligra. Calligra is a fork of KOffice. KOffice
gave all their remaining database devs to Calligra and dropped their version of
the database. Calligra seems very active.
Unfortunately Calligra and KOffice are really quite dependant on the K Desktop
Hi :)
+1
I think LibreOffice wont work on an iPad yet. It does work on OS X tho so it
might be worth trying. It might be worth having a quick look for a how to
install guide in documentation
http://wiki.documentfoundation.org/Documentation
It might also be worth trying Calligra (a fork from
Hi.
When printing a mail merge/form letter you have the option to select a
record range for the form data.
If you select From 1 to 100 then records 1 to 99 inclusive are printed,
record 100 is not.
If you select record From 50 to 50 (so you can print just record 50)
then a letter prints with no
Wanted to see if anyone else has run into what I have uploading a
presentation to Google Docs. When I take a presentation created in
PowerPoint, open it in LibreOffice and save it as a PPT to be uploaded to
Google Docs, the result is somewhere along the way, the current date gets
added in a frame
45 matches
Mail list logo