Re: [users] MONTH type

[Brian Barker]

At 07:25 11/06/2010 -0500, Vic Dura wrote:

According the OOo 3.2.0 (WinXP) Help:

=
MONTHS
Calculates the difference in months between two dates.
Syntax
MONTHS(StartDate; EndDate; Type)
StartDate is the first date
EndDate is the second date
Type calculates the type of difference. Possible values include 0 
(interval) and 1 (in calendar months).

=

Could some kind soul explain the difference between "interval" and 
"calendar" months?  I don't know what the difference is.


A bit of experimentation suggests that the "interval" meaning counts 
days and increases the count on the same date in the following 
month.  So in "interval" months there are zero months from today (12 
June) until any date up to 11 July, but one month up to 12 July or 
thereafter, and so on.


Conversely, the "calendar months" meaning takes account only of the 
month of the date, not the day in that month, so there is one month 
from any date in June to any in July.  In particular, there are zero 
months from today (12 June) until any date up to 30 June, but one 
month up to 1 July or thereafter, and so on.  The difference between 
31 January and 1 February is one calendar month, even though it is 
only one day, and that between 31 January and 1 March is two calendar 
months, even though - at 29 days (except in a leap year) - it is 
shorter than most actual months.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Re: increased line spacing when applying bullets - why?

[NoOp]

On 06/10/2010 01:23 AM, Cor Nouws wrote:
> Hi all,
> 
> Maybe someone here knows why the line spacing is increased when  bullets 
> are applied?
> 
> Also when I give more line space, proportional, with different or larger 
> for, with other style (heading for example).
> Only when setting line spacing to fixed it does - of course - not change.
> 
> The properties in the bullets (list style), lead me to the character 
> style 'Numbering Symbols'.
> However, when, for example the paragraph style is 20 pts, and the 
> 'Numbering Symbols' is 12 pts, one would expect that there is room 
> enough for the bullets. No. Only when I set the 'Numbering Symbols' to 
> 10 pts, the line spacing stays unchanged.
> 
> Any idea? Thanks,
> Cor
> 
> 

I'm not sure that I understand. Attached is a small .odt with standard
bullets & and large bullet applied. Both appear to have the same line
spacing.




bullettest.odt
Description: application/vnd.oasis.opendocument.text
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[RA Brown]

Barbara Duprey wrote:

RA Brown wrote:

Barbara,

Great post.

I would like to see at least one other added: The ability to have text 
and spreadsheets in the same file.  Having the ability to store 
scanned and PDFs documents would be an even bigger plus.


Andy


Wow! You're right, all the same considerations apply. This might have to 
be "phase 2" of the project, though, because the operations on the 
different filetypes have such dissimilar interfaces and probably quite 
different code for some similar functions. It would almost certainly 
take a seriously hard look at modularity, winnowing out embedded 
assumptions about the context of operations. Certainly worth your adding 
this to the issue, though.




Hi Babara,

I agree that PDF would be dissimilar to the ODF files.  But the basic 
structure of odt and ods are the same.  There are some differences but I 
am not sure, at the time, that they can not be merged.


Andy

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[RA Brown]

openoffice.mbou...@spamgourmet.com wrote:

RA Brown - rabr...@the-martin-byrd.net wrote:



It is probably out on the limits of reason but I see it as a very
favorable feature.

For example, I have to deal with several related files of a large group
of people. A retirement facility that has state regulations that state
what forms have to be maintained. Some of these forms have to have
signature(s) on them. to store electronic copies these forms are scanned
into PDFs. Other forms use a spreadsheet to keep from having to
rewrite/retype the form. Letters are typed up for mailing to family
members, with copies retained for reference.

Currently I use a subdirectory for each "client" with all these
different files which use different applications to open/edit/print. If
the DOF standard were expanded to cover all these then I would only have
to deal with one application. As side effect is a self-creating archive
that could be stored without having to pack/zip all the files.


But that one application would have to be able to handle every 
conceivable file type, which no application is ever going to be able to 
do itself. It would still have to call on separate applications to do 
anything with the documents.


It seems to me that your current solution is exactly what subdirectories 
are for - storing a collection of related documents, possibly in 
different formats. If you need to pack them into a single file, e.g. to 
send to someone else, why not just use a format designed to do just 
that, like zip?




Hi Mark,

I can see the problem of adding the PDF features as that is a total 
different file structure.  Having both text and spreadsheet documents in 
the same file looks very reasonable, so far.  I am looking at 
information related to the ODF file structures.  As I stated before the 
odt and ods files are only containers, zipped, of the real files.  Most 
of the actual files are xml files, contents.xml is the one that has the 
data to be displayed, the others  contain instructions on _how_ to 
display the data.


Andy

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Barbara Duprey]

Dotan Cohen wrote:

On 11 June 2010 17:44, Barbara Duprey  wrote:
  

Wow! You're right, all the same considerations apply. This might have to be
"phase 2" of the project, though, because the operations on the different
filetypes have such dissimilar interfaces and probably quite different code
for some similar functions. It would almost certainly take a seriously hard
look at modularity, winnowing out embedded assumptions about the context of
operations. Certainly worth your adding this to the issue, though.




Actually, I think that it should be a separate issue. It's related,
but it would be a hijack for sure.


Maybe an RFE that calls out your RFE as prereq?

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Re: what newsgroup would you suggest for talking about python scripst for open office?

[NoOp]

On 06/10/2010 08:49 PM, John Kaufmann wrote:
> Cor,
> 
> In a message dated 2010.06.10 18:02 -0500, Cor Nouws wrote:
> 
>>> I just wanted to be sure, that this is the right group for discussing
>>> python scripts for open office.  ...
>> 
>> I would suggest d...@api.openoffice.org for your subject.
> 
> Thanks for providing that. [I'm constantly surprised at the scope of the 
> OpenOffice project.]  More generally, where can one find a listing of 
> such lists?
> 
> John

Try:
http://projects.openoffice.org/index.html
Each project will typically have a mail list.
Example:
http://api.openoffice.org/
Left side: Mailing lists
http://api.openoffice.org/servlets/ProjectMailingListList

Also:
http://www.openoffice.org/mail_list.html



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[openoffice . mbourne]

RA Brown - rabr...@the-martin-byrd.net wrote:

Kevin Reynolds wrote:

I don't know if it's a reasonable statement from anyone's point of
view but it sure is an outstanding one!

Here here!



Hi Kevin,

It is probably out on the limits of reason but I see it as a very
favorable feature.

For example, I have to deal with several related files of a large group
of people. A retirement facility that has state regulations that state
what forms have to be maintained. Some of these forms have to have
signature(s) on them. to store electronic copies these forms are scanned
into PDFs. Other forms use a spreadsheet to keep from having to
rewrite/retype the form. Letters are typed up for mailing to family
members, with copies retained for reference.

Currently I use a subdirectory for each "client" with all these
different files which use different applications to open/edit/print. If
the DOF standard were expanded to cover all these then I would only have
to deal with one application. As side effect is a self-creating archive
that could be stored without having to pack/zip all the files.


But that one application would have to be able to handle every 
conceivable file type, which no application is ever going to be able to 
do itself. It would still have to call on separate applications to do 
anything with the documents.


It seems to me that your current solution is exactly what subdirectories 
are for - storing a collection of related documents, possibly in 
different formats. If you need to pack them into a single file, e.g. to 
send to someone else, why not just use a format designed to do just 
that, like zip?




Another place this would seem to be useful is electronic medical
records. I need more work on this before I can say for sure though.

Andy


Mark.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] How to get back old icons after reinstalling 3.2.0

[openoffice . mbourne]

Cor Nouws - oo...@nouenoff.nl wrote:

[ from branding list ]

Cor Nouws wrote (10-06-10 16:34)

Tanstaafl wrote (10-06-10 16:19)


I would still like to know how to bring back the old icons on the one
system I have in my office that I installed 3.2.1 on that still has the
new icons.


I have no windows system at hand atm.
Will follow up later on users@ (cc-ing you)


And now I even have to say that I'm not good enough on windows...
On my linux installation I can find the icons.

The installation is
\program files\OpenOffice.org\
\program files\OpenOffice.org3\

If the icons of 3.2.1 remain after removing it and installing 3.2.0,
then there will probably remain some files after uninstalling 3.2.1
Look at the locations I mentioned at that moment, and simply remove
before installing 3.2.0

On the other hand: there might well be a smart windows user here that
knows where the icons are in the isntallation.

HTH, best,
Cor


Application shortcut and file association icons on Windows are usually 
resources embedded in the application executable or a DLL. (They are 
very rarely distributed as separate .ico files)


In the case of OpenOffice.org 3.2.0 (and I'd assume also 3.2.1), the 
file association icons appear to be in:

  \program\soffice.exe
and the application shortcut icons in each separate component's .exe:
  \program\swriter.exe
  \program\scalc.exe
  etc.

When you set an icon for a shortcut or file association, set the .exe as 
the file to look for icons in, and you will see all the icons embedded 
in it to choose from.


Mark.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Dotan Cohen]

On 11 June 2010 17:44, Barbara Duprey  wrote:
> Wow! You're right, all the same considerations apply. This might have to be
> "phase 2" of the project, though, because the operations on the different
> filetypes have such dissimilar interfaces and probably quite different code
> for some similar functions. It would almost certainly take a seriously hard
> look at modularity, winnowing out embedded assumptions about the context of
> operations. Certainly worth your adding this to the issue, though.
>

Actually, I think that it should be a separate issue. It's related,
but it would be a hijack for sure.


-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Re: Flash Cards

[NoOp]

On 06/11/2010 05:24 AM, Mark C. Miller wrote:
> I've checked the extensions repository without any luck; I's hoping that 
> one of you may have had cause to build something like this.
> 
> I'm preparing a study program for High School Juniors covering the top 
> 100 vocabulary words.
> 
> The recommended way to study vocab is the good old fashioned flash card.
> 
> I'd like to come up with an electronic version.  I had a MS Power Point 
> template back when that was my software of choice but nothing for 
> Impress.  The computer I use for presentations is Ubuntu, so I need 
> something for OOo Impress.
> 
> I'm not smart enough to build such a thing on my own.  It would be one 
> "3X5" slide with the vocab word; when you click on it, it would move to 
> a second "3X5" slide with the definition and example sentence.
> 
> Anyone have such a thing or perhaps can point me toward a site tht would 
> help me?  I've looked through the documentation book I have and didn't 
> have any success.
> 
> I'm running 3.2 on Ubuntu UNR 10.04.
> 
> Thanks for any help you can provide.
> 

Perhaps:


Haven't tried it, but sounds interesting:
http://www.opencards.info/
http://www.opencards.info/index.php/oc-download



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Re: Re: What is the use of the envelope style?

[Twayne]

Hi John,

00.0 3.2.0 and 3.2.1 and 2.4.?:
Sorry if i underestimated your expertise level; it's hard to tell sometimes
so I err of the safest side as a rule, or try to anyway.


 I made a few comments inline:

In news:4c11af69.6070...@nb.net,
John Kaufmann  typed:
> Hi Twayne,
>
> In a message dated 2010.06.10 18:59 -0500, Twayne wrote:
>
>> Where is the envelope "style" found? I just looked at "all
>> styles" and none are for envelopes.
>
> Stylist (F-11), under the Page styles.

Understood. The Styles & Format dialog.

>
>> It makes sense that there may be one though.
>
> Well, yes but... conceptually (from style class design)
> "Envelope" is a tough fit to the Page styles: the only
> attributes they really share are that they are
> 2-dimensional and printed. [In fact, that tough fit may be
> an underlying design issue.]

Yeah my list doesn't include anything about envelopes. That
makes me pretty curious but I suppose it would if I purposely saved them as
a style, but I don't see the need. Once you get it started, swtch to Format; 
Page; to get better control of the parameters you want to tweak. IMO anyway.



>>> According to the Stylist, the page style becomes
>>> "Envelope" after an envelope is formed from the
>>> Insert|Envelope wizard

That hasn't happened here; I'll have to have a look at Options and see if
there's something there to explain it. I'm curious, that's all.

>>
>> Correct. Insert; Envelop should also open a dialog window
>> where in one of its tabs you can set things such as
>> return/recipient address, database info and either add the
>>envelope to the document or create just the envelope.
>> Then in the second tab, Format, you have the dimensions
>> and location of  the envelope within the scope of the paper size you're
>> using. Then the third tab is for your printer, which way
>> to place the invelope into the tray, and any offset you
>> might need to use to tweak the position.
>
> Yes, of course I know all that.  The point, though, is that
> after you do that, Writer also assigns the page style
> "Envelope" to the result - even though it has nothing to do
> with what you just set up under the Format tab.

That is curious;  that doesn't happen here. I just tried it by
creating an ipso factum... page with an envelope inserted intto the document 
and saved them to
disk. Closed/reopened OO.o Writer and checked F11: Still no envelope entry 
in the list. Didn't do a Restart, but I don't see where it'd matter to 
anything.

>
>> OO.o used a strange methodology for setting up its
>> envelopes so it takes a little study as to how to use the dimensions and
>> offsets ... See the Documentation entries at OO.o for more on
>> envelopes.
>
> Yes, I thought i made it clear that I have studied the
> documentation wiki (and the Help, of course) pretty thoroughly before
> asking the question - and no two of those three sources -
> Help, FAQ and Writer Guide - agree on how envelopes should be done!

There is one that is a set of various envelope templates which you can 
download somewhere on OO.o. If you can find that one, or someone could point 
us to it, there might be explanatories there. IIRC they worked on my inkjet 
but I never tried any of them on the laserjet.

Actually, while I'm thinking of it, there are some errors in the F11 list, 
too. Like, I'd expect Signature to right-align, but it doesn't. There's more 
than a few of them actually.

>
>
>>> - but the page style apparently has no connection to what
>>> was defined in the Envelope wizard.


Yeah, unless it had something like #10 as part of the name, I don't know 
that you could trust what it might indicate anyway unless for you it opens 
the Insert Envelope dialog box for you.

>>
>> I -think- what you mean here is what I meant above when I
>> said OO.o has a completely different, non-user-friendly way of creating
>> envelopes.
>
> Well, that's already a pretty damning statement - but
> actually what I meant was that the Format settings from the
> Insert|Envelope command are different from those in the
> Envelope page style which is also invoked by the
> Insert|Envelope command.  In fact, not only are the
> settings different, they are drawn from different source
> lists!  I can't imagine why that is, and was hoping someone
> on the list knew.

Perhaps it's named envelope but isn't what you're calling envelope right 
now?? Naming things can get confusing at times.

>> It does seem like it's not related at all and gives what
>> seems to be pretty odd results. It's frustrating and quite annoying to
>> try to design envelopes for anything but the #10 sample exactly
>> as presented. Change ANYthing about it, and it seems to go
>> all to hell on you.
>
> That should not be, and is what I'm ultimately trying to
> overcome.

IMO, forget the F11 access and just stick to the Insert; Envelope; method. 
Notiice where the vertical and horizontal references are for the dimensions, 
and empirically work out what each dimension actually does for 

Re: [users] Multiple "sheets" in Writer

[RA Brown]

Uwe Fischer wrote:

On 06/11/10 03:42, RA Brown wrote:

Barbara Duprey wrote:


Besides improving efficiency for the document owner, an advantage to 
this structure is that the recovery information tracks together for 
all the documents, making it less likely that they will get out of 
sync by being restored to different points in your workflow.





Barbara,

Great post.

I would like to see at least one other added: The ability to have text 
and spreadsheets in the same file.  Having the ability to store 
scanned and PDFs documents would be an even bigger plus.


Andy


Hi,
if you replace "file" with "folder", it looks like everything is already 
there.
Just don't use the one and only "My Documents" folder for all your 
documents, but instead create a dedicated folder (may be with 
subfolders) for every project that needs multiple files. You can easily 
select several or all files from your operating system file manager, 
then print or open them.


Regards
Uwe


Hi Uew,

Your idea is the way it works now.  I just think it would be very useful 
to have everything in one "file" and use one application for everything. 
 I use OO.o for spreadsheet and text documents, gscan2pdf for scanning 
and pdf editor for editing PDF forms.  How much easier it would be to 
have everything in one place.


--
Andy Brown
La Mesa, CA  91942
www.the-martin-byrd.net/openoffice.org.html
OpenOffice.org Community Distributor
CD/OEM Distribution Project member
Documentation Project member
Marketing Project member
User Experience Project member

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Barbara Duprey]

RA Brown wrote:

Barbara Duprey wrote:


Instead of focusing on parallels to Calc, let's think instead about 
this:


   * You have a "family" of text documents, all related to the same
 overall function.
   * The documents are fully independent of each other for such things
 as styles, page numbering, layout, and so on.
   * When something causes you to want to edit or refer to one of these
 documents, chances are high that your requirement extends also to
 the other documents in the family.
   * Currently, each of these documents has a different name, and you
 open each in a separate window to achieve your objective.
   * The proposal is to allow the documents to retain their
 independence, but be contained in a single file that can be opened
 with one action and makes the individual documents readily
 accessible from each other to streamline the updating and/or
 referencing activities you need to perform.
   * When you have accomplished your task, you currently close each
 document separately. With the new structure, a single action
 closes all the documents.

Besides improving efficiency for the document owner, an advantage to 
this structure is that the recovery information tracks together for 
all the documents, making it less likely that they will get out of 
sync by being restored to different points in your workflow.


Dotan, is this a reasonable statement of your intent here?



Barbara,

Great post.

I would like to see at least one other added: The ability to have text 
and spreadsheets in the same file.  Having the ability to store 
scanned and PDFs documents would be an even bigger plus.


Andy


Wow! You're right, all the same considerations apply. This might have to 
be "phase 2" of the project, though, because the operations on the 
different filetypes have such dissimilar interfaces and probably quite 
different code for some similar functions. It would almost certainly 
take a seriously hard look at modularity, winnowing out embedded 
assumptions about the context of operations. Certainly worth your adding 
this to the issue, though.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Is the install of Ooo 3.2.1 incredibly slow?

[Rob Clement]

On 11/06/2010 13:20, webmas...@krackedpress.com wrote:

On 06/11/2010 07:43 AM, Tanstaafl wrote:

On 2010-06-10 7:33 PM, Twayne wrote:

In news:4c094ddd.70...@silkroadconsultants.co.uk,
Rob Clement typed:

Is it just my machine AMD 2.0 Ghz running windows Vista
seems to take a very long time installing Ooo 3.2.1.

Well, yes, it is, and err, no, it is not. You have to remember that
you're
installing a pretty large and complex program with OO.o.

For me it is not any slower than any previous version of OOo was at
installing, but I've only installed it once (and uninstalled a few hours
later because of the icons)...


I have a laptop running Vista and moving from 3.2.0 to 3.2.1
did not make the opening or running of OOo any slower.

You may want to try a "cleaner" software and see if your system has
errors or other stuff
that is causing that problem. I normally find that after an install, my
system needs a cleaning
of the registry for errors and other stuff that gets messed up or added
that needs to be resolved.

http://www.iobit.com/download.html#freesoftware

I would go to this site and download the Advanced SystemCare Free and
the Smart Defrag [free]
software. The first one finds and corrects errors, but uncheck the disk
defrag option. Then use
the Smart Defrag to keep your drives defraged and optimized. I install
these two on all the Windows
computers I work on.

Doing this helps make the computers in the computer center run faster
after all the crap that
the users leave after a few days. You would be surprised at what it finds.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


If you look at the original question it was about the install and not 
opening or running.


Personally I have used Piriform software for a while. Ccleaner (to clean 
out rubbish and sort out the registry) and defraggler to defrag my hard 
drive. They also have two other utilities speccy for system 
specification and Recuva to recover deleted files


Thanks

Rob

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Flash Cards

[Daniel Lewis]

Mark C. Miller wrote:
I've checked the extensions repository without any luck; I's hoping 
that one of you may have had cause to build something like this.


I'm preparing a study program for High School Juniors covering the top 
100 vocabulary words.


The recommended way to study vocab is the good old fashioned flash card.

I'd like to come up with an electronic version.  I had a MS Power 
Point template back when that was my software of choice but nothing 
for Impress.  The computer I use for presentations is Ubuntu, so I 
need something for OOo Impress.


I'm not smart enough to build such a thing on my own.  It would be one 
"3X5" slide with the vocab word; when you click on it, it would move 
to a second "3X5" slide with the definition and example sentence.


Anyone have such a thing or perhaps can point me toward a site tht 
would help me?  I've looked through the documentation book I have and 
didn't have any success.


I'm running 3.2 on Ubuntu UNR 10.04.

Thanks for any help you can provide.

 It sounds like you need to work with custom animation. Other than 
this statement, I don't know much more about it.


Dan

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] MONTH type

[Uwe Fischer]

On 06/11/10 14:25, Vic Dura wrote:

Hello,

According the OOo 3.2.0 (WinXP) Help:

=
MONTHS
Calculates the difference in months between two dates.
Syntax
MONTHS(StartDate; EndDate; Type)
StartDate is the first date
EndDate is the second date
Type calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).
=

Could some kind soul explain the difference between "interval" and
"calendar" months?  I don't know what the difference is.

Thanks



Thank you for using the Help.
In the Wiki at 
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MONTHS_function 
you can find a much improved version by OO.o user Drking.

May be this helps.

Regards
Uwe
--
  uwe.fisc...@sun.com  -  Technical Writer
  Sun Microsystems, Hamburg, Germany
  http://documentation.openoffice.org/
  http://wiki.services.openoffice.org/wiki/Documentation
  http://blogs.sun.com/oootnt
  http://user.services.openoffice.org/en/forum


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Remove outline from textbox

[John Kaufmann]

In a message dated 2010.06.06 12:29 -0500, Dotan Cohen wrote:


... On the Formatting toolbar, there is neither a Bullet List
icon nor can one be added from the Visible Icons list.


View|Toolbars|tick 'Text Formating'


Thanks. To be honest, of all the things that I tried I hadn't tried
to add any other toolbars. I thought that toolbars are shortcuts to 
functionality in the menus. I thought wrong!


I had been under the same misapprehension, because apps originally 
shared that philosophy as we moved into the GUI world.  As I prefer to 
keep my hands on the keyboard and avoid mice whenever possible, it 
was/remains one of my stumbling blocks with OO.  FWIW.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[John Kaufmann]

In a message dated 2010.06.11 05:35 -0500, Uwe Fischer wrote:

[Numbering in brackets added to clarify reply]

Barbara Duprey wrote:

...
[1] You have a "family" of text documents, all related to the same
 overall function.
[2] The documents are fully independent of each other for such things
 as styles, page numbering, layout, and so on.
[3] When something causes you to want to edit or refer to one of these
 documents, chances are high that your requirement extends also to
 the other documents in the family.
[4] Currently, each of these documents has a different name, and you
 open each in a separate window to achieve your objective.
[5] The proposal is to allow the documents to retain their
 independence, but be contained in a single file that can be opened
 with one action and makes the individual documents readily
 accessible from each other to streamline the updating and/or
 referencing activities you need to perform.
[6] When you have accomplished your task, you currently close each
 document separately. With the new structure, a single action
 closes all the documents.

Besides improving efficiency for the document owner, an advantage to 
this structure is that [7] the recovery information tracks together 
for all the documents, making it less likely that they will get out 
of sync by being restored to different points in your workflow.



On 06/11/10 03:42, RA Brown wrote:

[8] I would like to see at least one other added: The ability to
have text and spreadsheets in the same file.
[9] Having the ability to store scanned and PDFs documents would be
an even bigger plus.


if you replace "file" with "folder", it looks like everything is 
already there. ...


Uwe, that not quite true.  Dotan can answer for his own proposal [and 
has, I see], but the single folder does not address points [4]..[7] of 
Barbara's summary, and of course does not [8]..[9] of Andy's add-on, 
which go beyond Dotan's original suggestion.


Clearly these are enhancements, not bug issues.  From an application 
programmer's standpoint, you may think, 'That's system programming, for 
OS functions,' but those lines get fuzzed all the time, for just such 
functional considerations as described here.  FWIW, I think a good case 
has been made, and we will see this somewhere in the future; it's just a 
question of whether OO will be the first.


John

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] MONTH type

[Vic Dura]

Hello,

According the OOo 3.2.0 (WinXP) Help:

=
MONTHS
Calculates the difference in months between two dates.
Syntax
MONTHS(StartDate; EndDate; Type)
StartDate is the first date
EndDate is the second date
Type calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).
=

Could some kind soul explain the difference between "interval" and
"calendar" months?  I don't know what the difference is.

Thanks
-- 
At first they laugh at you, then they ignore you, then they fight you, then you 
win.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Flash Cards

[Mark C. Miller]

I've checked the extensions repository without any luck; I's hoping that 
one of you may have had cause to build something like this.


I'm preparing a study program for High School Juniors covering the top 
100 vocabulary words.


The recommended way to study vocab is the good old fashioned flash card.

I'd like to come up with an electronic version.  I had a MS Power Point 
template back when that was my software of choice but nothing for 
Impress.  The computer I use for presentations is Ubuntu, so I need 
something for OOo Impress.


I'm not smart enough to build such a thing on my own.  It would be one 
"3X5" slide with the vocab word; when you click on it, it would move to 
a second "3X5" slide with the definition and example sentence.


Anyone have such a thing or perhaps can point me toward a site tht would 
help me?  I've looked through the documentation book I have and didn't 
have any success.


I'm running 3.2 on Ubuntu UNR 10.04.

Thanks for any help you can provide.

--

Mark C. Miller
eyor...@comcast.net


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Re: (slightly) off topic: the old Sun ODF pluging

[Uwe Brauer]

> On Fri, 11 Jun 2010 12:06:32 +0100, "Gordon"  wrote:

   > "Uwe Brauer"  wrote in message
   > news:87bpbhc0wj@mat.ucm.es...
   >> 
   >> thanks
   >> 
   >> Uwe Brauer

   > Try this:
   > http://cid-e60ce3038809e993.office.live.com/browse.aspx/ODF%20Plugin
cool thanks

Uwe 
   > :-)


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Is the install of Ooo 3.2.1 incredibly slow?

[webmas...@krackedpress.com]

On 06/11/2010 07:43 AM, Tanstaafl wrote:

On 2010-06-10 7:33 PM, Twayne wrote:
   

In news:4c094ddd.70...@silkroadconsultants.co.uk,
Rob Clement  typed:
 

Is it just my machine AMD 2.0 Ghz running windows Vista
seems to take a very long time installing Ooo 3.2.1.
   
   

Well, yes, it is, and err, no, it is not. You have to remember that you're
installing a pretty large and complex program with OO.o.
 

For me it is not any slower than any previous version of OOo was at
installing, but I've only installed it once (and uninstalled a few hours
later because of the icons)...
   


I have a laptop running Vista and moving from 3.2.0 to 3.2.1
did not make the opening or running of OOo any slower.

You may want to try a "cleaner" software and see if your system has 
errors or other stuff
that is causing that problem.  I normally find that after an install, my 
system needs a cleaning
of the registry for errors and other stuff that gets messed up or added 
that needs to be resolved.


http://www.iobit.com/download.html#freesoftware

I would go to this site and download the Advanced SystemCare Free and 
the Smart Defrag [free]
software.  The first one finds and corrects errors, but uncheck the disk 
defrag option.  Then use
the Smart Defrag  to keep your drives defraged and optimized.  I install 
these two on all the Windows

computers I work on.

Doing this helps make the computers in the computer center run faster 
after all the crap that

the users leave after a few days.  You would be surprised at what it finds.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OO 3.0 (Ubuntu) does not export notes to PDF

[webmas...@krackedpress.com]

On 06/11/2010 06:54 AM, Nicholas wrote:

Uwe,


Export to PDF with notes is working for OOo3.1.1 on Ubuntu 9.10.


When I use Okular/Acroead, I see a small note icon. Place cursor on 
this icon and the notes appear.




Uwe Brauer wrote:


Hello

I am not sure to submit a bug report but I can't export
notes to pdf. I inserted notes with alt-control N, I specify
when exporting to pdf include notes, but then neither in
xpdf nor in foxit reader these notes appear.

Can somebody confirm this please?

regards

Uwe Brauer



Would "notes" be termed hidden text?  In the 
Tools/options/...Writer/Print there are check
options for what you want to print and/or how you want it to print or 
look like.  Hidden Text is
one of those options.  Try checking it and Export your document to see 
it that works.


If that does not work . . . . . .

Maybe you should try printing to PDF, instead of Exporting.  I never [ 
99.99%] export to a PDF,

I use a PDF printer.

I just installed the CUPS PDF printing option in Ubuntu.  Did that for 
9.04, 9.10, and then 10.04.
Then all you need to do is use that instead of an inkjet or laser 
printer.  The only thing that I do
no like is that the output goes to a PDF folder instead of asking you 
where the file should be saved.


For Windows, I install doPDF as the free PDF printer.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] increased line spacing when applying bullets - why?

[John Kaufmann]

In a message dated 2010.06.11 00:20 -0500, Jean-Baptiste Faure wrote:


Perhaps a problem with the size of bullets. If you play with the
character style "bullet", e.g by changing the size font, you modify the
line spacing. If it is a problem I think it is in OpenSymbol.


Yes, that's what Cor was wondering in his original post: If the nominal 
point size for the bullets is greater than exactly half the point size 
of the text [for example: text size 20, bullet size anything greater 
than 10], then the line spacing is increased.  It certainly sounds like 
an OpenSymbol bug to me, but can't say for sure. I think that was Cor's 
question.


John

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Is the install of Ooo 3.2.1 incredibly slow?

[Tanstaafl]

On 2010-06-10 7:33 PM, Twayne wrote:
> In news:4c094ddd.70...@silkroadconsultants.co.uk,
> Rob Clement  typed:
>> Is it just my machine AMD 2.0 Ghz running windows Vista
>> seems to take a very long time installing Ooo 3.2.1.

> Well, yes, it is, and err, no, it is not. You have to remember that you're 
> installing a pretty large and complex program with OO.o.

For me it is not any slower than any previous version of OOo was at
installing, but I've only installed it once (and uninstalled a few hours
later because of the icons)...

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Dotan Cohen]

On 11 June 2010 12:35, Uwe Fischer  wrote:
> Hi,
> if you replace "file" with "folder", it looks like everything is already
> there.
> Just don't use the one and only "My Documents" folder for all your
> documents, but instead create a dedicated folder (may be with subfolders)
> for every project that needs multiple files. You can easily select several
> or all files from your operating system file manager, then print or open
> them.
>

Thank you Uwe, I don't even have a My Documents folder! I do sort into
folders, but often I need associated files together.

An example might be load testing metals. A lab that I support might
load samples from three different vendors. The technician will need to
access those three files together with associated paperwork from the
government. He would much rather have to open two files (one for the
sample results and one for the government qa paperwork) that are in
the same folder than have to open six files spread out across three
folders (one folder for the samples, one for the paperwork, and
another to house them both).


-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Dotan Cohen]

On 11 June 2010 04:47, Kevin Reynolds  wrote:
> I don't know if it's a reasonable statement from anyone's point of
> view but it sure is an outstanding one!
>
> Here here!
>

Go vote for that bug. Sun didn't pay much attention to votes on bugs,
but Oracle (At least for their business users) may be different.
Thanks!

-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Dotan Cohen]

On 11 June 2010 04:42, RA Brown  wrote:
> I would like to see at least one other added: The ability to have text and
> spreadsheets in the same file.  Having the ability to store scanned and PDFs
> documents would be an even bigger plus.
>

That would depend on a single OOo window for all components, no
separate word processor, spreadsheet, or presentation components. I
think that the IBM office suit works like this. It might be a good, if
unrelated, idea. But until there is a unified interface, i don't see
how there would be a single file with spreadsheet and word processor
components.

Thank said, I _really_ like the idea, and it would save me tons of
hassle. Almost all of my research have word processor and spreadsheets
file, I would find this feature _very_ useful.

-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Re: (slightly) off topic: the old Sun ODF pluging

[Gordon]

"Uwe Brauer"  wrote in message 
news:87bpbhc0wj@mat.ucm.es...


Hello

In my experience  without having a decent ODF plugin for MS
Office, openoffice will start to replace MS office. I tried
out the ODF plugin as provided by sourceforge and it is a
little worse than the OO import doc filter. I would like to
try the old Sun ODF plugin but alas Oracle now charges for
the plugin. Can somebody provide me with a link to the old
SUN plugin?

thanks

Uwe Brauer


Try this:
http://cid-e60ce3038809e993.office.live.com/browse.aspx/ODF%20Plugin

:-) 




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Read-only file

[Nicholas]

For spreadsheet, printing has always been a problem to many people. 
First item you need to check is the print range.



Choose menu View ->Page Break Preview


If the page is not selected, then its not going to print.



mckspenn wrote:


I somehow created a read-only spreadsheet and need to be able to print the
documents in the File. I have created reports with a tab for each month.  I
can only preview and print pages 1 & 3of April report and nothing from the
other month's reports.I can see the reports on screen, but when I try to
print the message box tells me "There is nothing to print." "The selected
print range or sheet is empty." Doesn't matter if the edit icon is activated
or off.  WHAT CAN I DO



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


  


--
Nicholas A. Suppiah

Centre Manager
Open Source Competency Centre (OSCC), MAMPU
Level 3, E302 - 304, Enterprise Building 3
Persiaran APEC
63000 Cyberjaya
Selangor D.E.
[Tel] +603 8319 1200 (ext. 818) [Fax] +603 8319 3206



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: open office impress

[Nicholas]

Gene,


Firstly you need to retrieve the video file from the internet.

Next insert into the Impress as a Video. Select menu

Insert ->Movie&Sound

Start slide show to view the movie.


Gene Kohlenberg wrote:


On 6/10/2010 5:39 AM, siebenkaempfe...@aol.com wrote:


Hello,
my name is Stephanie. I´m a student from Germany and I´m using open 
office.
I´m referring to you because i do have coming up a presentation and 
there´s a little problem using open office impress. I want to embed a 
video from youtube, which might be helpful to present some issues 
about sustainability in tourism.
do you know how to embed a video from youtube into that presentation 
(with impress)??

I hope you´re able to help me!!!

thanks!
sincerely
stephanie




I downloaded "Any Video Converter" at 
http://www.any-video-converter.com/products/for_video_free/.


I used it to download the YouTube video that I was interested in 
capturing.  I then used the same software to convert the file to the 
wmv format.  Then in Impress I opened the Media Playback toolbar 
(View>toolbars>Media Playback)and inserted the video that I had 
converted to wmv format.  On the Media Playback toolbar I selected 
"Scaled" in the magnification drop-down box, and adjusted the video 
image on the slide to the size I wanted.


To keep the aspect ratio fixed, hold down the shift key while dragging 
one of the green corner boxes to size the video.


If the wmv file name doesn't show up in the file open box, type *.wmv 
in the file name box and click open.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org




--
Nicholas A. Suppiah

Centre Manager
Open Source Competency Centre (OSCC), MAMPU
Level 3, E302 - 304, Enterprise Building 3
Persiaran APEC
63000 Cyberjaya
Selangor D.E.
[Tel] +603 8319 1200 (ext. 818) [Fax] +603 8319 3206



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OO 3.0 (Ubuntu) does not export notes to PDF

[Nicholas]

Uwe,


Export to PDF with notes is working for OOo3.1.1 on Ubuntu 9.10.


When I use Okular/Acroead, I see a small note icon. Place cursor on this 
icon and the notes appear.




Uwe Brauer wrote:


Hello

I am not sure to submit a bug report but I can't export
notes to pdf. I inserted notes with alt-control N, I specify
when exporting to pdf include notes, but then neither in
xpdf nor in foxit reader these notes appear.

Can somebody confirm this please?

regards

Uwe Brauer 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


  


--
Nicholas A. Suppiah

Centre Manager
Open Source Competency Centre (OSCC), MAMPU
Level 3, E302 - 304, Enterprise Building 3
Persiaran APEC
63000 Cyberjaya
Selangor D.E.
[Tel] +603 8319 1200 (ext. 818) [Fax] +603 8319 3206



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] (slightly) off topic: the old Sun ODF pluging

[Uwe Brauer]

Hello

In my experience  without having a decent ODF plugin for MS
Office, openoffice will start to replace MS office. I tried
out the ODF plugin as provided by sourceforge and it is a
little worse than the OO import doc filter. I would like to
try the old Sun ODF plugin but alas Oracle now charges for
the plugin. Can somebody provide me with a link to the old
SUN plugin?

thanks

Uwe Brauer 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Multiple "sheets" in Writer

[Uwe Fischer]

On 06/11/10 03:42, RA Brown wrote:

Barbara Duprey wrote:


Instead of focusing on parallels to Calc, let's think instead about this:

   * You have a "family" of text documents, all related to the same
 overall function.
   * The documents are fully independent of each other for such things
 as styles, page numbering, layout, and so on.
   * When something causes you to want to edit or refer to one of these
 documents, chances are high that your requirement extends also to
 the other documents in the family.
   * Currently, each of these documents has a different name, and you
 open each in a separate window to achieve your objective.
   * The proposal is to allow the documents to retain their
 independence, but be contained in a single file that can be opened
 with one action and makes the individual documents readily
 accessible from each other to streamline the updating and/or
 referencing activities you need to perform.
   * When you have accomplished your task, you currently close each
 document separately. With the new structure, a single action
 closes all the documents.

Besides improving efficiency for the document owner, an advantage to 
this structure is that the recovery information tracks together for 
all the documents, making it less likely that they will get out of 
sync by being restored to different points in your workflow.


Dotan, is this a reasonable statement of your intent here?



Barbara,

Great post.

I would like to see at least one other added: The ability to have text 
and spreadsheets in the same file.  Having the ability to store scanned 
and PDFs documents would be an even bigger plus.


Andy


Hi,
if you replace "file" with "folder", it looks like everything is already 
there.
Just don't use the one and only "My Documents" folder for all your 
documents, but instead create a dedicated folder (may be with 
subfolders) for every project that needs multiple files. You can easily 
select several or all files from your operating system file manager, 
then print or open them.


Regards
Uwe
--
  uwe.fisc...@sun.com  -  Technical Writer
  Sun Microsystems, Hamburg, Germany
  http://documentation.openoffice.org/
  http://wiki.services.openoffice.org/wiki/Documentation
  http://blogs.sun.com/oootnt
  http://user.services.openoffice.org/en/forum

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org