Re: [libreoffice-users] Window focus bug when importing a file into Calc

[Cor Nouws]

Hi Fabian,

Fabian Rodriguez wrote (27-01-12 20:33)


The problem: When importing a text file into Calc (eg. CSV), the import
dialog does not steal focus as expected
[...]
This only happend when LibO is already open in the background with
another document. As a result, on a busy desktop, the window does not
show up and it can be interpreted as if nothing happened.

Steps to reproduce in Windows Libo 3.5rc2:


Thanks for the clear explanation.
I cannot reproduce the problem om Ubuntu with 3.4.5 and 3.5.0RC2

But often, those issues depend on many factors, I guess.

I do have a problem with the window not being on top, when I open a 
password protected file.(I thought I had a bug filed, but cannot find it 
in my inbox now ..)


Cheers,

--
 - Cor
 - http://nl.libreoffice.org


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: how to create mailmerge with libre base only without using libre calc.

[Alex Thurgood]

Le 02/02/2012 02:04, sonic a écrit :

Hi Sonic,


Dear BRO, SIR,SIS,
May I know is there any other alternative ways to create mail merge with
libre base and generate report from libre base without opening other program
like libre writer or libre calc to do it..
which mean that , want to using 1 program only to do all the job that's
libre base .


Short answer : for mailmerge, no. You must use Base in combination with 
Writer


If you want a report, you can :
(1) use the Oracle Report Builder, which is a built-in extension, 
accessible, for example, via a Base (ODB) file ;

(2) use a Calc file and design your own report using data ranges;
(3) use a Writer file, and insert your data fields from the table or 
query of your choice ;
(4) write an external program using python, javascript, beanshell, perl, 
php, etc to manipulate ODF compliant XML and interface that with your 
datasource.



If there any tutorial or suggestion pls do let me know tQ your's help are
much appreciated...



Information and tutorials for manipulating ODF XML :

http://stackoverflow.com/questions/3477597/how-to-generate-odf-charts-with-perl

http://search.cpan.org/~jmgdoc/OpenOffice-OODoc-2.125/OODoc/Intro.pod

http://cpanforum.com/threads/3039

http://www.opendocsociety.org/tools/odf-tools/

http://letscript.wordpress.com/2011/09/30/from-mysql-to-opendocument-format-with-perl/


Information about using Calc or the Report Builder to make reports :

http://wiki.services.openoffice.org/wiki/SUN_Report_Builder/Documentation

http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=18511

http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727


Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer - Strange behavior of paragraph styles

[Cor Nouws]

John D. Herron wrote (02-02-12 05:23)


[...]
FWIW i DID carefully read the manual on styles and templates.
[...]
As an aside: can anyone tell me what difference there is between
'Default' and 'Text body'?


:-D

--
 - Cor
 - http://nl.libreoffice.org


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Printer always selects "PDF" instead of Postscript

[Jay Lozier]

On 02/01/2012 05:45 PM, TJ wrote:

On 01/25/2012 01:56 PM, Don C. Myers wrote:

Hi,

Here is more information about this issue:
https://issues.apache.org/ooo/show_bug.cgi?id=94173

http://unix.stackexchange.com/questions/15938/libre-office-change-printer-language-type-from-pdf-to-postscript 




http://www.google.com/#hl=en&sugexp=pfwl&cp=25&gs_id=2q&xhr=t&q=cups+printer+language+pdf&pf=p&output=search&sclient=psy-ab&pbx=1&oq=cups+printer+language+pdf&aq=f&aqi=&aql=&gs_sm=&gs_upl=&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=ed6966981cf4427a&biw=1680&bih=942 




Don

I'm using LibreOffice 3.4.4 from the Mageia 1 repositories with KDE, 
trying to print to a Deskjet 5650 printer, and I'm having problems 
with this, too. My problem is related to that experienced by the Arch 
user in your second link, in that landscape -oriented spreadsheets 
from Calc aren't printing properly - to say the least. Mine prints 
fine until it gets to the 8.5 inch mark, then it prints a truncated 
version of the last column over and over until the edge of the paper. 
Print Preview looks fine, and while I haven't tried it yet I suspect 
printing to a pdf file would work, too.


Changing the printer language to Postscript fixes it. I haven't 
noticed the problem with other applications yet, but then I don't 
print much as a regular rule, just this time of year.


I didn't have the problem last year, when I was using Mandriva 2010.2 
and OpenOffice.


I can try to remember to change the printer language on every document 
I make in the future, but like Mr. Jordan I think it's a pain in the 
butt to remember to change it if I go to print old documents. I tried 
running spadmin as root to change the default, but for some reason 
Mageia wouldn't do it. Probably just as well, as I'm very much out of 
my element when it comes to command line noodling.


It shouldn't have to be that way, anyway. There should be an easy way 
to make Postscript the default, if you want.


TJ



I have not noticed any problems printing from Linux Mint 12. I would 
check the default printer settings and test the printer with another 
non-LO program to see if the problem is with the printer set up. The 
printer could be set up to default everywhere to pdf not to postscript.


--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem with spreadsheets in Writer

[Jay Lozier]

On 02/01/2012 08:31 PM, Andrew Lei wrote:

When I insert a spreadsheet containing borders into writer, some of the
borders are missing when I convert to .pdf or print. See pages 11-13 of the
attachment. Do you know what's wrong, or is this a bug?

Andrew Lei


Please post the file on nabble or some other sight and post a link.

--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Problem with spreadsheets in Writer

[Andrew Lei]

When I insert a spreadsheet containing borders into writer, some of the
borders are missing when I convert to .pdf or print. See pages 11-13 of the
attachment. Do you know what's wrong, or is this a bug?

Andrew Lei

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] emacs mode?

[lee]

webmaster for Kracked Press Productions 
writes:

> On 01/29/2012 03:16 PM, Mirosław Zalewski wrote:

> "emacs" seems to me that it is used for mainframe programming editors,
> not word processors.

You can do lots of things with emacs. It´s not at all limited to the
programming of mainframes.

> Well I got spoiled after all those years on a dumb terminal or typing
> punch cards.  I prefer a "window" environment like GNOME2 gives you
> over Terminal use that works a lot like what I had to do with the
> mainframes I worked on.

Everyone their own :) I´m using the combination of both by running the
programs I want in a "window environment". It´s just easier this way
than running them on a console and switching over to the GUI when
needed.

You can have emacs in a terminal or with its own frames (i. e. windows)
or both. You might try, though I guess you won´t like it.

> So the question is what you are doing for the typing?

For almost all the typing I do, I´m far better off with a text editor
than with an office package like LO. If it really comes to "WYSIWYG", I
wish I had a decent DTP program rather than only LO --- and Scribus
doesn´t cut it because you can´t reasonably place objects on a page in
such a way that they are aligned.

I don´t really have need/use for an office package like LO other than
one or the other occasional "odd" thing like a spreadsheet or a text
that needs the kind of formatting easily done with its writer --- and
the database part of LO is, unfortunately, worlds behind of what MS
Access offered years ago.

> I know that if you have had years worth of finger-memory for using the
> keyboard shortcuts, that is is hard to get use to using the mouse/menu
> option and the word processor's internal shortcuts

Using a mouse or a menu is an interruption to me unless I´m actually
doing something "graphically". I´m not writing with a mouse or a
menu. I´m not drawing pictures with the keyboard. I´m not so much
visually orientated that I would memorise loads of icons, and I´m not
using them because I never know what they mean: This makes these icon
bars so many GUI applications have a total waste of screen space, and
it´s usually not easy to just turn them off. Using a GUI can be rather
straining on me because everything looks the same and it´s very
difficult to figure out what is what --- it´s hard to explain if you
don´t experience it yourself.

There are just many things that can be done easier and/or more
efficiently with the keyboard and another many things that can be done
easier and/or more efficient with a GUI.

> like Ctrl-Alt-f to open the Find/Replace option[s] or Ctrl-A for
> select all.  I do not remember these shortcuts much.  Each package
> seems to have their own definations beyond Ctrl-x, -c, and -v.  Some
> change Ctrl-c and -z as well.

Yeah, indeed. That´s another thing that makes these GUI applications so
awkward to use: You are forced to use the mouse, and for many things, I
don´t like that because it´s so interrupting, slows everything down and
makes it more difficult and straining.

And LO still isn´t advanced enough that you can have scroll bars on the
left side where they belong and not on the right side, and copy and
paste doesn´t work right. Emacs and xterm and other apps do it just fine
...

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Printer always selects "PDF" instead of Postscript

[TJ]

On 01/25/2012 01:56 PM, Don C. Myers wrote:

Hi,

Here is more information about this issue:
https://issues.apache.org/ooo/show_bug.cgi?id=94173

http://unix.stackexchange.com/questions/15938/libre-office-change-printer-language-type-from-pdf-to-postscript


http://www.google.com/#hl=en&sugexp=pfwl&cp=25&gs_id=2q&xhr=t&q=cups+printer+language+pdf&pf=p&output=search&sclient=psy-ab&pbx=1&oq=cups+printer+language+pdf&aq=f&aqi=&aql=&gs_sm=&gs_upl=&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=ed6966981cf4427a&biw=1680&bih=942


Don

I'm using LibreOffice 3.4.4 from the Mageia 1 repositories with KDE, 
trying to print to a Deskjet 5650 printer, and I'm having problems with 
this, too. My problem is related to that experienced by the Arch user in 
your second link, in that landscape -oriented spreadsheets from Calc 
aren't printing properly - to say the least. Mine prints fine until it 
gets to the 8.5 inch mark, then it prints a truncated version of the 
last column over and over until the edge of the paper. Print Preview 
looks fine, and while I haven't tried it yet I suspect printing to a pdf 
file would work, too.


Changing the printer language to Postscript fixes it. I haven't noticed 
the problem with other applications yet, but then I don't print much as 
a regular rule, just this time of year.


I didn't have the problem last year, when I was using Mandriva 2010.2 
and OpenOffice.


I can try to remember to change the printer language on every document I 
make in the future, but like Mr. Jordan I think it's a pain in the butt 
to remember to change it if I go to print old documents. I tried running 
spadmin as root to change the default, but for some reason Mageia 
wouldn't do it. Probably just as well, as I'm very much out of my 
element when it comes to command line noodling.


It shouldn't have to be that way, anyway. There should be an easy way to 
make Postscript the default, if you want.


TJ



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] emacs mode?

[lee]

anthropornis  writes:

> I am curious, which, if any, word processing programs (not text
> editors) actually have an Emacs "mode"?

Oh I would like to know that, too :)

> Compared to the broader base of non-techie word processor users,
> making a word processor behave like Emacs would be extraordinarily
> niche oriented.

To me, there´s quite a difference between "make application A (behave)
like application B" and "be able to define (some frequently used) key
bindings in application A to be the same ones as in application B for
the same functionality". Do you want, for example, your MUA behave like
the spreadsheet in LO --- or would you rather have the same key binding
in your MUA and in your spreadsheet for saving your work?

The latter isn´t a new idea. And isn´t LO "extraordinarily niche
orientated" in beeing programmable with it´s own programming language
--- or is it more like emacs in that regard than people happen to
notice?

> Why don't you just actually write documents in Emacs and do some LaTex
> or similar formatting like some other Emacs users do?

It´s because I´m not sufficiently familiar with LaTeX to always get the
result I want with LaTeX with the same amount of effort I can get the
result with LO. It has been the other way round as well. It´s only a
matter of chosing the right tool for the job --- and if I could adjust
the key bindings in LO to what I use in emacs, I could make the job
even easier for me.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LO Writer - Strange behavior of paragraph styles

[John D. Herron]

Hi, everyone.

Running LO 3.4.3 OOO340m1 (Build:302) on Ubuntu 11.04 (Linux 
2.6.38-generic-pae) w/ Gnome 2.32.1.


Find myself having to cope with some very strange behavior of paragraph 
styles, not previously encountered in any version of OOo.


I defined my 'Default' style as follows: font Ubuntu 12 regular, no 
indents, single spacing, 0.00" before and after, justified.


As I begin a new document and type a one-line paragraph, then press 
Return to start a new paragraph, all is OK.
If I press Return once more (adding an empty line), the previous 
paragraph gets indented without any prompting!
When I go back to the previous paragraph with "ArrowUp", the style 
changes - without any prompting! - to Text Body...


If I go back to the beginning of any Default or Text Body paragraph and 
press Return twice, the paragraph is transformed into text that is both 
bold and increased in size...


All of this, though, merely scratches the surface of my paragraph-style 
misadventures in LO.


It's enough to drive me insane, to the point where I'm seriously 
considering returning to one of the recent versions of OpenOffice.


FWIW i DID carefully read the manual on styles and templates. Like I 
said: no problems in OOo, a disaster in LO.
As an aside: can anyone tell me what difference there is between 
'Default' and 'Text body'?


Can anyone offer any suggestions on how to correct / troubleshoot this?

Thanks in advance.
john


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: ppt files not displaying correctly

[Jeffrey Martin]

I found out that if I click on layout for each slide it fixes the text box
issue for that slide, but the slide number is still in the wrong place.

On Wed, Feb 1, 2012 at 9:39 PM, Jeffrey Martin  wrote:

> One of my professors makes his powerpoint slides available, but when I
> load them in Libreoffice they are a little off.
> Instead of the page number being in the lower right hand corner the page
> number is in the upper left corner and obscured partially by the slide.
> When you select the note tab the text box for the notes is on the left
> side and has a width of one character.
> I noticed the professor is using a Mac, but if he's using MS Office then
> the ppt should be the same. It displays correctly on the PC's in the
> library.
> -Jeff
>
> --
> Jeffrey John Martin
> dogs...@gmail.com
>



-- 
Jeffrey John Martin
dogs...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] ppt files not displaying correctly

[Jeffrey Martin]

One of my professors makes his powerpoint slides available, but when I load
them in Libreoffice they are a little off.
Instead of the page number being in the lower right hand corner the page
number is in the upper left corner and obscured partially by the slide.
When you select the note tab the text box for the notes is on the left side
and has a width of one character.
I noticed the professor is using a Mac, but if he's using MS Office then
the ppt should be the same. It displays correctly on the PC's in the
library.
-Jeff

-- 
Jeffrey John Martin
dogs...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem pasting spreadsheet cells into Impress

[TomW]

On 2012-02-01 06:33, Tanstaafl wrote:

On 2012-01-31 6:19 PM, TomW  wrote:

On 2012-01-31 06:42, Tanstaafl wrote:

On 2012-01-30 3:36 PM, Cor Nouws  wrote:

I tried in 3.4.5 and it works there fine too. Ctrl-V creates a nice
Impress-table with the content that I copy from Calc.



But... we don't want to convert the copied cells into an Impress Table
when pasting them, we want them to be an embedded 'spreadsheet', that
when double-clicked, allows you to edit it as if it was a spreadsheet.
This is how it used to work a long time ago - and how Microsoft Office
works by default.

I don't know which version/update changed this...

I'll have to find an example spreadsheet/Presentation that causes this
problem and file a bug and upload them to it...

Thanks for checking Cor...



Tanstaafl:

OOo 2.4.2 pastes as a calc8 file by default.
OOo 3.2.1 pastes as table of cells by default.


Hi Tom,

Thanks very much for looking at this, but a question to confirm...

It looks like you didn't check every version in between, just figured 
out that it changed somewhere between 2.4.2 and 3.2.1, correct?


Now, I guess the questions are, 1) what was the precise version where 
this behavior changed, 2) was the change intentional, and 3) if so, 
*why*.


Imho, the default behavior should mimic MSO (the most popular office 
package with the largest installed base, whether one likes it or not).


Cor? anyone? Should I just go file a bug?



Tanstaafl:

The earliest I have found that changed to pasting as a table is 
OOo3.0.1.  I may have the release notes archived somewhere.


TomW


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Saving SXD = Blank Doc

[Boostland]

Looks like there is another bug involving the legacy file formats.


https://bugs.freedesktop.org/show_bug.cgi?id=45521

"Open sdw file save as odt or sxw close then reopen file and some data is
changed or lost, this happens on both the 3.5.0 RC2 and on 3.4.5 final.

This bug does not appear to be in the 3.3.4 release.

It is a major flaw as data loss can go unnoticed."

--
View this message in context: 
http://nabble.documentfoundation.org/Saving-SXD-Blank-Doc-tp3414786p3708748.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] how to create mailmerge with libre base only without using libre calc.

[sonic]

Dear BRO, SIR,SIS,
May I know is there any other alternative ways to create mail merge with
libre base and generate report from libre base without opening other program
like libre writer or libre calc to do it.. 
which mean that , want to using 1 program only to do all the job that's
libre base .

If there any tutorial or suggestion pls do let me know tQ your's help are
much appreciated...

--
View this message in context: 
http://nabble.documentfoundation.org/how-to-create-mailmerge-with-libre-base-only-without-using-libre-calc-tp3708639p3708639.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] RE: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[sonic]

Hi bro,
Do you have any alternative ways to do in libre base.. directly is there any 
tutorial for doing mail merge in libre base.
yes i found out already can upgrade or edit data in spreadsheet after 
registered the spreadsheet in base.. 
TQ 
regards,
sonic

Date: Wed, 1 Feb 2012 09:48:18 -0800
From: ml-node+s969070n3707376...@n3.nabble.com
To: ghostbusters_so...@hotmail.com
Subject: Re: create mailmerge with spreadsheet librecalc without using libre 
base ! pls help how to do it TQ



Am 28.01.2012 04:39, sonic wrote:

> HI,

> i'm facing a problem which doing mailmerge without using BASE to registered

> to the data source.


This is impossible. Mail merge reads data from a registered Base file 

regardless of any file formats.

For various reasons, spreadsheets are by far the worst choice for list 

keeping. A most simple dBase file performs much better and can be edited 

directly in the data source window without opening nor saving any 

document at all.



-- 

For unsubscribe instructions e-mail to: [hidden email]

Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted










If you reply to this email, your message will be added to the 
discussion below:

http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3707376.html



To unsubscribe from create mailmerge with spreadsheet librecalc 
without using libre base ! pls help how to do it TQ, click here.

NAML
  

--
View this message in context: 
http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3708614.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problems with format in Calc

[Thomas Damratowski]

 changes to the day, but adds a ',' at the end of the day "monday,".
Running
Windows 7
LibreOffice 3.4.5
OOO340m1 (Build:502)

On Wed, Feb 1, 2012 at 6:13 PM, Tom Davies  wrote:

> Hi :)
> The ' over-rides the formatting and sets it as text.  Did you type the '
> or did it just appear magically? Was there a typo when you set the date
> format?
> Regards from
> Tom :)
>
>
> --- On Wed, 1/2/12, Johnny Rosenberg  wrote:
>
> From: Johnny Rosenberg 
> Subject: Re: [libreoffice-users] Problems with format in Calc
> To: users@global.libreoffice.org
> Date: Wednesday, 1 February, 2012, 22:11
>
> 2012/2/1 Jean Milot :
> > Hi all,
> >
> > I have a date in a cell : 2012-01-02
> > I would like to have the day so i change format : Date /  but when i
> > change the format.
> >
> > I have the apparition of " ' " at the beginning of the cell.
> >
> > If i remove it it works i obtain the day.
> >
> > For now, i use : JOURSEM(date)
> >
> > Thanks.
>
>  works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays
> ”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and
> ”måndag” (monday) for 2012-01-02.
>
>
> You didn't mention your operating system or version of LibreOffice,
> maybe there is a bug in your version?
>
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Tom Davies]

Hi :)
I think it's a classic case of something that is so nearly perfect and with 
such huge potential and clever, uncompromising concept.  It's even more 
frustrating than some broken heap of junk precisely because it's so close but 
misses (in the fairly rare cases when it does miss).  Most people seem to have 
no troubles with it but for a few it's like scratching finger-nails down a 
black-board.
Regards from
Tom :)


--- On Wed, 1/2/12, Dan Lewis  wrote:



     In other words, I think there is more to Base than I seem to be
reading in this and other threads. 
--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Mac Issues

[Larry Gusaas]

On 2012-01-31 2:39 PM  Moore, Rick wrote:

Sing a Mac with OX10.7 and Libre 3.5.  I keep getting a restore Window
Pop-up window that says the following:

The application "LibreOffice" unexpectedly quit while trying to restore
its windows.  Do you want to try and restore its windows again.

You have 2 option - Don't Restore Window and Restore Window

See 
http://user.services.openoffice.org/en/forum/viewtopic.php?f=17&t=43095#p198915


--
_

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - 
Edgard Varese



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problems with format in Calc

[Tom Davies]

Hi :)
The ' over-rides the formatting and sets it as text.  Did you type the ' or did 
it just appear magically? Was there a typo when you set the date format?
Regards from
Tom :)


--- On Wed, 1/2/12, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: Re: [libreoffice-users] Problems with format in Calc
To: users@global.libreoffice.org
Date: Wednesday, 1 February, 2012, 22:11

2012/2/1 Jean Milot :
> Hi all,
>
> I have a date in a cell : 2012-01-02
> I would like to have the day so i change format : Date /  but when i
> change the format.
>
> I have the apparition of " ' " at the beginning of the cell.
>
> If i remove it it works i obtain the day.
>
> For now, i use : JOURSEM(date)
>
> Thanks.

 works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays
”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and
”måndag” (monday) for 2012-01-02.


You didn't mention your operating system or version of LibreOffice,
maybe there is a bug in your version?



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: table - automatically copy text

[Brian Barker]

At 09:09 01/02/2012 -0500, William Drescher wrote:

On 2012-02-01 11:19, Paul Whitehurst wrote:
I'm using tables in swriter that have text in them. I would like to 
insert text and have the text copied to other cells automatically. 
I know I can enter numbers and insert a formula that copies the 
number from one cell into another. The same formula doesn't seem to 
work with text.


I entered abcd into cell a1 and then in cell b1 entered =A1 and the 
text was copied without error to cell b1.  Is that what you are looking for ?


Probably not!  What you are describing is clearly the use of cells of 
a spreadsheet (Calc) document; I think we all know you can do this in 
a spreadsheet.  The questioner is asking instead about automatically 
copying text between the cells of a table in a text (Writer) document.


Brian Barker


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problems with format in Calc

[Johnny Rosenberg]

2012/2/1 Jean Milot :
> Hi all,
>
> I have a date in a cell : 2012-01-02
> I would like to have the day so i change format : Date /  but when i
> change the format.
>
> I have the apparition of " ' " at the beginning of the cell.
>
> If i remove it it works i obtain the day.
>
> For now, i use : JOURSEM(date)
>
> Thanks.

 works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays
”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and
”måndag” (monday) for 2012-01-02.


You didn't mention your operating system or version of LibreOffice,
maybe there is a bug in your version?



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How to fix "error exists on this page" PDF error from LibreOffice 3.4 generated documents?

[Prashant Patil]

Tom Davies  yahoo.co.uk> writes:

> 
> Hi :)
> I found the bug-tracking thing for them
> http://sourceforge.net/tracker/?group_id=72954&atid=536236
> 
> Can you insert the image and text into the original using LibreOffice before 
exporting as Pdf?  Does that
> give the same error message?  I think copy&paste might help.  
> 
> Regards from
> Tom :)
> 
> --- On Mon, 30/1/12, prashant Patil  ext.icicibank.com> 
wrote:
> 
> From: prashant Patil  ext.icicibank.com>
> Subject: [libreoffice-users] How to fix "error exists on this page" PDF 
error from LibreOffice 3.4
> generated documents?
> To: users  global.libreoffice.org
> Date: Monday, 30 January, 2012, 7:55
> 
> Dear Admin,
> 
> I have exported a document to PDF file in LibreOffice 3.4 Writer.
> In this PDF, I am inserting image and text using ITextsharp dll 5.0.5.0
> The processing is done successfully. But while opening the processed PDF
> first time; is displayed the following error:
> "An error exists on this page. Acrobat may not display the page correctly.
> please contact the person who created the pdf document to the problem"
> 
> Kindly advice how to remove the error message.
> 
> Thanks & Regards,
> 
> Prashant Patil, Senior Software Engineer, Software ICICI-SA, 3i Infotech
> Ltd.
> Tel.Direct: + 91 22 4084 5767 | Email: prashant.p  ext.icicibank.com |
> www.3i-infotech.com
> 


Dear Tom,
 
We cannot insert the image and text into the original LibreOffice document, as 
we receive the ready converted PDF files from the business users.
And our application (.NET exe version 3.5) does the insertion in the received 
PDF files as per the business logic.
 
Kindly suggest any other solution/dll that can resolve the said issue.


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

RE: [libreoffice-users] How to fix "error exists on this page" PDF error from LibreOffice 3.4 generated documents?

[prashant Patil]

Dear Tom,

We cannot insert the image and text into the original LibreOffice document,
as we receive the ready converted PDF files from the business users.
And our application (.NET exe version 3.5) does the insertion in the
received PDF files as per the business logic.

Kindly suggest any other solution/dll that can resolve the said issue.


Thanks & Regards,

Prashant Patil, Senior Software Engineer, Software ICICI-SA, 3i Infotech
Ltd.
Tel.Direct: + 91 22 4084 5767 | Email: prashan...@ext.icicibank.com |
www.3i-infotech.com


  -Original Message-
  From: Tom Davies [mailto:tomdavie...@yahoo.co.uk]
  Sent: Monday, January 30, 2012 8:35 PM
  To: users@global.libreoffice.org
  Cc: prashant Patil
  Subject: Re: [libreoffice-users] How to fix "error exists on this page"
PDF error from LibreOffice 3.4 generated documents?


Hi :)
I found the bug-tracking thing for them
http://sourceforge.net/tracker/?group_id=72954&atid=536236

Can you insert the image and text into the original using
LibreOffice before exporting as Pdf?  Does that give the same error message?
I think copy&paste might help.

Regards from
Tom :)


--- On Mon, 30/1/12, prashant Patil 
wrote:


  From: prashant Patil 
  Subject: [libreoffice-users] How to fix "error exists on this
page" PDF error from LibreOffice 3.4 generated documents?
  To: users@global.libreoffice.org
  Date: Monday, 30 January, 2012, 7:55


  Dear Admin,

  I have exported a document to PDF file in LibreOffice 3.4 Writer.
  In this PDF, I am inserting image and text using ITextsharp dll
5.0.5.0
  The processing is done successfully. But while opening the
processed PDF
  first time; is displayed the following error:
  "An error exists on this page. Acrobat may not display the page
correctly.
  please contact the person who created the pdf document to the
problem"

  Kindly advice how to remove the error message.


  Thanks & Regards,

  Prashant Patil, Senior Software Engineer, Software ICICI-SA, 3i
Infotech
  Ltd.
  Tel.Direct: + 91 22 4084 5767 | Email:
prashan...@ext.icicibank.com |
  www.3i-infotech.com



  --
  For unsubscribe instructions e-mail to:
users+h...@global.libreoffice.org
  Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
  Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
  List archive: http://listarchives.libreoffice.org/global/users/
  All messages sent to this list will be publicly archived and
cannot be deleted


---
  "Print this mail only if absolutely necessary. Save Paper. Save Trees." 

"This e-mail message may contain confidential, proprietary or legally 
privileged information. It 
should not be used by anyone who is not the original intended recipient. If you 
have erroneously 
received this message, please delete it immediately and notify the sender. The 
recipient 
acknowledges that ICICI Bank or its subsidiaries and associated companies,  
(collectively "ICICI 
Group"), are unable to exercise control or ensure or guarantee the integrity 
of/over the contents
of the information contained in e-mail transmissions and further acknowledges 
that any views 
expressed in this message are those of the individual sender and no binding 
nature of the message
shall be implied or assumed unless the sender does so expressly with due 
authority of ICICI Group.
Before opening any attachments please check them for viruses and defects." 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Mac Issues

[Moore, Rick]

Sing a Mac with OX10.7 and Libre 3.5.  I keep getting a restore Window
Pop-up window that says the following:

 

The application "LibreOffice" unexpectedly quit while trying to restore
its windows.  Do you want to try and restore its windows again.

 

You have 2 option - Don't Restore Window and Restore Window

 

I've uninstalled several times and still get the error.  Tried the
nabble suggestions and none of them work?  Any ideas?

 

Rick Moore

Manager, Network Operations

Physician Associates Management

407-622-2723

 


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LWP documents

[Stefan Gruber]

Gregory Forster schrieb am Freitag, 27. Januar 2012 00:30:

> How do I open LotusWord Pro documents?  When I click on the document in
> Windows Explorer, I get a blank screen.

We have also a lot of old WordPro-Files in my company.
Some of them get opened by LibreOffice, but most of them do not and report 
an error message.

So you still can't rely on this filter.

We're keeping an old LotusSmartsuite inside an Virtual Machine, and transfer 
contents on demand via clipboard or DOC-Files...

Stefan


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: table - automatically copy text

[william drescher]

On 2/1/2012 2:30 AM, Steve Edmonds wrote:

Hi.
If I understand you correctly, you can create fields and then
have them displayed in other locations. I.e. entered in one place
and displayed in many.
steve

On 2012-02-01 11:19, paulwhitehurst wrote:

I'm using tables in swriter that have text in them. I would
like to insert
text and have the text copied to other cells automatically. I
know I can
enter numbers and insert a formula that copies the number from
one cell into
another. The same formula doesn't seem to work with text.

Any help would be appreciated.

Paul.

--
View this message in context:
http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3704908.html

Sent from the Users mailing list archive at Nabble.com.





I entered abcd into cell a1 and then in cell b1 entered =A1 and 
the text was copied without error to cell b1.  Is that what you 
are looking for ?


bill


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Tom Davies]

Hi Dan  :)
OpenJDK is also owned by Oracle but that might be mitigated by having a 
community involved.  I'm not sure if normal java has a community too.  Ubuntu 
10.04LTS has java 6_20 by default at the moment.  Perhaps you also have one of 
the good (at least for LO) versions such as 6_21 or 6_22.

The creator of the course you gave a link to just emailed me moments before you 
posted and said that is a back-up and the better site is 
http://dl.dropbox.com/u/9113961/virtualclassroom/chap8/libreoffice_base.html

It looks a lot nicer!  Same content i guess but looks can count for a lot 
sometimes
Regards from
Tom :)



--- On Wed, 1/2/12, Dan Lewis  wrote:

From: Dan Lewis 
Subject: Re: [libreoffice-users] Re: How get LibreO-Base working?
To: users@global.libreoffice.org
Date: Wednesday, 1 February, 2012, 20:06

On Wed, 2012-02-01 at 08:43 +0100, Alex Thurgood wrote:
> Le 31/01/2012 22:07, Andreas Säger a écrit :
> 
> Hi Andreas,
> 
> > Am 31.01.2012 20:16, Alexander Thurgood wrote:
> >>
> >> Yes, the dependency on Java JRE/JDK is a pain in the backside, but
> >> unfortunately unavoidable if you want to use Base, at least for the time
> >> being.
> >>
> >
> > With no Java being installed, I can connect a Base document to any
> > non-Java database, write queries, draw input forms and use Calc as
> > reporting engine.
> >
> >
> 
> And I would state that that is an "unusual" user setup. The user here 
> wants a relational database with subforms and reports and does not want 
> to use mysql, so where does that leave him her with regard to Base - 
> IMO, with HSQLDB, the stock db engine provided with LO. For that, you 
> need a JRE/JDK.
> 
> And Calc for reports is OK, much as is Writer, but for anything a bit 
> more than a simple report, the user will have to deal with not only the 
> idiosyncrasies of the respective tool used for creating the report, 
> plus, in general, learn to use macros. The whole benefit of having a 
> specific reporting tool (the Java based ORB extension) is that this is 
> suppose to ease that pain.
> 
> Personally, I'd love to be able to say, you get a great and easy to use 
> db reporting engine without Java in LO, but that is simply not the case 
> at the moment.
> 
> 
> Alex

     Is this a "Windows" problem? I'm not having any problems using Base
with the Ubuntu O/S. My java is openjdk-6-jre. This java is supplied by
from Ubuntu's repositories. I don't know, but I suspect that this java
version can also be used for other Linux distributions. 
     This java's description: Full Java runtime environment - needed for
executing Java GUI and Webstart programs. Using Hotspot JIT. The
packages are built using the IcedTea build support and patches from the
IcedTea project. (Maybe someone else understands this jargon.)
     I wonder about some of the comments that have been made in this
thread. What I do know is that OOo 3.3 (or perhaps earlier) contained a
method to disable the Base Wizard. The word at the time was that there
were large companies wanting to control who in their company could
create .odb files (database document files) at work. These companies
were told what configuration file had to be changed from what  to what.
      I realize that the security holes found in java has been a
problem. I seem to have seen somewhere that the java based upon the
IcedTea project does not have these holes.
      I use Base for embedded databases that are flat, relational, one
that is a combination of flat and relational I have one .odb file that
links to a spreadsheet. They all work.
     "Base Tutorial: From Newbie to Advocate in a one, two... three!" by
Mariano Casanova
 written for OOo (publication date: August 2010. This is a fairly
sophisticated application created using Base. 
     Here is a link that is a Base Tutorial which is a online course for
Base. The estimated time required to go through this tutorial is more
than 60 hours.

http://www.fhi.rcsed.ac.uk/rbeaumont/virtualclassroom/chap8/libreoffice_base.html

     In other words, I think there is more to Base than I seem to be
reading in this and other threads. 
--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Tom Davies]

Hi :)
There are Mac and GNu&Linux connectors for MySql / MariaDb but not a Windows 
one yet
http://extensions.libreoffice.org/extension-center/mysql-native-connector-for-mac-osx
If you do build a Windows one it would be fantastic if you could upload it to 
the Extensions site for other people to use.  

I'm not sure where to find the source code.  Hopefully it's pretty obvious.  
Regards from
Tom :)


--- On Wed, 1/2/12, Pertti Rönnberg  wrote:

From: Pertti Rönnberg 
Subject: Re: [libreoffice-users] Re: How get LibreO-Base working?
To: users@global.libreoffice.org
Date: Wednesday, 1 February, 2012, 20:23

Hi again,
First Tom:
I will try. Let us see what comes from the deeps of my mind and if I can find 
some old projects to investigate so I can give an understandable answer - I'm a 
little afraid that not.

Andreas:
Thank you for very interesting info. Please note that I am talking from a 
consumers point of view in no way professional in databases. When I worked with 
MSAccess I plainly saw it as a program - a tool - and tried to learn how to get 
it producing the needed results, how to do data input - data mixing and 
processing - data output.
The background philosophy and programming details were of no interest - I did 
not even know to ask. Knowing could have been of help.
I am aware of what you say about "real" relational dbs;  my intention is to do 
the ODBC connection (or JDBC if necessary) between LO-Base and (e.g.) MySQL but 
if I'm correct the LO-Base (32bit) must first start working stable with or 
without a JRE.
That's why I now put my question "how" to your admirable community.
Best regards
Pepe


On 1.2.2012 20:51, Andreas Säger wrote:
> Am 01.02.2012 19:36, Pertti Rönnberg wrote:
>> All of you.
>> Thanks very much for your kindness to bother answering - and for the
>> very interesting discussions.
>> 
>> My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps
>> will not be as mentioned in the desciption at LO-Wikipedia: "A database
>> management program
>> , similar to
>> Microsoft Access .. etc" .
> 
> The difference amounts to a multi-million Dollar budget and a decade of 
> development. OOo Base was maintained by 2 Sun/Oracle employees.
> 
> It is similar to Access. Access is named Access because you can access 
> databases with it. In *addition* Access provides the JET database engine 
> which embeds a database backend in the frontend file. Unfortunately, most 
> people work with JET which is why Access has a bad reputation among 
> professionals. I've seen very nice Access frontends for MySQL databases.
> 
> Base connects ODF documents with databases. In *addition* it can embed a 
> HSQLDB into the frontend file which is basically a zip archive with 
> configuration and Writer documents. Unfortunately, most people use the 
> embedded HSQLDB which is why Base has such a bad reputation.
> 
> If you ever had created some relational database backend using any database 
> specific, mature tool for the database, you would acknowledge how 
> straight-forward Base connects your database with this office suite.
> 
> Simply do your database with a database program. Base is not a database 
> program.
> 
> 


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Pertti Rönnberg]

Hi again,
First Tom:
I will try. Let us see what comes from the deeps of my mind and if I can 
find some old projects to investigate so I can give an understandable 
answer - I'm a little afraid that not.


Andreas:
Thank you for very interesting info. Please note that I am talking from 
a consumers point of view in no way professional in databases. When I 
worked with MSAccess I plainly saw it as a program - a tool - and tried 
to learn how to get it producing the needed results, how to do data 
input - data mixing and processing - data output.
The background philosophy and programming details were of no interest - 
I did not even know to ask. Knowing could have been of help.
I am aware of what you say about "real" relational dbs;  my intention is 
to do the ODBC connection (or JDBC if necessary) between LO-Base and 
(e.g.) MySQL but if I'm correct the LO-Base (32bit) must first start 
working stable with or without a JRE.

That's why I now put my question "how" to your admirable community.
Best regards
Pepe


On 1.2.2012 20:51, Andreas Säger wrote:

Am 01.02.2012 19:36, Pertti Rönnberg wrote:

All of you.
Thanks very much for your kindness to bother answering - and for the
very interesting discussions.

My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps
will not be as mentioned in the desciption at LO-Wikipedia: "A database
management program
, similar to
Microsoft Access .. etc" 
.


The difference amounts to a multi-million Dollar budget and a decade 
of development. OOo Base was maintained by 2 Sun/Oracle employees.


It is similar to Access. Access is named Access because you can access 
databases with it. In *addition* Access provides the JET database 
engine which embeds a database backend in the frontend file. 
Unfortunately, most people work with JET which is why Access has a bad 
reputation among professionals. I've seen very nice Access frontends 
for MySQL databases.


Base connects ODF documents with databases. In *addition* it can embed 
a HSQLDB into the frontend file which is basically a zip archive with 
configuration and Writer documents. Unfortunately, most people use the 
embedded HSQLDB which is why Base has such a bad reputation.


If you ever had created some relational database backend using any 
database specific, mature tool for the database, you would acknowledge 
how straight-forward Base connects your database with this office suite.


Simply do your database with a database program. Base is not a 
database program.






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Dan Lewis]

On Wed, 2012-02-01 at 08:43 +0100, Alex Thurgood wrote:
> Le 31/01/2012 22:07, Andreas Säger a écrit :
> 
> Hi Andreas,
> 
> > Am 31.01.2012 20:16, Alexander Thurgood wrote:
> >>
> >> Yes, the dependency on Java JRE/JDK is a pain in the backside, but
> >> unfortunately unavoidable if you want to use Base, at least for the time
> >> being.
> >>
> >
> > With no Java being installed, I can connect a Base document to any
> > non-Java database, write queries, draw input forms and use Calc as
> > reporting engine.
> >
> >
> 
> And I would state that that is an "unusual" user setup. The user here 
> wants a relational database with subforms and reports and does not want 
> to use mysql, so where does that leave him her with regard to Base - 
> IMO, with HSQLDB, the stock db engine provided with LO. For that, you 
> need a JRE/JDK.
> 
> And Calc for reports is OK, much as is Writer, but for anything a bit 
> more than a simple report, the user will have to deal with not only the 
> idiosyncrasies of the respective tool used for creating the report, 
> plus, in general, learn to use macros. The whole benefit of having a 
> specific reporting tool (the Java based ORB extension) is that this is 
> suppose to ease that pain.
> 
> Personally, I'd love to be able to say, you get a great and easy to use 
> db reporting engine without Java in LO, but that is simply not the case 
> at the moment.
> 
> 
> Alex

 Is this a "Windows" problem? I'm not having any problems using Base
with the Ubuntu O/S. My java is openjdk-6-jre. This java is supplied by
from Ubuntu's repositories. I don't know, but I suspect that this java
version can also be used for other Linux distributions. 
 This java's description: Full Java runtime environment - needed for
executing Java GUI and Webstart programs. Using Hotspot JIT. The
packages are built using the IcedTea build support and patches from the
IcedTea project. (Maybe someone else understands this jargon.)
 I wonder about some of the comments that have been made in this
thread. What I do know is that OOo 3.3 (or perhaps earlier) contained a
method to disable the Base Wizard. The word at the time was that there
were large companies wanting to control who in their company could
create .odb files (database document files) at work. These companies
were told what configuration file had to be changed from what  to what.
  I realize that the security holes found in java has been a
problem. I seem to have seen somewhere that the java based upon the
IcedTea project does not have these holes.
  I use Base for embedded databases that are flat, relational, one
that is a combination of flat and relational I have one .odb file that
links to a spreadsheet. They all work.
 "Base Tutorial: From Newbie to Advocate in a one, two... three!" by
Mariano Casanova
 written for OOo (publication date: August 2010. This is a fairly
sophisticated application created using Base. 
 Here is a link that is a Base Tutorial which is a online course for
Base. The estimated time required to go through this tutorial is more
than 60 hours.

http://www.fhi.rcsed.ac.uk/rbeaumont/virtualclassroom/chap8/libreoffice_base.html

 In other words, I think there is more to Base than I seem to be
reading in this and other threads. 
--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How get LibreO-Base working?

[Andreas Säger]

Am 01.02.2012 19:36, Pertti Rönnberg wrote:

All of you.
Thanks very much for your kindness to bother answering - and for the
very interesting discussions.

My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps
will not be as mentioned in the desciption at LO-Wikipedia: "A database
management program
, similar to
Microsoft Access .. etc" .


The difference amounts to a multi-million Dollar budget and a decade of 
development. OOo Base was maintained by 2 Sun/Oracle employees.


It is similar to Access. Access is named Access because you can access 
databases with it. In *addition* Access provides the JET database engine 
which embeds a database backend in the frontend file. Unfortunately, 
most people work with JET which is why Access has a bad reputation among 
professionals. I've seen very nice Access frontends for MySQL databases.


Base connects ODF documents with databases. In *addition* it can embed a 
HSQLDB into the frontend file which is basically a zip archive with 
configuration and Writer documents. Unfortunately, most people use the 
embedded HSQLDB which is why Base has such a bad reputation.


If you ever had created some relational database backend using any 
database specific, mature tool for the database, you would acknowledge 
how straight-forward Base connects your database with this office suite.


Simply do your database with a database program. Base is not a database 
program.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Tom Davies]

Hi :)
A big
+1
Regards from
Tom :)


--- On Wed, 1/2/12, Pertti Rönnberg  wrote:

From: Pertti Rönnberg 
Subject: Re: [libreoffice-users] Re: How get LibreO-Base working?
To: users@global.libreoffice.org
Cc: "Alex Thurgood" 
Date: Wednesday, 1 February, 2012, 18:36

All of you.
Thanks very much for your kindness to bother answering - and for the very 
interesting discussions.

My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps will not 
be as mentioned in the desciption at LO-Wikipedia: "A database management 
program , similar to 
Microsoft Access ..  etc" .
Its really pity because I think the usability of databases is underrated; quite 
ordinary people should have plenty of use of databases in their every day life 
if there only were free, easy installed, easy customized templates and some 
efforts on marketing. I just got a fancy idea that LO-/OO-Base could be that 
user-friendly solution.
Anyway, I still feel it worth trying to see if there should be a way to get my 
32bit LO-Base working!

I agree. I am a 72 years "oldtimer" with a pure interest to keep up. When in 
office until about 10 years ago I worked quite a lot with MSAccess and VBA & 
macros and got somewhat familiar with SQL too. MSAccess alone was enough for 
quite complicated projects with informative forms/reports and analyses.
So now it is not the MySQL/SQLite, it is the PHP-language and getting the 
MySQL/PHP/Apache combination working that I feel uncomfortable - I also have 
tried WASP.
Again - thanks and all the best!
Pertti Rönnberg


On 1.2.2012 9:43, Alex Thurgood wrote:
> Le 31/01/2012 22:07, Andreas Säger a écrit :
> 
> Hi Andreas,
> 
>> Am 31.01.2012 20:16, Alexander Thurgood wrote:
>>> 
>>> Yes, the dependency on Java JRE/JDK is a pain in the backside, but
>>> unfortunately unavoidable if you want to use Base, at least for the time
>>> being.
>>> 
>> 
>> With no Java being installed, I can connect a Base document to any
>> non-Java database, write queries, draw input forms and use Calc as
>> reporting engine.
>> 
>> 
> 
> And I would state that that is an "unusual" user setup. The user here wants a 
> relational database with subforms and reports and does not want to use mysql, 
> so where does that leave him her with regard to Base - IMO, with HSQLDB, the 
> stock db engine provided with LO. For that, you need a JRE/JDK.
> 
> And Calc for reports is OK, much as is Writer, but for anything a bit more 
> than a simple report, the user will have to deal with not only the 
> idiosyncrasies of the respective tool used for creating the report, plus, in 
> general, learn to use macros. The whole benefit of having a specific 
> reporting tool (the Java based ORB extension) is that this is suppose to ease 
> that pain.
> 
> Personally, I'd love to be able to say, you get a great and easy to use db 
> reporting engine without Java in LO, but that is simply not the case at the 
> moment.
> 
> 
> Alex
> 
> 


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How get LibreO-Base working?

[Pertti Rönnberg]

All of you.
Thanks very much for your kindness to bother answering - and for the 
very interesting discussions.


My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps 
will not be as mentioned in the desciption at LO-Wikipedia: "A database 
management program 
, similar to 
Microsoft Access ..  etc" .
Its really pity because I think the usability of databases is 
underrated; quite ordinary people should have plenty of use of databases 
in their every day life if there only were free, easy installed, easy 
customized templates and some efforts on marketing. I just got a fancy 
idea that LO-/OO-Base could be that user-friendly solution.
Anyway, I still feel it worth trying to see if there should be a way to 
get my 32bit LO-Base working!


I agree. I am a 72 years "oldtimer" with a pure interest to keep up. 
When in office until about 10 years ago I worked quite a lot with 
MSAccess and VBA & macros and got somewhat familiar with SQL too. 
MSAccess alone was enough for quite complicated projects with 
informative forms/reports and analyses.
So now it is not the MySQL/SQLite, it is the PHP-language and getting 
the MySQL/PHP/Apache combination working that I feel uncomfortable - I 
also have tried WASP.

Again - thanks and all the best!
Pertti Rönnberg


On 1.2.2012 9:43, Alex Thurgood wrote:

Le 31/01/2012 22:07, Andreas Säger a écrit :

Hi Andreas,


Am 31.01.2012 20:16, Alexander Thurgood wrote:


Yes, the dependency on Java JRE/JDK is a pain in the backside, but
unfortunately unavoidable if you want to use Base, at least for the 
time

being.



With no Java being installed, I can connect a Base document to any
non-Java database, write queries, draw input forms and use Calc as
reporting engine.




And I would state that that is an "unusual" user setup. The user here 
wants a relational database with subforms and reports and does not 
want to use mysql, so where does that leave him her with regard to 
Base - IMO, with HSQLDB, the stock db engine provided with LO. For 
that, you need a JRE/JDK.


And Calc for reports is OK, much as is Writer, but for anything a bit 
more than a simple report, the user will have to deal with not only 
the idiosyncrasies of the respective tool used for creating the 
report, plus, in general, learn to use macros. The whole benefit of 
having a specific reporting tool (the Java based ORB extension) is 
that this is suppose to ease that pain.


Personally, I'd love to be able to say, you get a great and easy to 
use db reporting engine without Java in LO, but that is simply not the 
case at the moment.



Alex





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How get LibreO-Base working?

[Andreas Säger]

Am 01.02.2012 08:43, Alex Thurgood wrote:


And I would state that that is an "unusual" user setup. The user here
wants a relational database with subforms and reports and does not want
to use mysql, so where does that leave him her with regard to Base -
IMO, with HSQLDB, the stock db engine provided with LO. For that, you
need a JRE/JDK.



And we all know why one must not use the built-in HSQLDB for productive 
databases. The so called "Base document" with its built-in HSQLDB is the 
most horrible face-palm feature since OOo 2.0.



And Calc for reports is OK, much as is Writer, but for anything a bit
more than a simple report, the user will have to deal with not only the
idiosyncrasies of the respective tool used for creating the report,
plus, in general, learn to use macros. The whole benefit of having a
specific reporting tool (the Java based ORB extension) is that this is
suppose to ease that pain.

I hardly ever use any macros at all. I simply use Calc's database ranges 
with registered data sources as they are intended to be used.
Without a single line of macro code I open a document through a 
hyperlink button on a form, confirm a dialog to refresh unsaved import 
ranges and get a brand new collection of nicely formatted reports and 
charts.



Personally, I'd love to be able to say, you get a great and easy to use
db reporting engine without Java in LO, but that is simply not the case
at the moment.

Calc provides all kinds of calculations and charting based on 
dynamically changing import ranges (much better than with spreadsheet 
data). Data pilots provide a second type of database report.
Things do simply *work* with Calc as report engine. If things really 
*work*, I don't care too much about the perfect look.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[Andreas Säger]

Am 28.01.2012 17:46, sonic wrote:


Dear Tom,
yes my problem is after i using spreadsheet creating a data table ,however than 
registered in data source,
now i wan make an easy ways if i wan to edit the data which in table but 
already  registered in data source, but i got no ways to edit the data table in 
the data source , how to do it without opening librercalc and reedit the table 
on the spreadsheet and redo the registered in data source.


Your data are still in the spreadsheet, editable in a spreadsheet program.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LWP documents

[Paul D. Mirowsky]

KeyView for Lotus is a WordPro document viewer.

It is probably Windows only, but might work under WINE if you are on linux.
NOTE: originally designed for Win95/3.1 (google to find out more)

ftp://ftp.lotus.com/pub/lotusweb/product/smartsuite/

Download file: Kvlotus.exe

Check that it will work with your documents and that they will look 
correct when printed.


If they do, output files as PDF as they are for reference only.
DO NOT GET RID OF LWP ORIGINALS.The day may come when that import 
filter will become totally correct.


If you can write script, do a directory crawl with print attribute to pdf.

Hope this helps.

PS: Google docs imports PDF and export ODF.

On 1/26/2012 6:30 PM, Gregory Forster wrote:
How do I open LotusWord Pro documents?  When I click on the document 
in Windows Explorer, I get a blank screen.  When I enter LibreOffice 
and open the document, I get a blank screen. In LibreOffice, I 
File/Open, change the file selection to Lotus WordPro document 
(*.lwp), select the file and still get a blank screen.


Greg



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[Andreas Säger]

Am 01.02.2012 05:21, NoOp wrote:


Your best bet is to simply use a Calc spreadsheet, open that with the
MailMerge Wizard, and go from there. With that you neither need Base or
Java.





As a matter of course, the wizard creates a Base document.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[Andreas Säger]

Am 28.01.2012 04:39, sonic wrote:

HI,
i'm facing a problem which doing mailmerge without using BASE to registered
to the data source.


This is impossible. Mail merge reads data from a registered Base file 
regardless of any file formats.
For various reasons, spreadsheets are by far the worst choice for list 
keeping. A most simple dBase file performs much better and can be edited 
directly in the data source window without opening nor saving any 
document at all.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LWP documents

[Gregory Forster]

On 2/1/2012 2:03 AM, Alex Thurgood wrote:

Le 27/01/2012 00:30, Gregory Forster a écrit :

Hi Gregory,


How do I open LotusWord Pro documents? When I click on the document in
Windows Explorer, I get a blank screen. When I enter LibreOffice and
open the document, I get a blank screen. In LibreOffice, I File/Open,
change the file selection to Lotus WordPro document (*.lwp), select the
file and still get a blank screen.


First, check that you do actually have the filters installed.
If you do a File > Open, do you see LWP in the list of available 
import filters ?


Second, the filters are not perfect, even when they are installed. 
Many LWP documents do not open correctly, if at all, especially if you 
have tables and/or inserted images in them. I have found that the 
filters only manage to successfully import the most simple of 
documents. Things with footers and headers tend to be misinterpreted 
or not represented.


Alex



I specifically filter for LWP files.  Thank you.

Greg

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LWP documents

[Gregory Forster]

On 1/31/2012 6:10 PM, NoOp wrote:

On 01/30/2012 02:11 PM, Gregory Forster wrote:

On 1/28/2012 1:10 AM, Jay Lozier wrote:

...

Can you post the file on nabble? A brief check indicates that *.lwp
files should open in LO/OOo.


I wasn't quite sure how to navigate nabble. I'm not talking of one file,
I'm talking of hundreds and hundreds of Lotus WordPro documents.  My
client's 3rd Lotus WordPro installation floppy disk corrupted, so he
cannot install his Lotus WordPro.  However, he wants to be able to
access his Lotus WordPro documents.  I understood by the advertising on
the LibreOffice web site that LibreOffice could read Lotus WordPro
documents, that it was a "new feature" for 3.4.5 It was also posted as a
"new feature" for3.3 I was just at the LibreOffice web site and since my
posting of this question, now the ability to read Lotus WordPro
documents is no longer there for 3.4.5, as well as being able to read
other types of documents.  However, under the new features of 3.3 IS the
ability to read Lotus WordPro documents.  So I downloaded the provided
sample.  LibreOffice read that sample fine, but still won't read true
LWP documents. I used 3.3 and downloaded and installed 3.4.5

I've no problem opening most lwp files in 3.3.3, 3.4.5, 3.5RC2 (linux).
However when I examine the files in a hex editor I see that they are
LWP7 versions. Samples that I tried (all work):

- Maps&  Scales

[note grapics show up only as blank frames, but text is fine]

- Networktest.lwp


Attachment 52242 in:
https://bugs.freedesktop.org/show_bug.cgi?id=41702
[Unteress_test.lwp]
only opens as a blank page&  perhaps this is what you are experiencing.
However when I look at the file in the hex editor, it is significantly
different than the LWP7 files tested above. It is missing the LWP7 header:

000: 576f 7264 5072 6f00      WordPro.
010: 4c57 5037        LWP7
020:      2e00  0009  
030: 1100 9e14 0107 0f00 2c0e 1f3c 0100 eb1c  ,..<
040:  1800 1600 576f 7264 2050 726f 2054  ..Word Pro T
050: 6578 7420 4669 6c65 2f44 4642 8900 9401  ext File/DFB

and instead shows:

000: 576f 7264 5072 6f0d fb00     WordPro.
010: 0005 985c 8172 0300 40cc c1bf ffbd f950  ...\.r..@..P
020: 9989 030a 00bc 1ad8 4e02 007a dcb4 d111  N..z
030:  0600 1600 5c79 2387 0c08 2872 de80  ..\y#...(r..
040: a052 060f 1d10 46d2 b029 f382 8811 214f  .RF..)!O

So is it possible that your clients files are too old?



That's VERY possible.  His, I believe, is from Windows 3.1.1

Greg

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[Alex Thurgood]

Le 01/02/2012 09:54, sonic a écrit :

Hi Sonic,


Currently i'm using Ubuntu 10.04 LTS
sorry i'm newbie in linux ubuntu very sorry about that ... for complaining a
problem


No problem, I didn't feel you were complaining, we just need to try and 
get to the bottom of the problem.


Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem pasting spreadsheet cells into Impress

[Tanstaafl]

On 2012-01-31 6:19 PM, TomW  wrote:

On 2012-01-31 06:42, Tanstaafl wrote:

On 2012-01-30 3:36 PM, Cor Nouws  wrote:

I tried in 3.4.5 and it works there fine too. Ctrl-V creates a nice
Impress-table with the content that I copy from Calc.



But... we don't want to convert the copied cells into an Impress Table
when pasting them, we want them to be an embedded 'spreadsheet', that
when double-clicked, allows you to edit it as if it was a spreadsheet.
This is how it used to work a long time ago - and how Microsoft Office
works by default.

I don't know which version/update changed this...

I'll have to find an example spreadsheet/Presentation that causes this
problem and file a bug and upload them to it...

Thanks for checking Cor...



Tanstaafl:

OOo 2.4.2 pastes as a calc8 file by default.
OOo 3.2.1 pastes as table of cells by default.


Hi Tom,

Thanks very much for looking at this, but a question to confirm...

It looks like you didn't check every version in between, just figured 
out that it changed somewhere between 2.4.2 and 3.2.1, correct?


Now, I guess the questions are, 1) what was the precise version where 
this behavior changed, 2) was the change intentional, and 3) if so, *why*.


Imho, the default behavior should mimic MSO (the most popular office 
package with the largest installed base, whether one likes it or not).


Cor? anyone? Should I just go file a bug?

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LWP documents

[Tom Davies]

Hi :)
Time to post a bug-report then, or use the existing one which seems to have got 
a bit muddled.  

In wikipedia i found there is apparently a LotusWord viewer, see bottom of
http://en.wikipedia.org/wiki/IBM_Lotus_Word_Pro
but if that only helps convert 1 doc at a time then it's pretty useless.  
Perhaps the link might be useful for the bug-report?

According to IBM their files 'should' open with no problems in MS Word
http://www-01.ibm.com/software/lotus/products/smartsuite/wordprofeatures.html
but i never believe anything big companies say until after trying it.  It's bad 
enough that a free product fails to deliver what it has apparently promised but 
paying too much money to buy something that also doesn't work would be the 
icing on the cake.  

If you are not able to try opening a lwp file in Word feel free to send me a 
private email with a copy of one of the documents that doesn't work in LO as i 
might be able to try it in Word 2007 and Word 2010 later today or tomorrow.  I 
still think it would be better to let the devs have a copy of at least 1 file 
that doesn't work as there is far more chance of them fixing the filter.  If it 
does open in MS Word then there might be a way to convert the documents in 
large batches.  

Regards from
Tom :)


--- On Wed, 1/2/12, Alex Thurgood  wrote:

From: Alex Thurgood 
Subject: [libreoffice-users] Re: LWP documents
To: users@global.libreoffice.org
Date: Wednesday, 1 February, 2012, 8:03

Le 27/01/2012 00:30, Gregory Forster a écrit :

Hi Gregory,

> How do I open LotusWord Pro documents? When I click on the document in
> Windows Explorer, I get a blank screen. When I enter LibreOffice and
> open the document, I get a blank screen. In LibreOffice, I File/Open,
> change the file selection to Lotus WordPro document (*.lwp), select the
> file and still get a blank screen.

First, check that you do actually have the filters installed.
If you do a File > Open, do you see LWP in the list of available import filters 
?

Second, the filters are not perfect, even when they are installed. Many LWP 
documents do not open correctly, if at all, especially if you have tables 
and/or inserted images in them. I have found that the filters only manage to 
successfully import the most simple of documents. Things with footers and 
headers tend to be misinterpreted or not represented.

Alex


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[sonic]

Hi Alex,
FYI, We also have been tested on 
LibreOffice 3.4.5
OOO340m1 (Build:502)
installer is download from www.libreoffice.org 
deb installer
now going to try RPM installer  
Currently i'm using Ubuntu 10.04 LTS
sorry i'm newbie in linux ubuntu very sorry about that ... for complaining a
problem


--
View this message in context: 
http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3705958.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[Alex Thurgood]

Le 01/02/2012 09:23, sonic a écrit :

Hi Sonic,


ALex,
hi are you refering to windows version or linux if windows version yes it's
working, but i'm using linux version is not working  ? LibreOffice 3.4.5
OOO340m1 (Build:502)


As I said in my mail "provided by Ubuntu", i.e. Linux version.

Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[sonic]

ALex,
hi are you refering to windows version or linux if windows version yes it's
working, but i'm using linux version is not working  ? LibreOffice 3.4.5
OOO340m1 (Build:502)


--
View this message in context: 
http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3705891.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Opening thunderbird adressbook

[Alex Thurgood]

Le 30/01/2012 20:03, NoOp a écrit :

I have downloaded the x86 DEB and will try it later.

However, I can already report that the Address Datasource Wizard also 
works for me in 3.4.5 on Ubuntu Oneiric with the Ubuntu supplied version 
of LO.


I can not see a TB/Mozilla addressbook in my list, but Evolution is 
there, as is access to other datasources.


Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LWP documents

[Alex Thurgood]

Le 27/01/2012 00:30, Gregory Forster a écrit :

Hi Gregory,


How do I open LotusWord Pro documents? When I click on the document in
Windows Explorer, I get a blank screen. When I enter LibreOffice and
open the document, I get a blank screen. In LibreOffice, I File/Open,
change the file selection to Lotus WordPro document (*.lwp), select the
file and still get a blank screen.


First, check that you do actually have the filters installed.
If you do a File > Open, do you see LWP in the list of available import 
filters ?


Second, the filters are not perfect, even when they are installed. Many 
LWP documents do not open correctly, if at all, especially if you have 
tables and/or inserted images in them. I have found that the filters 
only manage to successfully import the most simple of documents. Things 
with footers and headers tend to be misinterpreted or not represented.


Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted