![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
I didn't realize that this was a specific printer issue. Sorry. I've moved
to the higher end Epson printers, such as the Work-Force WP-4530 after
reliability issues with last few HP's I had. Other than for 1 minor
scanning issue, they have worked great with Ubuntu, and have worked great
printing! There are updated drivers now, but haven't taken the time to play
with them.
Don
In Calc I would like to insert an image in a cell depending on the conditions set in another cell.
Example: A2=IF(A1=1;insert image.jpg;"") (If A1=1 insert an image in A2 else insert nothing).
Is it possible?
If Yes, how to do it?
Kolbjoern
Tim and Frank,
As an answer to your kind responding:
In fact I had made a live-DVD to check my PC's (64bit) co-operation with Ubuntu14.04.1.
My intention is to first install Ubuntu on a VirtualBox because errors are then easier to correct and
after that perhaps do a dual-boot install (I am an expert on making errors).
And got some real 'challenges': my system is 64bit/8GB RAM/2 TB HD (virtualization enabled) but the
Ubuntu(64bit) did not accept to install (memory instruction error???) so I re-installed VM&Ubuntu as 32bit.
The install is now OK but the Ubuntu is very very sloooow.
My printer does not work either.
I know -- this not a LO-issue, so I must try to get help from Ubuntu-forum.
Best regards
Pertti Rönnberg
Sorry to interrupt, but I've no idea how this forum or whatever it is works
& similarly, I've no idea how to utilise i.e. actually set up LibreOffice
albeit that I've sent the following yesterday
please I really do need your basic help e.g.
having downloaded OfficeLibre yesterday (sunday)
I'm afraid I'm unable to make it work i.e.
on this Toshiba Laptop
via it's Windows 8.1 OS
e.g. there seems to be no installation wizard
nor a suitable app
& anyway I just got a message to say
I could not install it* on this computer
* that's the app/icon, or do they mean the
the whole OfficeLibre?!
Perhaps I'm doing something wrong
but I've already wasted several hours
& have bought an icon, as confirmed
by Microsoft in an email (I can't reply to)
Hope someone there can help please
Philip Jordan of Dorchester, Dorset UK
Don
The only Epson printing issues, and scanning issues that I had with an Artisan 810 was fixed when 12.xx came out. I needed the printing to DVD media that Epson's Artisan 810 has.
The printer "died" when the "ink pad end of life" error message caused the printer to stop working. It cost more to fix than buy a new printer. That is when I went to a Canon MG6220. I have Canon printers now, including a fax printer. All three have printing onto DVD media. For HP printers, I use the Ink tank versions, instead the all-in-one cartridges. Works better for getting third-party ink. The third-party ink "tank" cartridges cost me between a third to less than a fifth the cost of OEM prices. Cannot afford to do the printing I do if I had to buy OEM ink.
Linux printer drivers and LibreOffice can be a hit or miss for issues. It was the same when I used OpenOffice.org. Most of the issues are fixed, but with all of the models of printers and all of the various drivers created by people/companies to give print drivers to Linux, well they cannot get all of the printer models working properly. The good part is when you find the printer makers support Linux drivers online for your use. HP does. Canon [not in the USA] does for some model lines.
So, when I buy a printer, I first check out if I can find Linux [.deb] drivers and third-party ink. If I can, then I can use the printer in my home office. I really do not want to "push" a document, photo, graphics, etc., to a Windows system for printing.
My responses are given in-line with your original message.
Hi 
The LibreOffice download page does ask for donations but you can
ignore that and just get the download.
It is a huge help and very much appreciated when people do donate. It
costs a lot to keep the servers running and administer all the
infrastructure and annual accountancy fees, legal costs and all the
rest that registered companies/charities have to pay for. There are
many ways of donating. Many people on this mailing list donate vast
amounts of their time to helping in the community.
There are 2 downloads on the page. After the largest one has
downloaded double-click on it and it should install. Windows 8 might
display a pop-up dialogue-box asking you to confirm that you really
want to install this non-Microsoft program. Sometimes it hides that
dialogue-box under all the other windows that you have open on your
screen. You can minimise them or hunt along the taskbar at the bottom
of the screen to find the dialogue-box either way.
Similarly with the tiny download.
If you install the tiny download before the larger one then just
double-click on the smaller one again to reinstall it. Somewhere in
the smaller one's title/name is the word "help" or "help pack". It is
just the help-files for when you click on the blue question-mark
inside LibreOffice. So you don't HAVE to install it but it's usually
quite useful.
It helps if you do the downloading on the machine that you want to
install onto. However in your case you can just use any Windows
machine to do the download. The LibreOffice website cleverly detects
which Operating System you are using and gives you the appropriate
download for that machine. Afaik there are 3 different versions; 1
for all different versions of Windows, 1 for Gnu&Linux&Bsd&Mac, and 1
for Android.
Regards from
Tom
*Many thanks Dave, I'll similarly answer below*
My responses are given in-line with your original message.
From: Philip Jordan <jorphilip@gmail.com>
To: users@global.libreoffice.org
Date: Tue, 27 Jan 2015 13:51:18 +0000> Sorry to interrupt, but I've no idea how this forum or whatever it is
worksThis is a user support mailing list for LibreOffice.
For a definition of what an electronic mailing lists is see:
https://en.wikipedia.org/wiki/Electronic_mailing_list
*Thanks & **Noted*
> & similarly, I've no idea how to utilise i.e. actually set up LibreOffice
> albeit that I've sent the following yesterdayWe are all volunteers located in numerous time zones around the world.
Which means that it can take a little time for your fellow users to see
your request and reply if they think they can possibly assist.
*Much appreciated *
> please I really do need your basic help e.g.
>
> having downloaded OfficeLibre yesterday (sunday)The software is called LibreOffice (Libre = freedom), not OfficeLibre
and you should only download from the official website:
https://www.libreoffice.org/download/
*Yes that's where I got it from (must have got the order of title words
from elsewhere) *
> I'm afraid I'm unable to make it work i.e.
>
> on this Toshiba Laptop
> via it's Windows 8.1 OS
>
> e.g. there seems to be no installation wizard
> nor a suitable app
> & anyway I just got a message to say
> I could not install it* on this computer
>
> * that's the app/icon, or do they mean the
> the whole OfficeLibre?!Unfortunately, people are being indoctrinated into this "App" nonsense.
You download the installation file from the above link and install the
software as per the instructions shown here:
https://www.libreoffice.org/get-help/install-howto/windows/
*Well that's what I did already & have now repeated*
*BUT*
*There's still no installation wizard*
*& I keep being told by windows to go to the app store*
*&/or there's no connectivity with app I've bought that's on my task bar*
*&/or I am back on another LibreOffice website being told to download*
*when I've already done this*
Once you have installed the software it will appear in your list of
available programs (What MS calls your Apps).
Well I can't *Well I still can't*
> Perhaps I'm doing something wrong
> but I've already wasted several hours
> & have bought an icon, as confirmed
> by Microsoft in an email (I can't reply to)This does not make sense. You should _NOT_ buy anything from anyone,
including Microsoft, in order to use LibreOffice.> Hope someone there can help please
>
> Philip Jordan of Dorchester, Dorset UKYou also will find it very helpful to read the "Getting Started" and
"User" guides, available from:
http://www.libreoffice.org/get-help/documentation/
*Thanks I'm just downloading the 4.2 one - all 13,238K of it*
*& will try to see if although it's 4.2 that it can help me?!*
Phillip Jordan should be plenty embarrassed when/if he figures out what he is doing that he is not telling us.
He says he is "downloading all 13,238k" of LibreOffice 4.2.
My download of 4.2.8.2 last night was of 215,400 kb, plus 5432 kb for the helppack, so of course nothing will work for him.
We still have no explanation of what he thinks he may need to buy in order to install LO.
He finds no "installation wizard", so let's try saying this a different way:
After downloading the right file from the right site, you should find a file named: libreoffice_4.2.8_win_x86.msi in whatever subdirectory your downloads go to. If you opted for the helppack, then you should find a 2nd file: libreoffice_4.2.8_win_x86_helppack_en-us.msi there also. Search for them if you've lost track of where they've been stashed.
If they are not at least close to the sizes given, something has already gone awry.
These .msi files are executable; one must needs only double-click (in a /Curtains/ system) on one or the other (the big one first, usually) to start them running. The resulting screen messages should guide one the rest of the way.
If you are expecting some magic/just because/ you downloaded the programme, it won't happen. You have to initiate the execution of the .msi file.
Whilst we're on the topic, I'd be interested if anyone has a suggestion pertinent to my particular difficulty: I have to run LO Portable from a USB stick, because the regular programme refuses to install on this /Curtains 7/ machine, reporting: "Error 1325 fingerprint is not a valid short filename", and not giving any information as to how one might resolve whatever problem LO is having. This has persisted through many versions, for about 2 years now, and so is not some transient phenomenon.
There are no "fingerprint" file names, short or long, on the system, but there are two empty subdirectories, associated with OpenOffice, that have that name.
There has been a lot of happy talk on this list lately about running multiple versions of LO in parallel, which is just what one wants to do in order to act as a useful tester. Perhaps that notion applies to mac and linux systems only. Whatever the case, attempting to set up such a parallel system on /Curtains 7/, loading the second version onto a USB stick (which I naively thought would provide adequate isolation), was the cause of my LO downfall, from which I have never recovered.
trj
marianne-x wrote:
Phillip Jordan should be plenty embarrassed when/if he figures out what
he is doing that he is not telling us.He says he is "downloading all 13,238k" of LibreOffice 4.2.
My download of 4.2.8.2 last night was of 215,400 kb, plus 5432 kb for
the helppack, so of course nothing will work for him.
Perhaps his download failed and was cut short - in which case he could try downloading again (from libreoffice.org).
We still have no explanation of what he thinks he may need to buy in
order to install LO.He finds no "installation wizard", so let's try saying this a different
way:After downloading the right file from the right site, you should find a
file named: libreoffice_4.2.8_win_x86.msi in whatever subdirectory your
downloads go to. If you opted for the helppack, then you should find a
2nd file: libreoffice_4.2.8_win_x86_helppack_en-us.msi there also.
Search for them if you've lost track of where they've been stashed.If they are not at least close to the sizes given, something has already
gone awry.These .msi files are executable; one must needs only double-click (in a
/Curtains/ system) on one or the other (the big one first, usually) to
start them running. The resulting screen messages should guide one the
rest of the way.If you are expecting some magic/just because/ you downloaded the
programme, it won't happen. You have to initiate the execution of the
.msi file.Whilst we're on the topic, I'd be interested if anyone has a suggestion
pertinent to my particular difficulty: I have to run LO Portable from a
USB stick, because the regular programme refuses to install on this
/Curtains 7/ machine, reporting: "Error 1325 fingerprint is not a valid
short filename", and not giving any information as to how one might
resolve whatever problem LO is having. This has persisted through many
versions, for about 2 years now, and so is not some transient phenomenon.There are no "fingerprint" file names, short or long, on the system, but
there are two empty subdirectories, associated with OpenOffice, that
have that name.
I assume by "Curtains 7" you mean "Windows 7" (perhaps a literal translation?) I've never come across that "fingerprint" problem on Windows Vista. What are the exact paths to those subdirectories ?(i.e. everything from C:\... up to \fingerprint\) As you say they're empty, have you tried simply deleting them? If you do, does that solve the problem, or do they come back again?
There has been a lot of happy talk on this list lately about running
multiple versions of LO in parallel, which is just what one wants to do
in order to act as a useful tester. Perhaps that notion applies to mac
and linux systems only. Whatever the case, attempting to set up such a
parallel system on /Curtains 7/, loading the second version onto a USB
stick (which I naively thought would provide adequate isolation), was
the cause of my LO downfall, from which I have never recovered.
Instructions for setting up a parallel install on Windows are at https://wiki.documentfoundation.org/Installing_in_parallel/Windows - basically you can either use a tool to manage the installs, or specify additional options on the command line when starting the installer. You may also want to keep the user configuration ("profile") folders separate for different versions.
Just installing the normal versions to a USB stick might not give the isolation you need, as they'd all use the same user configuration folder under your Windows profile's folder. You mentioned the portable version earlier, and installing a different version of that to a USB stick should be OK, as it keeps the configuration in the application folder.
If you're only ever using the portable version on one PC, and don't actually take the USB stick to different PCs to use LibreOffice, you could install LibreOffice Portable onto the hard disk of that PC. Provided each portable version is installed to a different folder, they should still be isolated. I don't know if you can have two different versions running at the same time; you might have to exit one before starting another, but having several portable versions installed and switching between them shouldn't be a problem.
trj
Mark.
Den 28.01.2015 13:14, Tom Davies skreiv:
Hi
I think other people have had a lot of trouble with this sort of
thing. I think trying to contain an image into a specific cell is
difficult and i am not sure if it can even be done at all.It might be that you need to use Base or html pages to do something like this.
Regards from
Tom
Thank you, Tom.
I am translating LibreOffice Calc and was only curious whether this is possible in Calc (and other spreadsheets) or not.
Sometimes it is useful to know what is impossible :-).
I have not tried a workaround for this problem, but usually there is one, as you suggests.
Kolbjoern
Hi
I think other people have had a lot of trouble with this sort of
thing. I think trying to contain an image into a specific cell is
difficult and i am not sure if it can even be done at all.
It might be that you need to use Base or html pages to do something like this.
Regards from
Tom