Copy the cells and paste as "unformatted text"
(use the icon for pasting and select "unformatted text")
:)
Dne 29.10.2011 1:28, Stefan Weigel napsal(a):
Hi Tom,
Am 29.10.2011 01:21, schrieb Tom Davies:
Tools - Options - "LibreOffice Calc" - View
and then UNtick the "Formulas" tick box in
On 28/10/2011, Pete Holsberg wrote:
> Hi,
>
> I created a file with the Android app "Office Suite Pro" and I cannot
> open it with Libre Writer.
>
Does this program 'office suite pro' produce odt files?
If the answer is yes, this is the correct mailing list to report
errors with the _native_ odf
On 28/10/2011, ESChamp wrote:
> I created a docx file with Android Office Suite Pro, and while MS Office
> 2010 can open it, LO cannot.
>
> Ideas?
>
The best idea is to create an odt document and tell us if there any errors.
If you want to create m$ formats, contact office suite pro and/or m$.
Hi,
Am 29.10.2011 02:05, schrieb Uwe Koch Kronberg:
> Stefan means to select the area, copy it, go to another cell, choose
> edit from the menu, click on paste special and inside the menu box it
> opens unclick paste all, then unclick all the options below (text, date
> and hour, formulae, commen
Hi Rich,
Am 29.10.2011 01:50, schrieb Rich Shepard:
> I'm not following you. Are you writing that I can highlight two
> adjacent
> cells and have their sum pasted in the same row in a third column?
No. Follow this:
(1) Select the cell that contains the formula
(2) Choose Edit | Copy
(3) Cho
Hi.
I am trying to find (search for) some text in some sheets.
The text appears in many formulae and also as text in cells.
I wish to exclude the formulae from the search.
In Find & Replace > More options > Search in I am able to select
"Values" but the search still finds the text in formulae.
A
On 24/10/2011, mikko wrote:
> Hello,
>
> I wonder if I am missing something & if anyone else has this same problem: I
> can embed videos in Impress but I have no control on how they start (simple
> start on click would be fine), appear, leave or repeat. All the effects work
> fine for images but i
Le 29/10/2011 02:20, Brian Barker a écrit :
Brian,
I'm always puzzled by this sort of claim. The subjects of this personal
information presumably expect that it will remain confidential: that is,
not be distributed beyond the audience they anticipated when they
provided the information. If it g
Hi :)
I still think that Doc as opposed to DocX is the only format that all 3
programs can read/write the same. Just open the existing DocX in either
Android or MS and then
File (or golden orb) - "Save As ... "
and choose something like "older Word 97/2000/Xp"
I would experiment with Odt as
Hi :)
When i want to print a web-page to file rather than to a printer i get the
choice of exporting/printing.saving as .Pdf or .Ps. The .Ps is the default.
I'm on Ubuntu 10.04 (or 10.10 depending on which machine).
Regards from
Tom :)
--- On Sat, 29/10/11, Thomas Knierim wrote:
> From: Thom
Thanks Alex
Sorry about the 'New Thread' thing - on another Forum I'm on I only have
to change the Subject Line - Now I know!! (Thanks for explaining it to me!!)
A few further questions :
- does the form contain any image fields ?
- does the form contain any boolean fields ?
- is the form bas
Le 29/10/2011 01:00, The Wolfkin a écrit :
Hi,
I tried using the Getting Started PDF(2) but while that did help me in
creating dropdown menus. I haven't been able to populate it and in their
example it was populated with items from another table. I'm only working
with one table here. I also don
Hi :)
I tried writing in Writer, got individual words to have different background
colours and copy&pasted the words into a text in Impress but all the
backgrounds disappeared. LO 3.3.2 still.
In Writer i inserted a frame and wrote in that adding different backgrounds to
different words. Wh
Le 29/10/2011 00:44, David S. Crampton a écrit :
Hi David,
This question has two parts: simple and more complex:
simple: I wish to read the value of the currently selected cell (in
Calc, of course) into a variable in the macro language (Libre Basic).
Script example please. and thank you!
I
Hi :)
Tech support often has to deal with confidential information. I would trust
Alex to not spread the info further and also to not take advantage and misuse
the info. There are other people here that i would also trust in this way even
if i disagree with them on other issues.
There is of
Hi :)
Ok, errr, forwarding the email back to the list seems to break it out and form
a new thread so i have just done that with this post. The slightly messed-up
thread is "Dictionary in LO 3.4.3 "
http://nabble.documentfoundation.org/Dictionary-in-LO-3-4-3-td3434286.html
I think we have fixed
Hello Vladimir,
v...@ukr.net schrieb:
Hello!
On Fri, 28 Oct 2011 18:26:22 +0100 (BST)
Tom Davies wrote:
Hi :)
Once you have selected the words can you right-click and see what
options you have in there for formatting text? I haven't tried it
but often when programs don't let you access t
On Sat, 29 Oct 2011, Stefan Weigel wrote:
The trick is to copy and then paste special (Edit menu). In the dialog
check only numbers.
Stefan,
Thank you very much.
Rich
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help
Am 29.10.2011 um 13:13 schrieb Tom Davies:
> Hi :)
> When i want to print a web-page to file rather than to a printer i get the
> choice of exporting/printing.saving as .Pdf or .Ps. The .Ps is the default.
> I'm on Ubuntu 10.04 (or 10.10 depending on which machine).
> Regards from
> Tom :)
>
On Fri, 28 Oct 2011, The Wolfkin wrote:
So if I'm understanding you're trying to say start out with cells..
input a formula like this
http://minus.com/lgIwyrkPUPHj7
which gives a solution like this
http://minus.com/l50sfqIxwhBlz
and then now change the contents of cell D5 from {=B5+C5} to {80}
OK, that's some kind of confusing: Using Ubuntu everything works out of the
box! Where is the difference to other distributions?
The Versions are nearly the same:
Cups:
- OpenSuse: 1.5
- Archlinux: 1.5
- ubuntu: 1.5
Ghostscript
- Opensuse: 9.00
- Archlinux: 9.04
- ubuntu: 9.04
hplip
- Opensuse:
Hi :)
So you want a static value instead of a formula? If any of the values that the
formula is based on were to change then the value in the cell would not change.
eg if
A1= 10
B1= 20
and
C1= A1+B1
then the spreadsheet would display C1= 200 but you would still be able to see
the formula in th
Hi :)
In your existing Arch could you just install a virtual machine and try out a
few things in there? Alternatively create a new partition on a hard-drive and
use that for experimentation.
You surely don't need to trash what you do have that is almost perfect in order
to just try something a
The two pages per sheet issue. You want to have them printed side by
side? Or one page on one side and the second page on the other side of
the sheet? Side by side printed out on a landscape orientation works
well, but it is a printer option. Having the pages printed one on each
side of th
On 10/29/2011 02:38 AM, Thomas Knierim wrote:
Offtopic - anyway: I'm often trying different distros (just for fun and) to see
how they develop. Every distro has it's own pros and cons. (I haven't found a
perfect distro for me). I'm going to check ubuntu again (last time was a year
ago). But ub
At 15:43 29/10/2011 +0100, Tom Davies wrote:
A1= 10
B1= 20
and
C1= A1+B1
then the spreadsheet would display C1= 200 ...
Is this perhaps what's known as the "new math"?
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.o
Readers,
An a4 page is formatted to landscape with two columns (in effect
creating a5 columns).
When creating a frame, how to specify using the dialogue window that
the frame should appear in the centre (with respect to vertical and
horizontal) of a column, not to a page or paragraph?
Thanks.
-
It makes perfect sense that OOo and LO could be installed side by side and also
run at the same time.
The problem is that they all lay claim to the same program names, library
names, and probably registry settings.
(The use of the same program names is why Windows, for example, can't have O
Hi Pete,
When LO/OOo pops up a text filter it is usually because the format of the
incoming file is not recognizable, no matter how it happens to be named
(.docx, etc.).
This happens if an incoming .docx file is encrypted, for example.
If you send the file to me, I can look at its innards to s
Tom Davies has written on 10/28/2011 8:30 PM:
> Hi :)
> Ahh, i am not sure. Tbh i was hoping that there might be something
> immediately obvious and easy to fix or that it would stuggle to open and
> fixing that would fix the problem.
I don't know enough about the internals.
> LibreOffice 3.
e-letter has written on 10/29/2011 5:21 AM:
> On 28/10/2011, ESChamp wrote:
> > I created a docx file with Android Office Suite Pro, and while MS Office
> > 2010 can open it, LO cannot.
> >
> > Ideas?
> >
>
> The best idea is to create an odt document and tell us if there any errors.
"No applicat
Thanks, Tom, but that's not the point. I created a DOCX file on my phone
and could not open it with LO 3.4.3. I can open it with MS Word 2010.
Not looking for a work-around but I will take the advice of using DOC
instead.
Tom Davies has written on 10/29/2011 7:08 AM:
> Hi :)
> I still think that
e-letter has written on 10/29/2011 5:08 AM:
> On 28/10/2011, Pete Holsberg wrote:
> > Hi,
> >
> > I created a file with the Android app "Office Suite Pro" and I cannot
> > open it with Libre Writer.
> >
>
> Does this program 'office suite pro' produce odt files?
NO.
> If the answer is yes, this
Hi
I used LO 3.4.2 (Ubuntu 10.04 LTS) and it runs good.
Regards,
Jorge Rodríguez
___
El sáb, 29-10-2011 a las 22:55 +1300, Steve Edmonds escribió:
> Hi.
> I am trying to find (search for) some text in some sheets.
> The text appears in many formulae and also as text in cell
Or, you can open it (an .ods) in Microsoft Office 2007/2010, and save it back.
That will leave the values and strip the formulas from the cells [;<). It
might work to save as .xslx and then reopen it in LO too, but I haven't tried
that case.
-Original Message-
From: Stefan Weigel [mail
As said in my original post, none of the controls work (under any operating
system [Linux, OSX, Win7] & I also tried different versions of LibreOffice
with no luck). In other words, the options 'start media', 'end media' etc.
and adjusting timing have no effect. They work ok for simple jpegs and o
On Sat, Oct 29, 2011 at 8:37 AM, Alex Thurgood wrote:
> As for your dropdown list :
> Enter Form Edit mode.
> Select your control (possibly having to "Enter Group" first)
> Right-mouse button click on the control and choose "Replace with"
> Choose Combobox
> Now right-mouse button click on your co
That was actually more of a restatement of your problem then an attempt at a
solution. But the previous supplied answer of "Paste Special" with only
"Numbers" checked did work. If you do that you can delete B5 and C5 and keep
the 80.
if you're still having trouble perhaps a screenshot would help a
Hi :)
Ahh, cool. In that case perhaps filing a bug-report would be good even tho i
haven't been any help in getting it down to a specific issue.
http://wiki.documentfoundation.org/BugReport
Regards from
Tom :)
--- On Sat, 29/10/11, ESChamp wrote:
> From: ESChamp
> Subject: Re: [libreoffice-u
On 10/24/2011 08:00 PM, windyweather wrote:
> http://www.windyweather.net/wp/2011/10/24/false-positive-in-libreoffice-3-4-3-from-mse/
>
> Details of false positive [I assume] virus detection by up to date Microsoft
> Security Essentials.
> Win 86 install of 3.4.3 on Windows 7.
> Not sure if you w
At 18:17 29/10/2011 +0100, Nobody Noname wrote:
An a4 page is formatted to landscape with two columns (in effect
creating a5 columns). When creating a frame, how to specify using
the dialogue window that the frame should appear in the centre (with
respect to vertical and horizontal) of a column
On 10/29/2011 1:17 PM, e-letter wrote:
Readers,
An a4 page is formatted to landscape with two columns (in effect
creating a5 columns).
When creating a frame, how to specify using the dialogue window that
the frame should appear in the centre (with respect to vertical and
horizontal) of a colum
Hi. Does this mean that if you fill a bit of a column with
=IF(E615="PMT TO Lex",G615,0)
Then you can Find (search) for "Lex" so that you do not find it in the
formulae.
steve
On 30/10/11 7:37 AM, jorge wrote:
Hi
I used LO 3.4.2 (Ubuntu 10.04 LTS) and it runs good.
Regards,
Jorge R
On 10/26/2011 08:32 AM, webmaster for Kracked Press Productions wrote:
...
> Actually, it may be that your printer might not work with all its
> options withing LO. My Epson has a duplex feature, but LO seems not to
> be able to set that feature's control to turn it on.
...
Printer Properties:
Hi,
e-letter wrote (29-10-11 19:17)
An a4 page is formatted to landscape with two columns (in effect
creating a5 columns).
When creating a frame, how to specify using the dialogue window that
the frame should appear in the centre (with respect to vertical and
horizontal) of a column, not to a
Hi :)
Hmm, interesting. On a desktop OS you can usually right-click on a file, go
down to properties and use that to change which program opens that type of
file. Hopefully Android OfficeSuite would be in the list. I don't know if
Android allows you to configure things in a similar way.
Reg
Cor Nouws wrote (29-10-11 22:01)
If I understand your question correct, I would say tab Type, position
[..]
(hmm, that's the disadvantage of working though 178 mails - by the time
I reply on some of the lasts, others have already done too ;-) )
--
- Cor
- http://nl.libreoffice.org
--
F
First, rough-screening test results:
The newtext.docx file that was produced with the Mobi Office Suite works as
follows:
LO 3.3.2 fails to open it, reporting a general input-output error.
Word 2010 opens it just fine.
I modified the document in Word 2010 by adding a sentence to it and savin
I may have confused you.
I've opened OfficeSuite (technically it's MobiSystems OfficeSuite Pro on
an Android phone) and I see a list of files. I select the ODT one. I get
the error message below.
If I use a file manager, I select the ODT file and get "File type ODT
not found".
Tom Davies has wri
Hi :)
I am easily confused so don't worry. Yes, it's pretty clear that MobiSystems
OfficeSuite Pro doesn't support Odt yet. At a guess they might add support
later but it's not likely to be soon.
Regards from
Tom :)
--- On Sat, 29/10/11, ESChamp wrote:
> From: ESChamp
> Subject: Re: [libre
Hi :)
There is a guide to help avoid the usual conflicts
http://wiki.documentfoundation.org/Installing_in_parallel
I think the problems are mostly when both version are open at the same time,
for example if one is permanently kinda open by having it's QuickLauncher on.
Regards from
Tom :)
---
Hi :)
Ooops. Yep i made a few mistakes there. Using x as multiplication confuses
some people and * confuses others so i went back to make it a simple addition
but really was not concentrating at all lol. Hopefully it gets the point
across tho.
Many apols for the blunders and regards from
To
Hi,
Tom Davies schrieb:
Hi :) There is a guide to help avoid the usual conflicts
http://wiki.documentfoundation.org/Installing_in_parallel
I think the problems are mostly when both version are open at the
same time, for example if one is permanently kinda open by having
it's QuickLauncher on. R
> Here is where I think we're getting mixed up. The contents of the combobox.
> I want the contents of the ComboBox to be "Singstar 80s", "Singstar 90s",
> "Singstar Amped" that's it. I don't want to fill it is the contents of
> another table or field. I just want to enter in a choices literally. T
Tom Davies has written on 10/29/2011 4:41 PM:
> Hi :)
> I am easily confused so don't worry. Yes, it's pretty clear that MobiSystems
> OfficeSuite Pro doesn't support Odt yet. At a guess they might add support
> later but it's not likely to be soon.
>
Do you know something I don't about Mobi?
Enter "X" in B1, then enter following formula in A1 then copy formula to A2
=if(b1="X","AAA","BBB"), it copies the value "AAA" and not the formula
=if(b2="X","AAA","BBB").
LibreOffice 3.4.3 OOO340m1 (Build:302).
Steve
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Le 29/10/2011 20:23, The Wolfkin a écrit :
Hi,
I want the contents of the ComboBox to be "Singstar 80s", "Singstar 90s",
"Singstar Amped" that's it. I don't want to fill it is the contents of
another table or field. I just want to enter in a choices literally. This is
the problem I'm having. Ve
Writer Thesaurus
Just up graded to 11.04 and seem the thesauruses is grayed out. Any one
know who to activated/ turn on this feature?
--
View this message in context:
http://nabble.documentfoundation.org/Writer-Thesaurus-tp3464533p3464533.html
Sent from the Users mailing list archive at Nabble
Perfect. That's exactly what I was looking for. Thanks Alex.
--
I love gmail. Do you?
The Wolfkin
On Sat, Oct 29, 2011 at 6:48 PM, Alex Thurgood wrote:
> Le 29/10/2011 20:23, The Wolfkin a écrit :
>
> Hi,
>
> OK, I hear you. Replace the Combobox by a list box.
> In the properties of the contro
On 29/10/2011 at 23:39, pattyboy123 wrote:
> Just up graded to 11.04 and seem the thesauruses is grayed out. Any one
> know who to activated/ turn on this feature?
Do you have mythes-* (e.g. mythes-en-us) package installed? You can install it
using your package manager (I believe that in Ubun
Hi
I suggest you to do like this:
1) Copy A1
2) Paste Special (Un check Paste All -first line-, text- second line-
and Numbers-third line-)
3) Paste (Ok) in A2
Regards,
El sáb, 29-10-2011 a las 22:34 +0100, Steve Fisher escribió:
> Enter "X" in B1, then enter fo
Tools>>Options>>General>>Click box at bottom of window that says
"Enable experimental (unstable) features
Jerry
At 02:39 PM 10/29/2011, you wrote:
Writer Thesaurus
Just up graded to 11.04 and seem the thesauruses is grayed out. Any one
know who to activated/ turn on this feature?
--
View th
On 10/29/2011 02:17 PM, Regina Henschel wrote:
> Hi,
>
> Tom Davies schrieb:
>> Hi :) There is a guide to help avoid the usual conflicts
>> http://wiki.documentfoundation.org/Installing_in_parallel
>>
>> I think the problems are mostly when both version are open at the
>> same time, for example if
No matter how I try to set the options, I cannot get my Epson Artisan to
print duplex withing LO. It just does not want to do it. Right now I
am having head clogging issues which may be a hardware malfunction, so
solving the duplex printing issues is the least of my worries. I may
have to
Thesaurus is grayed out where? In LO? or the external one?
Artha is a good external Thesaurus and Dictionary that I am running on
Ubuntu 10.04.
Install this dictionary/hyphen/thesaurus .oxt file.
http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/English_dict__with_
I do not have that option checked and I have the Thesaurus running.
On 10/29/2011 07:11 PM, Libre User wrote:
Tools>>Options>>General>>Click box at bottom of window that says
"Enable experimental (unstable) features
Jerry
At 02:39 PM 10/29/2011, you wrote:
Writer Thesaurus
Just up graded t
Hi :)
I think it's going to be easier to do something quite radical AFTER code
clean-up is almost done. Surely it's got to be done to the entire code-base
all at once and all the libraries and all have to be changed at the same time?
I don't think it's a trivial thing to fix.
Regards from
Tom
67 matches
Mail list logo