I tried to create a report from a table which contains text and image fields. The created report show text fields well but only empty fields as Images. How can I do that?
View 1 RepliesI'm using debian wheezy and i managed to install libreoffice 4.3.3.2 from debian wheezy backports.
The LO program works fine, except that i can't use reports in LO Base. When I'm trying to use a report file that already exists in a base file, i'm getting the message "loading component library <file:///usr/lib/libreoffice/program/librptlo.so> failed.
What should i do to make reports work;
Everywhere I read, this seems to come up as a very difficult thing. Just want to record how I did it.
In Access, export the table to an Excel Spreadsheet. Using Openoffice, open the Spreadsheet, but save as an Openoffice (.ods) spreadsheet. ( Note - According to the Base help files, if you import an Excel Spreadsheet, it is read-only)
Open Base and Create a database. No tables, no nothing, just create. Now Open this and and also Open the spreadsheet. Select all the data in the spreadsheet, 'copy' it, and in the Database tables area, 'paste' it. I had problems in that it wanted to create a primary key, so added an extra field.
I then went into the database design view, right click on the appropriate field to make that the primary key, and remove the primary key from the unwanted field.
Delete the excess column. This is just for a single flat table, with no linking to other tables. I hope that this helps someone. I did it for a membership database table, and have been able to replicate the query to filter for the Snailmail folks (Those that did not have an email address in the table). Still trying to figure out how to do an envelopes report though.
I am currently learning an African language. As I have been learning it, I have put together a dictionary, which I made as an openoffice database, so I could search and edit as necessary. Unfortunately, it now has several thousand entries and grinds to a complete halt if I try and search it. For now I have exported the data into a pdf which means I can look words up, but it doesn'tan alternative programme which would cope better with this much data and be easy to set up? Ideally one I can export my current data into.
View 1 Replies View RelatedI have upgrade my Fedora to 12, i was trying to use the Openoffice database and can not find it loaded under application>office. Does anybody know why it is not loaded? I try to activate it via yumex, after installation, it comes up with bug errror report and Selinux error also comes up when try to use the BASE.
View 1 Replies View RelatedEvery couple of hours OOo Base crashes - just closes the program of its' own accord.
Annoying enough in itself, but at least it usually recovers up to the last point I saved my work. The last time it happened though it didn't even recover to my last save point - it recovered to an old save point! So I have lost 30 minutes' work.
I have set up an OpenOffice (3.2) Base database - tables, mainly, and a few queries. The main table contains about 9000 rows and around 50 fields and there is a second table of 1900 rows and 20 fields and a few other tables with either fewer rows or many fewer fields. The primary key on the main table is a single text field. The .odb file is 4.4Mb. There are no Forms or Reports; the idea at the moment is that I enter data using OO's Table data view. I see that I have an embedded HSQL database and I cannot change dit>Database>Properties because it is greyed out.
Opening the database is reasonably quick (about 5 sec) but then when I want to look at any but the smallest of tables (in data Table view) it is very slow (15 sec on the main table) to display the first group of rows. When I want to move to show a different record it takes just as long to display the new set of rows. It makes no difference whether the new set of records is adjacent (in terms of record order) or a long way off. I need to speed this up x3 or more or I will have to abandon Base as impractical to use.
On the OO Forum some posts talk of separating the database from the engine and others of increasing the cache size. I can't do the latter as access is via the greyed out option and I can't find any instructions for the former. I'm not convinced these would have much effect anyway.
I am trying to start OpenOffice Base (3.2.0) but it keeps crashing once I begin to edit a new data base. Calc, Writer and Impress work fine.
ramack@ramack2:~$ soffice -base
ramack@ramack2:~$ libgcj failure: gcj linkage error.
Incorrect library ABI version detected. Aborting.
I haven't a clue as to how to fix this one. A web search finds a Debian bug that a couple years+ old. The bug has since been resolved. It crashes if run as root too
I have installed openoffice.org-base and openoffice.org-base-core in an updated fedora 14 environment. Clicking on openoffice-base in applications->office->openoffice-Base fails to lauch with the message:"This operation is not supported onhis operating ystem."Installation of mysql and mysql-server does not help.
View 14 Replies View RelatedI have a Canon iR3570/iR4570 PXL, and installed the driver CQue 1.0 TCP/IP Queue from Canon webpage.
The problem:
- if i try to print an OpenOffice or LibreOffice Calc with an image and text, the image is not printed (the space is blank).
- if i try to print an OpenOffice or LibreOffice Calc with just an image, it's printed great.
- if i try to print an OpenOffice or LibreOffice Impress, the images are not printed but the text is printed great.
[Code]..
the color from the table I insert? All I want to do is insert a basic table with 6 columns and 3 rows. I get that, but it has a gradient blue color.
View 1 Replies View RelatedI use WordPress. If I want to choose an image to insert into the blog, the file browser window (unlike even the most basic version of Windows) only gives me a "list view" option and no other options. This.Is.A.Huge.Limitation. I can't choose an image visually - only by name. Is there a way to remedy this? Will a different file browser (instead of Nautilus?) get me what I want?
View 9 Replies View RelatedI can insert an image inline with mutt by using attach, then using ctl+d to make the image appear inline. However, it appears below my signature. If anyone knows of a way to make the image appear above the signature, I'd be grateful for their input. (This is with mutt 1.5.21--usually sent from a Fedora 14 machine, but I haven't found the behavior to change with the platform.)
Unfortunately, it's necessary to do this at work, for a particular daily email. The workaround is to use Thunderbird for this particular email, but I'd much prefer to use mutt.
Errors received when trying to use drop shadow plugin..
"Error while executing script-fu-drop-shadow:
Error: eval: unbound variable: gimp-image-insert-layer"
"Plug-In 'Drop Shadow' left image undo in inconsistent state, closing open undo groups"
The OpenOffice Quickstarter icon in the system tray for Ubuntu 10.04 is an old image and does not fit in with the default theme (light grey background). In fact, the same icon used for the Windows version is at /usr/share/icons/hicolor/32x32/apps/openofficeorg3-startcenter.png. Where the quickstarter getting this misfitting icon? Perhaps I could simply copy the icon above to the location and file name used by quickstarter.
View 4 Replies View RelatedHave Karmic 9.10 ,Changed from Epson RX595 all in 1 (uses a ton of ink)Got the Lexmark Pro 805 3 in 1 because it says it supports Linux and the ink cartridge only cost $5 downloaded drivers and printer works but using Xsane Image Scanner error reports
'Lexmark_1_0_0:libsub/001/009': Device busy Using Image Scan - reports Could not send command to scanner Check the scanner status. The RX595's scanner drivers had to been manually instatlled,, in the Printer box the Lexmark shows available..
I got the following task from my boss. I have to find out if there is some alternative tool for create reports from Squid except SARG. Now, we use SARG, but my boss told to me, that the main problem of SARG is, that SARG generate huge amount files, which cause problems during migration our servers. He told to me the following condition for change of current tool (SARG):
* standard package of Debian
* generate less amount of files, optimal is to save reports to the database
So I would like to ask you if you know about some tool (I can not find some by google)... and the best would be if you told to me some practical experiences.
I wanted to compose a letter and include photos that are on my other (secondary) hd. When I navigate to the folder that the photo is in, OpenOffice suddenly crashes without warning. Then I have to recover my file. If I insert a photo from my main hd (the one with SuSE 11.2 on it) then there's no problem. Why does it crash when I try to go into my other hard drive? (It gets automatically mounted as /local when I boot into the system). I'm running Open SuSE 11.2 and OpenOffice 3.1.1.4 (from an .rpm)
View 3 Replies View RelatedI am trying to copy content from firefox, which has images on it, to Openoffice writer. However, the image does not seems to get copied. It shows only some link. Is there a way to copy everything including images?
View 2 Replies View Relatedcan we find logarithm to base 10 instead of base 2 on shell script??i can do it with bc..like 'l(1000)/l(10)' | bc -l
View 1 Replies View RelatedI have a router that is 1000 Base T and two computers each with ethernet cards that support 1000 Base T. All are equipped with Cat 5e cable. Before I had a router that only went up to 100 Base T and I would setup one box with linux running proftpd. On the other box,I would use win xp pro and use firefox to ftp into the other box and download a file. Download speeds went up to 11.2 MB/sec. Now when I switched routers, I expected something like 120 MB/sec but I'm only getting 5.3 MB/sec. What do I need to change?
View 12 Replies View RelatedI'm trying to install a language-pack for my OpenOffice, but there seems to be a dependency-problem. Maybe someone has a suggestion. FC12, x64 OOo.x64 3.1.1
Code:
[root@sarah yum.repos.d]# yum install openoffice.org-langpack-de
Loaded plugins: fastestmirror, presto, refresh-packagekit, remove-with-leaves
Loading mirror speeds from cached hostfile
* fedora: ftp.astral.ro
* livna: rpm.livna.org
[Code]...
First, I'm sorry if some one has already posted this but I can't find it. I recently installed Ubuntu 10.04 LTS on my laptop and I have a dual boot between that and Vista. I cannot use Ubuntu for more than an hour or two before it won't let me type in text fields. When this happens, the menues (Applications, System, ect.) stop working also.
I can continue to browse the internet and play music when this happens. The problem can be recreated consistently by using OpenOffice Word Processor. I can not type more than a sentence in OpenOffice before this problem occurs. The only way to fix it is to hold the power button to shutdown.
I have an nfs share that mounts automatically when kde starts.
Code:
wendy@DellNB:~$ cat .kde/Autostart/mountNAS.sh
#!/bin/bash
mount ~/TestShare
#echo "NAS Mounted"
[code]...
Gimp works fine editing and saving photos from/to the nfs share. kWrite can do its thing and read/create files on the NAS. Files I create with vim are visible and editable under windows. OpenOffice however, when I try an open a file I get "file is locked by unknown user." I open as copy and try saving to the share with a different name... No Dice, error saving to share the file is created on the share but it is empty. I did some reading and found a post that said to comment a line from a file called soffice, which I cannot find.
I have a filename file-name-here-1.2.3-i486-2.tar I would like to know how to remove the last two fields leaving only: file-name-here-1.2.3
I can use:
x=file-name-here-1.2.3-i486-2.tar
echo ${a%-*}
to remove the last field (after -) but how do i remove the last two in one fell swoop?
It's a pretty weird issue I'm having, when I need to provide access for a command in terminal IE: something using sudo, it just doesn't accept text. I thought it might be my keyboard at first (g15) but I tried copying and pasting the password into there and it just wouldn't do anything except for remain blank
View 3 Replies View RelatedI'm writing a couple of programs in C and need to do something to formatting the output. I'm after producing something like a old mainframe screen or early micro where you could PRINT (x,y) to put something on the terminal where you want it. Learning GTK or such is not an option due to time constraints, and some fields need updating frequently during processing, so letting the terminal scroll is going to drive the operator up the wall pretty quickly.
View 2 Replies View RelatedI have a file1:
Code:
$ cat PF(1).out
Tmp39 PF10271.3 423 ENSP00000326063 488 1.2e-201 41-478
Tmp39 PF10271.3 423 ENSP00000338165 492 1.9e-200 46-479
[code].....
I have a file records as follows:
Jane pepe@pepe.biz
john@pepe.net John
Joe joe@willxyz.org
How can I get that always first field be given name and second one be the mail address?
I've tried
Code:
awk '$1 ~ /@/ { a=$1 ; $1=$2; $2=a; print }' file
But that doesn't worked
Using wine, re-installed EVE (hadn't played for awhile), things went fine, ran eve, things were fine... then like an idiot in the middle of the opening graphic sequence I tried to exit out... big mistake... system hung up and I had to do a hard restart. Upon restart the following has happened:
1. I currently cannot type into SOME text fields. I can type into Firefox, and Open office, but not into KDE wallet, Kubuntu search fields, or the terminal (big problem). If i go out of KDE and straight command line I can run terminal commands. I can also cut and paste into all text fields including the ones I cannot type into.
2. I've lost all X, Minimize, and Maximize from ALL windows, and cannot move windows. I can resize some windows, like firefox however. Windows are not layering properly, if any window is open the "start" button menu will be blocked out, and the opened windows will not layer behind it (makes me have to resize windows to shut down).
3. Tried to go back to a prior good configuration to no avail. The 3 most recent configs have the same errors now, and the configs prior to that are refusing to initialize KDE... screen will flicker and then go strait to command lines.
notes: I have tried changing graphics drivers to no avail, and have redone the keyboard selection to no avail. Also uninstalled wine, but that didn't do anything. basically, I can work within the errors and make stuff run, but it's a huge PITA. running Kubuntu 10.10*was running wine 1.3.5