Hello
Before possibly recommending LibreOffice to a friend who needs an office
suite for her personal use, I need to know how good its Impress component
is compared to PowerPoint.
She won't need to create very sophisticated slides, and won't need to import
PowerPoint files. It's just to create
Simos Xenitellis wrote
Impress can do an excellent job. If you want to help your friend, it
is good to teach on how to prepare a presentation, how to break down
the information so that they are put on slides. This is something
people are not being taught and end up with those boring
Ok, so I'll tell here to play with it and see how it goes.
Thank you.
--
View this message in context:
http://nabble.documentfoundation.org/How-good-is-Impress-compared-to-PowerPoint-tp4033328p405.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe
Hello
Someone sent me a Word document that triggers the familiar This document
contains macros warning when opened in LibreOffice.
It's also displayed after I save the DOC into ODT.
How can I...
1. View what macros the document contains?
2. Remove them if, in the very likely case, they are
Hello,
could anyone tell me which formula I should use for the integer part of a
cell to be shown in another cell, and for the value of this cell to be
changed, since, for example, 5,77 would become equal to 5?
When finding out who won in an election, if one group or party gets a
result of 5,28,
Thanks. Indeed, the solution is to click on the Options tab in the Sort
dialog, and uncheck Range contains column labels.
--
View this message in context:
http://nabble.documentfoundation.org/3-5-4-2-Win-Calc-Wrong-sort-order-tp4008406p4008519.html
Sent from the Users mailing list archive at
Hello
I need to sort shopping lists, but for some reason, Calc fails sorting them:
1. Select the text to be sorted
2. Data Sort Current Selection
3. Sort by (item on first line of selection) OR - undefined - :
Regardless, the list is wrongly sorted:
Thanks for the infos on how to change the styles and formatting. I only use
LO once in a while, so maybe I'll get around to reading its documentation
instead of googling for this type of thing.
--
View this message in context:
Thanks for the tip.
I opened the file, selected the block of lines I want to remove,
right-clicked on it, chose Remove Subtitles, and expected this block to be
removed and the following lines to be renumbered accordingly.
Instead, the selected lines are simply removed but nothing is done to the
Thanks much Tom for the help.
But after watching the movie a bit longer with the doctored subtitles, it
turns out that they're wrong again somewhat later, so I'll have to use an
application that shows both the movie and the subtitles to make editing
easier. Someone recommended
Hello
Here's the problem:
- an AVI video file with a few seconds removed when it was ripped from the
original DVD
- the subtitle .sub file that still contains the full data
Here's what a .sub file looks like:
-
{65364}{65474}first line that I need to remove
...
Hello
I use H1 for the document's main title, and H2 for sub-sections.
To make H2 sections more obvious, I'd like to have the text underlined and
have the underline go all the way to the right margin instead of just the
text itself.
I vaguely remember being able to do this with Word, but can
Thanks for the info. I don't have the time/courage to read the whole document
just for this, though.
Out of band, someone came up with this trick:
[quote]
Set a tab on the right margin and then insert a tab after your text, then
underline the white space after the text.
[/quote]
It works, but
Johnny Rosenberg wrote
The easiest thing is probably to select one cell, select FOOD, hit Ctrl+c,
select all the other cells in which you want the word FOOD (using Ctrl or
Shift), hit Ctrl+v.
Thanks much for the tip. It's fast enough.
Tom wrote
How about using GnuCash?
Thanks for the
Hello
I'm going through my bank statements to check how I spend money.
I'd like to use one of the columns to define the type of spending through a
drop-down list (eg. Food, Transporation, etc.)
Data Validity Allow = List does display a drop-down list, but I
couldn't find how to tell LO to
Thanks for the tip. Didn't think of this.
In the same vein, after I created a list of possible items for the drop-down
box to be displayed in that column, is it possible to select some cells
through CTRL, and apply the same item for all of them?
For instance, I'd like to select all the cells for
Hello
A cell contains a negative number that I need to turn into a positive, eg.
-123 becomes 123.
I checked the Math section, but didn't find a function to do this:
http://help.libreoffice.org/Calc/Mathematical_Functions
Is there a way?
Thank you.
--
View this message in context:
Thanks Dries, forgot about that one :-) I checked for negative but it
wasn't used to describe that function.
--
View this message in context:
http://nabble.documentfoundation.org/3-5-3-2-Calc-Turn-negative-number-into-positive-tp3995113p3995119.html
Sent from the Users mailing list archive at
Hello
The C1 column contains percentages, eg. 1,80% while C2 contains rational
numbers, eg. 0,70.
I need to multiple C1 x C2, but Calc displays #NAME?.
What should I do to perform this operation?
Thank you.
--
View this message in context:
Thanks everyone for the help. Turns out the error was due to my using a .
instead of , as decimal separator.
This works for me...
=$C4 * 0,845
... while this doesn't
=$C4 * 0.845.
--
View this message in context:
Hello,
From two tables in the same document, I need to move several rows from one
table to another, preferably through keyboard shortcuts as it's much faster.
Here's what I wanted to do:
1. Select one or more rows, through ALT in case they're contiguous, through
CTRL if they aren't
2. Cut with
Thank you to all of you who answered Charles' question, I asked more or
less the same some weeks ago, got many useful answers (thank you Andreas)
but it was only today that I discovered the F4 button, which works great.
Another query about the same functionality, does anyone know why you end
up,
Hello
I'm working on a long document in Writer, and need to split the screen in
half so I can navigate in different parts of the document.
Someone already asked this in February 2012, and it seems like this feature
was not implemented yet:
http://en.libreofficeforum.org/node/492
Can you
Thanks Miroslaw.
I find it pretty amazing that such common feature still hasn't been
implemented :-/ Even a non-WYSIWYG text editor like UltraEdit supports it.
Simple case I currently have: A table is available twice in the same
document with a few differences. I wanted to split the screen so I
Thanks for the work-around. ALT+TAB to switch back and forth is good enough.
--
View this message in context:
http://nabble.documentfoundation.org/3-5-3-2-Writer-Split-screen-in-half-horizontally-tp3991983p3991992.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe
Hello
I google for this, but didn't find if LO supports a keyboard shortcut for
the Find feature to jump to the next occurence. It doesn't seem to implement
Windows' standard F3 key.
http://help.libreoffice.org/Writer/Shortcut_Keys_for_Writer#Function_Keys_for_LibreOffice_Writer
Thanks but it doesn't work for me:
1. After typing a word in the Find textbox at the bottom of the screen (left
of the up/down arrows) and hitting Enter, Edit doesn't say Repeat Search but
the previous command I ran, even after manually clicking on the down arrow
once
2. I don't have a vertical
I found that LO expects the user to hit ENTER to repeat search, instead of
F3. So customizing isn't necessary.
Also, no biggie, but I notice that assigning F3 to Repeat Search through
Tools Customize is semi-OK: After hitting CTRL+F to open the Find textbox
and typing the data to search for, the
Thanks everyone, it worked. Another application I use simply pastes the new
object on top of the previous one, so I was used to this and expected
LibreOffice to do the same. Copying the original object, unselecting it,
then pasting the new object works.
Considering how often we write use that
Hello
I'd like to know if LibreOffice offers a way to write documents and include
layouts like this:
http://img854.imageshack.us/img854/3010/libreofficeitemsarrows.jpg
Thank you.
--
View this message in context:
Thanks everyone for the help.
--
View this message in context:
http://nabble.documentfoundation.org/3-5-1-2-Calc-XP-Regex-to-find-replace-numbers-tp3954889p3983961.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to:
I have just upgraded LibreOffice to the 3 5 3 2 version and I don't seem to
be able to merge documents anymore, when I choose an ods file to get data
from to insert in the odt document, the OK button is not valid.
Thank you for your help,
G. Siche
--
For unsubscribe instructions e-mail to:
Hello
I need to search and reformat toll-free numbers in a spreadsheet, but I
can't find how to do this in Calc:
(\d\d)(\d\d)(\d\d)
ie. space + six digits in pairs.
In the Find Replace dialog, even with the default Regular expression
option checked and Search in=Values, this triggers Search
Thanks Regina. I couldn't get the first way to work (create second sheet,
click on OK in the dialog: Invalid Sheet Reference), but the second way
worked.
I simply wanted to get rid of all those duplicates as generated by
Microsoft's Process Monitor to figure out which files a process uses.
Thank
Thanks Regina, but after filling the form thusly...
http://img692.imageshack.us/img692/3632/libreofficecalcremovingo.jpg
... nothing happens: Did I do something wrong?
--
View this message in context:
http://nabble.documentfoundation.org/3-5-1-2-Calc-XP-Keep-unique-rows-tp3926479p3929010.html
Hello
I'm going through a log file with a lot of duplicates, eg.
-
ReadFileC:\$Directory
ReadFileC:\$Directory
ReadFileC:\Documents and Settings\Fred\Local Settings\Application
Data\Microsoft\FORMS\FRMCACHE.DAT
ReadFileC:\Documents and
Hello
I need to customize the live ISO by removing applications my users won't
need.
One of them is LibreOffice: How can I remove it entirely, in one go?
dpkg -l libreoffice* returns a lot of stuff, with no obvious main
package that I could remove with apt-get --purge remove:
Thank you.
Thanks Simos. I wasn't getting replies over there, so asked here. I don't
know how to uninstall LibreOffice.
I'll look into ubuntu-defaults-builder to see if that's the right tool to
customize a live ISO that I can reuse to create new bootable USB keydrives.
--
View this message in context:
I just went ahead and ran apt-get --purge remove libreoffice-core.
Incidently, this doesn't remove the LibreOffice icons in the Unity bar.
Thank you.
--
View this message in context:
http://nabble.documentfoundation.org/Ubuntu-11-10-How-to-remove-LibreOffice-tp3848702p3848908.html
Sent from the
Tom wrote
I'm not completely clear about what you are aiming for but this might
neatly avoid a lot of side-issues
http://www.libreoffice.org/download/portable/
Thank everyone. Running apt-get purge libreoffice* did seem to remove the
whole thing, although I had to remove the four icons left
Hello
Using LibreOffice Calc 3.4.4, I created a small spreadsheet that should
print as a single page in Lanscape mode, but Calc insists on printing as two
pages.
Here's what I tried:
1. File Printer Settings chose printer Properties :
Orientation=Landscape OK
2. File Page Preview : Document
carlo.strata wrote
Il 05/02/2012 12:21, Stefan Weigel ha scritto:
You don´t want to change the printer settings. You need to change
the page format: Choose Landscape in Format|Page...
... and also in File - Print Preview - slide the Scale Factor so that
your spreedsheet fit to one single
Hello,
I want to move cell A1 to A2 with the mouse:
I select A1, then press Alt, and move the cell with the mouse: Nothing
happens
I select A1, then press Ctrl, and move the cell with the mouse: A2 is also
selected and nothing happens
Also tried Shift, Ctrl+Shift, Alt+Ctrl, etc.: Doesn't work
Thanks, but it doesn't work. When I select A1, unclick (ie. remove my finger
from the left button on the mouse) then move the mouse to A2, it simply
selects A1 and A2, it doesn't move A1 to A2. I also tried keeping the left
button clicked while I moved to A2, but it also selects the two cells
This thread (from 2007!) explains how to move a single cell
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=886
It clumsy, counter-intuitive, but it works.
Thank you.
--
View this message in context:
Jack wrote
Are you sure you followed the steps I described carefully? When you
select A1 and A2 (before releasing the button), drag the mouse back to A1
and then release the button. Then A1 should be blue. Then you
drag A1 to A2.
Ok, I got it. I find it very counter-intuitive (selecting
For the benefit of others, I received the following instructions out of band:
1. Go to Insert | Object | OLE Object... .
2. Select Create from file.
3. Click Search... and browse to your saved spreadsheet document.
4. Tick Link to file. (That's the important bit.)
Note that you can even edit
At 11:54 06/12/2011, you wrote:
For the benefit of others, I received the following instructions out
of band: 1. Go to Insert | Object | OLE Object... . 2. Select
Create from file. 3. Click Search... and browse to your saved
spreadsheet document. 4. Tick Link to file. (That's the important
Hello,
Google says that CTRL++ on the numeric keypad adds a row, but...
1. It displays the Insert cells dialog
2. It doesn't feel to me as natural as eg. CTRL+Ins or CTRL+Enter
Is there a way to reconfigure LibreOffice's Calc so that I'm spared that
dialog, and ideally, assign a different
(I'll see if Nabble can quote multiple messages in one go...)
Regina Henschel wrote
Yes, use Tools Customize. Goto tab Keyboard. First select the
desired shortcut key. Then select command Insert rows in the category
Insert and then click on Modify.
Thanks Regina for the tip. I assigned
Hello
I built a spreadsheet which I'd like to import into a text document but the
import should be dynamic, ie. any change I make to the spreadsheet should be
available in the text document.
IOW, does LibreOffice support what Microsoft's OLE/COM does?
Thank you.
--
View this message in
I used LibreOffice to save the PDF as TIFF, opened it in PaintShopPro (7),
and removed the section.
But when I re-open the TIFF in LibreOffice so I can save it back to PDF,
it's displayed as a very tiny image (about 1/3 of the original as displayed
in PaintShopPro), even with Zoom=100%.
Does
Tanks for the tip. TIFF seems to be an OK format to export from LibreOffice
and open the file in eg. PaintShop.
--
View this message in context:
http://nabble.documentfoundation.org/3-4-Cutting-section-in-PDF-file-tp3121575p3125900.html
Sent from the Users mailing list archive at Nabble.com.
--
(I first posted through Nabble withouth having subscribed to the
mailing-list, so this might be sent twice)
Hello ,
I need to select and cut a squared-section in a PDF file.
After opening the file in Draw with the PDF format, I'm shown the whole
document as a big image, but I couldn't find if
Thanks guys for the tips. Turns out that after opening the TIFF file in Draw,
I just had to click on the reduced picture and pull the little green boxes
so that it would fill the entire page. No idea why Draw starts with a
reduced picture, but it did the job.
Thank you.
--
View this message in
Hello
I need to select and cut a squared-section in a PDF file.
After opening the file in Draw with the PDF format, I'm shown the whole
document as a big image, but I couldn't find if it's possible to select just
one part of the page and cut a section.
FWIW, the PDF was built with Xerox
101 - 156 of 156 matches
Mail list logo