Well, it was a kick in the teeth to learn that sounds are only linked
instead of being imbedded in the presentation, but at least that'll keep
the size down. My question, though, is whether the links use absolute
or relative paths. I put together a presentation that's for
distribution via
Maybe this option can help:
Menu/Tools/Options/LibreOffice calc/Formula/Detailed calculation
settings/Custom/Treat empty string as zero
--
View this message in context:
http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.html
Sent from the Users mailing list archive
At 22:37 19/08/2013 -0700, Dave Liesse wrote:
Well, it was a kick in the teeth to learn that sounds are only
linked instead of being imbedded in the presentation, but at least
that'll keep the size down. My question, though, is whether the
links use absolute or relative paths.
It's a simple
So the cells are the result of opening a .csv file where the string has
nothing between commas such as
5,4,,,3,,2,1
between the consecutive commas is nothing, so the cell should be made
totally empty.
gs
On 8/19/2013 8:22 PM, Steve Edmonds wrote:
On 2013-08-20 13:02, Virgil Arrington
Hello and thanks for looking at the problem
So my understanding and logic was wrong - again I have learnt a smidgen more
Eventually got what I wanted by using =TEXT(CG4,MMM)
I had thought of using an array but It seemed a big way of solving a small
problem - plus I'd never used one before ??
If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put
the equation =b1*c1 in an empty cell and the result is 0.
Do you not get that. What version of LO.
steve
On 2013-08-20 15:07, greg.a.sm...@oracle.com wrote:
So the cells are the result of opening a .csv file where the string
Hi.
I have excerpt this parragraph from the LibreOffice Impress Guide at
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Impress_Guide:
Impress
only links media files and does not embed a media file into a
presentation. Therefore if a presentation is moved to a
Hello,
I have the following code in a macro:
if chapters.getBoolean(6) then
args4(0).Name = TableName
args4(0).Value = Tabel1
args4(1).Name = Columns
args4(1).Value = 3
Please address any reply to the users@global.libreoffice.org list, not
directly to me. There are many knowledgeable subscribers to this list,
who may be able to provide better answers than myself.
My responses are given in-line with your original message.
Original Message
From:
Hi :)
LibreOffice develops so fast that by the time most other software would be
releasing updates and patches LO is releasing a new version. The next version
in the same branch tends to be just bug-fixes but in the newer branch you get
bug-fixes and new features (although those new features
Hi,
I still can reproduce bug at
https://bugs.freedesktop.org/show_bug.cgi?id=54047#add_comment on
LO 4.2.0.0.alpha0+ Build ID: 784cfa382be438240dfc936b7551c5012aada9ae;
and it bugs me :) Should bug on that link be changed, or new one should
be reported?
Kruno
--
To unsubscribe e-mail to:
Hi :)
If you need to put 0s in between commas then it might be possible without even
opening the file, and might be fairly easy to apply to a shed load of files all
very quickly after each other.
In GnuLinux i suspect something like
cp file-name.csv | grep(?) (replace ,, with ,0,
Hi :)
Yes, a comment would help.
Generally, if the bug has not already been confirmed it might help to add a new
comment saying that you can reproduce the bug. Let them know the version of LO
(4.2.0 alpha?) and the OS (eg Xp, Win7, Ubuntu 12.04, or whatever).
With the early stages of a
Thanks for putting all doubts to rest.
Shifted from MS Office to Open Office in 2010 then a friend of mine
suggested LO said better than OO.
Working on LO now since 2011 - 12. Never faced any problem till date.
Few petty ones (to do with settings) which I could manage through help
minor
https://bugs.freedesktop.org/show_bug.cgi?id=54047
It's affecting 4.0.4.2 too...
On 08/20/2013 02:46 PM, Tom Davies wrote:
Hi :)
Yes, a comment would help.
Generally, if the bug has not already been confirmed it might help to
add a new comment saying that you can reproduce the bug. Let them
I googled for a couple of hours to find this for a similar problem:
'probably this is due to the sometimes asynchroneous nature of the
dispatch calls, try inserting a wait command'
So I changed the start of the code to:
if chapters.getBoolean(6) then
On 08/19/2013 11:05 PM, Ken Springer wrote:
Hi, Vigil,
So, if I read your message correctly, there is no official body that
sets typographic standards, only general conventions used by most, but
may not be the best for end user/reader. Would that be correct?
Not quite.
I agree there
Hi, on Fedora 12, when I try to install LibreOffice
[user@hostname RPMS]$ su -c 'yum install *.rpm'
returns
Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed
So I cannot continue: (cd desktop-integration...).
Could you give suggestion? Thank you, Francesca
--
To unsubscribe
No I don't get zero I get a or #VALUE! error message.
gs
On 08/20/13 04:02, Steve Edmonds wrote:
If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put
the equation =b1*c1 in an empty cell and the result is 0.
Do you not get that. What version of LO.
steve
On 2013-08-20
Sorry, my version is 3.4.5.
On 08/20/13 04:02, Steve Edmonds wrote:
If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put
the equation =b1*c1 in an empty cell and the result is 0.
Do you not get that. What version of LO.
steve
On 2013-08-20 15:07, greg.a.sm...@oracle.com
Hi :)
I have quite a few machines on a really old version too but really should
upgrade soon. I downloaded the 4.0.4 but now might as well do the 4.0.5
instead.
Regards from
Tom :)
From: Gregory Smith - Oracle Sparc Verification
Hi :)
Is it only the desktop integration packages that you are having trouble with?
If so then don't bother with them any more! They have been pulled into the
main installer! :) The devs found a way to combine the 2 different ones that
used to be offered into a single chunk of code so
I mean can not and the substitution of which I spoke is what is made by
the autocorrect feature.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
Hi :)
Err are you using a Mac? If so the menus are very different. It's
LibreOffice - Preferences - blah
instead of
Tools - Options - blah
Hmmm, on Ubuntu 12.04 with LO 4.0.2 I only get the
Tools - Options - LibreOffice Calc
option if i have a spreadsheet open in LibreOffice. A blank
At 01:10 20/08/2013 -0700, Graham Lovatt wrote:
Eventually got what I wanted by using =TEXT(CG4,MMM)
Interestingly, this gives a different result from the formatting
option. The results look the same, but mine was a formatted date
(which will be right-aligned by default) and this is an
Hi :)
WoooHooo!! Congrats on solving this one and thanks for posting the answer back
to the list! That might well help other people in the future or at least make
the answer a bit easier to find.
Thanks, congrats and regards from
Tom :)
From: Alain
Hi :)
Even better if 1 single comment can give a number of different versions where
it doesn't work.
From reading the QA page ages ago i vaguely remember there is something
contra-intuitive about what the devs find most helpful. Intuitively i would
have thought that the first occurrence of
TomThanks for trying to help out.I have attached a screen grab of
my Formula sub-menu that just doesn't have the option you refer
to.I have went through every menu of the options for calc and
found nothing about this!gsOn 08/20/13 10:10, Tom Davies wrote:
Hi :)Err are you using a
Hi :)
I wouldn't say that either is best. It entirely depends on situations and
specific requirements.
Both covers the large middle ground really well but each has it's niche areas
where it's marginally better than the other.
Apache OpenOffice develops more slowly so known bugs stay
Hi,
I'm trying to do a silent install (on Windows) with only Writer and Calc but
I can't find anything to do that.
When I tried to add the command line REMOVE=gm_p_Draw_bin to
msiexec /i c:\LibreOffice_4.0.4_Win_x86.msi ADDLOCAL=ALL
REMOVE=gm_p_Draw_bin /passive
it does not work.
I also tried
Hi :)
The list doesn't accept attachments so i have uploaded the screen-shot to
Nabble
Screenshot.png
http://nabble.documentfoundation.org/file/n4070816/Screenshot.png
So, it's an Xfce Desktop Environment so probably a GnuLinux (rather than
Bsd or Mac) and we know the LO version is 3.4.5.
Hi :)
I don't think it's really possible. If you do manage it then the saving on
drive-space and other resources is almost minimal. LibreOffice is much more
tightly integrated than MS Office and really doesn't work the same way at all.
It's not a collection of different programs but is
Hi :)
Searchreplace (doubt it will work but one never knows). There is an Extension
that adds a lot of functionality tot he default searchreplace (or completely
replaces it i'm not sure).
How about
Tools - Options - Appearance
Does it appear to have the same colour as the new lines in one
Thanks, Joaquin. I did look at the Guide, but it must have been a
different version; the instructions weren't as specific. Or, looking
again at your quote, it might have been in a different section
(principle is the same, but I'm doing a transition, not inserting a
media file -- the section
I always enjoy finding a new feature in LO, one that I never knew
existed. That recently happened to me as was playing with paragraph styles.
One of the features I have always liked about LaTeX is the way in which
the size of its headings fonts is tied to its base font with
designations such
Hi :)
I feel like singing something from Gilbert and Sullivan (prolly mis-seplt
that) and is the very model of an ... or the lumberjacks song from Monty
Python.
Luckily voice doesn't carry very well over text-based communications and also
luckily i can't remember many (or any?) of the
On Tue, Aug 20, 2013 at 03:16:25PM +0100, Tom Davies wrote:
Hi :)
Yes, LO can be installed alongside AOO but not by a straight forwards install
of both.
You need to make sure the QuickStarter is switched off and that they are not
opened at the same time as each other. Various other
Hi :)
The Microsquish thing is Quick Launcher and i think they copied it from KDE.
Could be wrong though.
The Quick Starter puts OpenOffice/LibreOffice open in the system tray (in
Windows). Not completely sure what, if anything, it does in GnuLinux or Mac
Regards from
Tom :)
At 12:10 20/08/2013 -0700, Wyatt Biker wrote:
The Tab key indents single lines only. But when I highlight a few
lines and press Tab I would like it if a tab was added to every
line. Also Shift+Tab should delete the tab.
Whenever you use software, you need to play along with it, not fight
Hi Francesca,
Wow - Fedora 12. Any particular reason for using that version? It is
getting a bit old :)
I gather*yum --nogpgcheck install *.rpm* should work around this. No
personal experience just what linuxquestions.org told me.
As Tom points out, you don't need to hop down to
While there is no ISO or equivalent, there are a lot of
wannabe:
In the US: The real expert (in the US) on this subject
seems to be
the Chicago Manual of Style. It sets forth what Publishers
desire/want/will not accept unless it complies with
regarding submissions.
Brits have The
I just imported and opened a CSV file into calc. When I resize the
window, instead of being able to see more columns, the text displayed in
the cells increases in size and I see exactly the same columns. I've
never seen this happen before. How/why did it happen and how do I make
it keep the font
LO 3.6.7, Slackware 14.0, KDE 4.8.5, Linux k3.2.29.
I have never seen the quickstarter installed. However, in the past, I
have left LO running with many open files when I shut down for the day.
The next time I start up, LO and the left-open files were reloaded as it
was when I shut down.
Greetings.
LO 3.6.6.2, Slackware 14.0, KDE 4.8.5, Linux k3.2.29.
In the past, with KDE3, I was able to leave LO and many files open when
I shut down the desktop for the day. Then when I started up the next
time, LO ran and opened all the files I left open when I shut down.
This was very
On 08/20/2013 06:01 PM, William Wells wrote:
While there is no ISO or equivalent, there are a lot of
wannabe:
In the US: The real expert (in the US) on this subject
seems to be
the Chicago Manual of Style. It sets forth what Publishers
desire/want/will not accept unless it complies with
On Tue, 20 Aug 2013 20:01:57 -0400
Virgil Arrington cuyfa...@hotmail.com wrote:
I think there is a difference between a style for submitting a
manuscript to a publisher and a style for final publication. I
understand many publishers want manuscripts submitted in double
spaced type, which
There are also Increase Indent and Decrease Indent selections
available on the Formatting toolbar.
From the menu, select View, Toolbars, and make sure Formatting is
checked. I don't remember if the Increase Indent and Decrease
Indent icons are visible by default or not. (The pictures are
Hi Nino
Nino Novak nn.l...@kflog.org wrote:
Am 08.08.2013 06:53, schrieb David Love:
I have been asked to design and print numbered tickets for an event
being organised by a Club to which my wife belongs.
How I'd do it (it's from memory, so bear with me for little glitches):
Thank you
48 matches
Mail list logo