[users] Using list box to control text
How can I create the following structure in a text document: 1) there is a List Box containing several entries 2) there are several sections containing various text 3) sections show or hide depending on what entry I choose from the List Box It should work similarly as hiding section with a Check Box Jacek Szymona - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc error
Dear Sir/Madam, We have one ods file attached which has some problem, Please check and tell how to rectify the problem. Thanks Regards. Shabbir Shaikh. There is no substitute for hard work. Girish K.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc- several sheets all in sync
Original message Date: Tue, 04 Jan 2011 09:42:28 -0500 From: . pe...@aleksandrsolzhenitsyn.net Subject: [users] Calc- several sheets all in sync To: users@openoffice.org I've created a Monthly Calendar Generator in Calc- you can see the template here- http://templates.services.openoffice.org/en/node/4973 All you do is enter an Event (like your birthday) in one cell and the date of the event in the cell next to it. The Event is automatically entered in the appropriate calendar's date. You only enter Event data in the sheet named January-Main The primary formula used for referring to sheet named January-Main is =January-Main.cell location The problem is I can't figure out how to get all of the Event and dates next to them to look exactly like the Event and dates entered in January-Main. That is- if you insert a row between two of the Events I want to see that row added in all other calendar sheets. Sorry for making this so confusing but any help would be appreciated. signature.asc (1k bytes)
Re: [users] Calc- several sheets all in sync
Original message Date: Tue, 04 Jan 2011 09:42:28 -0500 From: . pe...@aleksandrsolzhenitsyn.net Subject: [users] Calc- several sheets all in sync To: users@openoffice.org I've created a Monthly Calendar Generator in Calc- you can see the template here- http://templates.services.openoffice.org/en/node/4973 All you do is enter an Event (like your birthday) in one cell and the date of the event in the cell next to it. The Event is automatically entered in the appropriate calendar's date. You only enter Event data in the sheet named January-Main The primary formula used for referring to sheet named January-Main is =January-Main.cell location The problem is I can't figure out how to get all of the Event and dates next to them to look exactly like the Event and dates entered in January-Main. That is- if you insert a row between two of the Events I want to see that row added in all other calendar sheets. Sorry for making this so confusing but any help would be appreciated. signature.asc (1k bytes)
[users] open office freezing
Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster
Re: [users] Re: Strange problem with PDFs
Original message Date: Tue, 04 Jan 2011 15:06:35 + From: Mike Scott m...@scottsonline.org.uk Subject: Re: [users] Re: Strange problem with PDFs To: users@openoffice.org On 04/01/11 13:22, Séamas Ó Brógáin wrote: Well, I may have found the problem (thanks to Mike’s kind offer to look at samples), and it’s intriguing (and slightly embarrassing). I think it’s a memory problem. I’m using an oldish computer with insufficient memory. I made up a sample page, using a variety of fonts, including commercial fonts and some I made myself. I made PDFs with three different procedures (export directly from Openoffice, print to PS file for conversion with ps2pdf, and CUPS-PDF). All were perfect. Then I made a PDF of a document I am editing: about 350 pages (500 kb). The fault was there. Then I made a PDF just of the offending page. The fault is not there. It seems a strange way for Openoffice to react to insufficient memory (and it doesn’t do anything else strange, as far as I can tell), and yet this seems the only explanation of the empirical evidence. Offhand, I'd say that's rather unlikely. Lack of main memory may make the system thrash wildly and run like a snail or even hang up; lack of swap may crash some (poor) app's. I've never known wrong results like yours though. Thanks to all for your kind help. Time to start hinting about a new computer. (This is written on a now-dated Athlon [2.4+, I think!], with all of 768Mb main memory. Works just fine except for editing big images.) -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Importing spreadsheet into database
Original message Date: Tue, 4 Jan 2011 14:21:24 -0500 From: Rob Hall r...@globaleliteservices.com Subject: [users] Importing spreadsheet into database To: users@openoffice.org Hi, I am a new user to Open Office. I am trying to import a spreadsheet (excel format) into Database to do sorting and queries on. When I try to load the spreadsheet it default loads into Calc and I can't get it into Database. Any help or pointing in the right direction would be appreciated. Sorry if this doesn't get to the proper place for questions. Thanks ROB
Re: [users] Importing spreadsheet into database
Original message Date: Tue, 4 Jan 2011 21:06:52 +0100 From: Sigrid Carrera sigrid.carr...@googlemail.com Subject: Re: [users] Importing spreadsheet into database To: users@openoffice.org Hi Rob, 2011/1/4 Rob Hall r...@globaleliteservices.com: Hi, I am a new user to Open Office. I am trying to import a spreadsheet (excel format) into Database to do sorting and queries on. When I try to load the spreadsheet it default loads into Calc and I can't get it into Database. Any help or pointing in the right direction would be appreciated. Sorry if this doesn't get to the proper place for questions. I'm am not a database user myself, but as far as I know, you have to start OOo Base and connect from there to your spreadsheet. So, it's not just a double click on the file. But to be sure, you might want to have a look at the documentation for base. Check the support website: http://support.openoffice.org/ I hope, this helps. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Question
Good evening! I am also Marius Popa and I have a problem. I have made a portable version of OpenOffice.org 3.3 rc8 on my own with Thinstall and I see two buttons that are grayed out: To Weblog and Open Weblog Entry. Why do they appear in this version and why did they not appear in the previous version? How can they be used or removed? At the same time, I cannot install the extension Sun Weblog Publisher because of the error Could not create Java implementation loader. What should I do? Thanks in advance and I am looking forward for your message. -- Marius Popa
Re: [users] Strange problem with PDFs
Original message Date: Mon, 03 Jan 2011 10:33:06 + From: Séamas Ó Brógáin s...@iol.ie Subject: [users] Strange problem with PDFs To: users@openoffice.org I have a strange problem with PDFs made with Openoffice on Linux (Ubuntu 10.10). Wherever there is an en rule (the short dash used in a span of numbers: Unicode 2013), in the PDF it takes the shape of (or is replaced with) a dash (Unicode 2014), though it retains the spacing of the narrower character, so that the dash runs through the following character. Everything is fine in the original Openoffice document: it happens only when it’s exported as a PDF. And the result is the same whether I export directly from within Openoffice or print to file as Postscript and then create the PDF with ps2pdf. Obviously the prime suspect would seem to be the font. So I tried with several different fonts, to discover that some do and some don’t. Then I tried the same fonts in different applications, such as Gedit, and the PDFs are all perfect, for all fonts. I wonder if anyone can offer any clues. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Strange problem with PDFs
Original message Date: Mon, 03 Jan 2011 15:48:28 + From: Séamas Ó Brógáin s...@iol.ie Subject: Re: [users] Strange problem with PDFs To: users@openoffice.org Many thanks for your help, krackedpress. I installed CUPS-PDF, and it works fine, but unfortunately the particular problem remains. Anyway, I’m glad I got CUPS-PDF. It’s something I should have, and should learn more about. Thanks again, and happy new year from freezing Dublin. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc shows Sort greyed-out
Original message Date: Mon, 03 Jan 2011 11:42:05 +0100 From: Uwe Fischer uwe.fisc...@oracle.com Subject: Re: [users] Calc shows Sort greyed-out To: users@openoffice.org On 12/31/10 05:29, Lee wrote: Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether I select all (CTRL A), select the specific columns, or select the range of cells, the Sort function under Tools is greyed out. Saving the file, closing and reopening didn't help. Please advise; thanks much. Lee Hello Lee, Calc cannot sort with Edit-Changes-Record enabled. Temporarily disable recording changes, sort, then enable change tracking again (if you need that at all). Uwe -- Uwe Fischer | Technical Writer Oracle Office GBU ORACLE Deutschland B.V. Co. KG | Nagelsweg 55 | 20097 Hamburg ORACLE Deutschland B.V. Co. KG Hauptverwaltung: Riesstr. 25, D-80992 München Registergericht: Amtsgericht München, HRA 95603 Komplementärin: ORACLE Deutschland Verwaltung B.V. Rijnzathe 6, 3454PV De Meern, Niederlande Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697 Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Strange problem with PDFs
Original message Date: Mon, 03 Jan 2011 08:43:36 -0500 From: webmas...@krackedpress.com webmas...@krackedpress.com Subject: Re: [users] Strange problem with PDFs To: users@openoffice.org On 01/03/11 05:33, Séamas Ó Brógáin wrote: I have a strange problem with PDFs made with Openoffice on Linux (Ubuntu 10.10). Wherever there is an en rule (the short dash used in a span of numbers: Unicode 2013), in the PDF it takes the shape of (or is replaced with) a dash (Unicode 2014), though it retains the spacing of the narrower character, so that the dash runs through the following character. Everything is fine in the original Openoffice document: it happens only when it’s exported as a PDF. And the result is the same whether I export directly from within Openoffice or print to file as Postscript and then create the PDF with ps2pdf. Obviously the prime suspect would seem to be the font. So I tried with several different fonts, to discover that some do and some don’t. Then I tried the same fonts in different applications, such as Gedit, and the PDFs are all perfect, for all fonts. I wonder if anyone can offer any clues. Try adding CUPs PDF as your printer of PDF files. That is what I use for Ubuntu 10.10 64-bit. I do not know is it is the internal export system to PDF or not. If you print the PDF file using the CUPs PDF printing system and you do not get that error, then it is the exporting system internal to OOo. I would go to the Synaptic Package Manager and do a search for cups pdf. That will get you started. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Mon, 03 Jan 2011 01:49:36 -0500
From: Andrew Douglas Pitonyak
and...@pitonyak.org
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
On 12/31/2010 07:16 AM, Sandro wrote:
Thanks Andrew,
Andrew Douglas Pitonyakandrewat
pitonyak.org writes:
Note that I have not tried anything that I am
about to suggest
1. Insert the new row where you desire it to
be.
2. Use the view cursor to select the row that
you desire to duplicate.
3. Use a dispatch to copy row to the
clipboard.
4. Move the view cursor to the new position
and use a dispatch to paste
the row into the new row.
after sending this mail I did also investigate
the solution with dispatcher,
but I realized I couldn't understand how to
move the viewcursor to the
correct location... moreover I mean to use it
in a headless environ and I
wasn't sure that this is the best solution.
I expect that in headless mode you will likely
NOT have a view cursor.
Unfortunately, the view cursor may be the only
way to easily select an
entire row, but, a cell cursor may also work (I
almost never do this so
I would need to invest a few hours to understand
it. I rarely have a
few hours)
My best guess without looking anything up
(because it is late and my
wife told me to come to bed) is that you can use
the current controller
to select (it should support something like this:
currentcontroller.select(oCell), but, that is
just a guess.
Anyhow this is what I did:
table = document.TextTables.getByIndex(0)
cell = table.getCellByPosition(0,1)
controller=document.getCurrentController()
frame=controller.getFrame()
view_cursor=controller.getViewCursor()
... how to move the cursor to the cell??
dispatcher = context.ServiceManager.
createInstance('com.sun.star.frame.DispatchHelper')
dispatcher.executeDispatch(frame,
'.uno:EntireRow', '', 0, tuple())
dispatcher.executeDispatch(frame, '.uno:Copy',
'', 0, tuple())
dispatcher.executeDispatch(frame, '.uno:Paste',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:JumpToNextCell', '', 0, tuple())
Yes, I had exactly this sort of thing in mind.
This likely fails in
headless mode, however. May have to use a cell
cursor or similar.
Copying arbitrary text, however, is tricky at
best.
Note: This will likely fail with a complex
table and special care is
required for complex content (such as when a
cell contains multiple text
objects; for example, an embedded image).
The case I'm dealing with now is simple but as
it is part of a template
system that is public I can't make assumptions
on how complex will the real
templates be.
I disagree. There is no shame in stating that
certain things will ONLY
work on a simple table (which is the majority
case anyway).
I think that new provisions may exist for
copying text content. If that is
the case, you may be able to copy the text
content in each cell to the new
cell in the new row.
Can you explain what you mean by new
provisions may exist for copying text
content. I think this is what I was looking
for but I was not able to find
a way neather for copying text and style nor
for pasting it!...
In a Calc document, I can specifically say copy
this range over there
without using any other special thing like the
clipboard. For all I know
that may actually work in text tables as well
since they share many
similarities to a Calc Sheet (again, I did not
verify). it looks
something like this:
Sub CopySpreadsheetRange
REM Get sheet 1, the original, and 2, which will
contain the copy.
oSheet1 = ThisComponent.Sheets.getByIndex(0)
oSheet2 = ThisComponent.Sheets.getByIndex(1)
REM Get the range to copy and the rang to copy
to.
oRangeOrg =
oSheet1.getCellRangeByName(A1:C10).RangeAddress
oRangeCpy =
oSheet2.getCellRangeByName(A1:C10).RangeAddress
REM The insert position
oCellCpy =
oSheet2.getCellByPosition(oRangeCpy.StartColumn,_
oRangeCpy.StartRow).CellAddress
REM Do the copy
oSheet1.CopyRange(oCellCpy, oRangeOrg)
End Sub
This may be related to this:
http://api.openoffice.org/docs/common/ref/com/sun/star/text/XTextCopy.html
http://api.openoffice.org/docs/common/ref/com/sun/star/text/XTextTableCursor.html
Never used the XTextCopy, never seen it used.
Perhaps you can ask on the
d...@api.openoffice.org mailing list.
thanks for your time
sandro
*:-)
On 12/28/2010 11:36 AM, Sandro wrote:
Hi,
I already spent many hours on this problem
and I can't find the correct
approach. I really hope someone can help me
or point me in the correct
direction/reading.
I need to programmatically duplicate rows of
a Table in openoffice writer.
It's
Re: [users] How to underline a blank line of text, such that it could be typed?
Original message Date: Sun, 02 Jan 2011 16:54:54 -0600 From: Barbara Duprey b...@onr.com Subject: Re: [users] How to underline a blank line of text, such that it could be typed? To: users@openoffice.org On 1/2/2011 2:33 PM, Dotan Cohen wrote: A user is making forms for herself and other therapists. These forms will be printed, and to specify the place where text is to be typed there are lines on the page, created with four dashes and one Enter per line. This works fine, but the original author wants to type out her forms for herself, instead of filling in the printed ones. she has no problem typing on the lines created with the dashes, but when the text wraps a line the top line looses it's underline! How can she prevent this from happening? Should she use a different type of line? If I was unsuccessful in describing the situation, then here are steps to reproduce: 1) In a new document press dash three times and press enter. 2) Now pres upArrow, enter, enter, upArrow, upArrow. 3) Now type a line long enough to wrap. Thanks! I think that's because the automatically generated line isn't a line-width paragraph of underlined characters, but an empty paragraph with a bottom border. (The behavior is controlled by the option to Apply borders under AutoCorrect.) If the supplied text wraps, the border stays below the whole paragraph. There really isn't a good way to get natural wrapping together with the border effect (that is, the appearance of multiple full-width lines with text above them), so far as I can tell. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] [moderated]
How do I get to the tutorials?
Re: [users] draw
Original message Date: Sat, 01 Jan 2011 11:33:05 +0100 From: Franz Wein f.w...@f-wein.com Subject: Re: [users] draw To: users@openoffice.org Hello Dan * Why blue: in impress and although in draw you can choose the default color in the properties in OO. o Menue EXTRA - Options + select in the drop-downlist OpenOffice.org - colors + select there your default color * Drawing an object around an other object. o draw your second object so as you like. o select with the right bottom object - choose alignment in the drop-downlist and select in more/full background - in OO3 there is a option behind object o select with the right bottom object - choose location/size - + in the first tabulator in the open window there are to squares named basic-point - select there the center radio-bottom - do this for both objects! + fill in the identical position - so the both objects are centered + if it is necessary fill in the size for width and hight for your second object. Franz Dan Armstrong schrieb: If you draw a square, ect. Why is the area blue? How do you draw an eclipse around an object? When I do this I get an eclipse with a blue field blocking out the object. Thanks, Dan
[users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
?
Re: [users] will I need to do the following . . . .
Original message Date: Fri, 31 Dec 2010 21:59:43 -0500 From: webmas...@krackedpress.com webmas...@krackedpress.com Subject: [users] will I need to do the following . . . . To: users@openoffice.org users@openoffice.org I see that OOo is on RC8. When 3.3.0 comes out, will need to do an uninstall of OOo Debian or can I just install the version of 3.3.0 and then not use the following: sudo dpkg -i *.deb cd desktop-integration I know that when I was switching over from Ubuntu's Go-oo in its repository, every time I got to the desktop-integration, it gave errors saying the whatever was already in the menus. So the question really is, will I need to re-do the desktop-integration or will the installation of the debs be enough without the second step of the desktop-integration? If I need to do a full re-install, how do I remove OOo from the system and the menus so it will be a full, clean, install? --- To be honest, I am running both OOo 3.2.x and a beta of LibreOffice. I have been running OOo since it's early days before it had the ODF file formats included. There are some aspects of who is in control of the software project[s], that makes me look at both OOo and LO to see what all the fuss is about and where these two development Styles will actually come up with in the foreseeable future. Until then I will be running both on my Ubuntu [64-bit] desktop and OOo on my Vista [32-bit] laptop. The desktop is my testbed and my system I do most of my work on.
Re: [users] draw
Original message Date: Thu, 30 Dec 2010 15:55:55 -0600 From: Dan Armstrong dan...@gulftel.com Subject: [users] draw To: users@openoffice.org If you draw a square, ect. Why is the area blue? How do you draw an eclipse around an object? When I do this I get an eclipse with a blue field blocking out the object. Thanks, Dan
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Fri, 31 Dec 2010 07:27:51 -0500 (EST)
From: codyh...@comporium.net
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
Original message
Date: Fri, 31 Dec 2010 12:16:25 + (UTC)
From: Sandro san...@e-den.it
Subject: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
Thanks Andrew,
Andrew Douglas Pitonyak andrew at
pitonyak.org writes:
Note that I have not tried anything that I am
about to suggest
1. Insert the new row where you desire it to
be.
2. Use the view cursor to select the row that
you desire to duplicate.
3. Use a dispatch to copy row to the
clipboard.
4. Move the view cursor to the new position
and
use a dispatch to paste
the row into the new row.
after sending this mail I did also investigate
the solution with dispatcher,
but I realized I couldn't understand how to
move
the viewcursor to the
correct location... moreover I mean to use it
in
a headless environ and I
wasn't sure that this is the best solution.
Anyhow this is what I did:
table = document.TextTables.getByIndex(0)
cell = table.getCellByPosition(0,1)
controller=document.getCurrentController()
frame=controller.getFrame()
view_cursor=controller.getViewCursor()
... how to move the cursor to the cell??
dispatcher = context.ServiceManager.
createInstance('com.sun.star.frame.DispatchHelper')
dispatcher.executeDispatch(frame,
'.uno:EntireRow', '', 0, tuple())
dispatcher.executeDispatch(frame, '.uno:Copy',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:Paste',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:JumpToNextCell', '', 0, tuple())
Note: This will likely fail with a complex
table and special care is
required for complex content (such as when a
cell contains multiple text
objects; for example, an embedded image).
The case I'm dealing with now is simple but as
it
is part of a template
system that is public I can't make assumptions
on
how complex will the real
templates be.
I think that new provisions may exist for
copying text content. If that is
the case, you may be able to copy the text
content in each cell to the new
cell in the new row.
Can you explain what you mean by new
provisions
may exist for copying text
content. I think this is what I was looking
for
but I was not able to find
a way neather for copying text and style nor
for
pasting it!...
thanks for your time
sandro
*:-)
On 12/28/2010 11:36 AM, Sandro wrote:
Hi,
I already spent many hours on this problem
and I can't find the correct
approach. I really hope someone can help me
or point me in the correct
direction/reading.
I need to programmatically duplicate rows
of
a Table in openoffice writer.
It's not difficult to add rows via
table.Rows.insertByIndex(idx, count),
that adds empty rows and it's easy to add
text in that row assigning
DataArray to the CellRange. Doing this way
you loose control on the style of
the cells and specifically if a cell has
words with different style
(bold/italic) they get flattened to the
same
face. What I need is to
duplicate a row in a way that preserves the
style of each word in the
cell/row.
This is the last step of a Python template
system that uses openoffice
(http://oootemplate.argolinux.org). I
access
the document via 'uno'
interface in Python but any language would
do
to explain the logic behind
it.
thanks in advance
sandro
*
-
To unsubscribe, e-mail: users-unsubscribe
at openoffice.org
For additional commands, e-mail: users-help
at openoffice.org
-
To unsubscribe, e-mail:
users-unsubscr...@openoffice.org
For additional commands, e-mail:
users-h...@openoffice.org
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Fri, 31 Dec 2010 07:27:51 -0500 (EST)
From: codyh...@comporium.net
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
Original message
Date: Fri, 31 Dec 2010 12:16:25 + (UTC)
From: Sandro san...@e-den.it
Subject: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
Thanks Andrew,
Andrew Douglas Pitonyak andrew at
pitonyak.org writes:
Note that I have not tried anything that I am
about to suggest
1. Insert the new row where you desire it to
be.
2. Use the view cursor to select the row that
you desire to duplicate.
3. Use a dispatch to copy row to the
clipboard.
4. Move the view cursor to the new position
and
use a dispatch to paste
the row into the new row.
after sending this mail I did also investigate
the solution with dispatcher,
but I realized I couldn't understand how to
move
the viewcursor to the
correct location... moreover I mean to use it
in
a headless environ and I
wasn't sure that this is the best solution.
Anyhow this is what I did:
table = document.TextTables.getByIndex(0)
cell = table.getCellByPosition(0,1)
controller=document.getCurrentController()
frame=controller.getFrame()
view_cursor=controller.getViewCursor()
... how to move the cursor to the cell??
dispatcher = context.ServiceManager.
createInstance('com.sun.star.frame.DispatchHelper')
dispatcher.executeDispatch(frame,
'.uno:EntireRow', '', 0, tuple())
dispatcher.executeDispatch(frame, '.uno:Copy',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:Paste',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:JumpToNextCell', '', 0, tuple())
Note: This will likely fail with a complex
table and special care is
required for complex content (such as when a
cell contains multiple text
objects; for example, an embedded image).
The case I'm dealing with now is simple but as
it
is part of a template
system that is public I can't make assumptions
on
how complex will the real
templates be.
I think that new provisions may exist for
copying text content. If that is
the case, you may be able to copy the text
content in each cell to the new
cell in the new row.
Can you explain what you mean by new
provisions
may exist for copying text
content. I think this is what I was looking
for
but I was not able to find
a way neather for copying text and style nor
for
pasting it!...
thanks for your time
sandro
*:-)
On 12/28/2010 11:36 AM, Sandro wrote:
Hi,
I already spent many hours on this problem
and I can't find the correct
approach. I really hope someone can help me
or point me in the correct
direction/reading.
I need to programmatically duplicate rows
of
a Table in openoffice writer.
It's not difficult to add rows via
table.Rows.insertByIndex(idx, count),
that adds empty rows and it's easy to add
text in that row assigning
DataArray to the CellRange. Doing this way
you loose control on the style of
the cells and specifically if a cell has
words with different style
(bold/italic) they get flattened to the
same
face. What I need is to
duplicate a row in a way that preserves the
style of each word in the
cell/row.
This is the last step of a Python template
system that uses openoffice
(http://oootemplate.argolinux.org). I
access
the document via 'uno'
interface in Python but any language would
do
to explain the logic behind
it.
thanks in advance
sandro
*
-
To unsubscribe, e-mail: users-unsubscribe
at openoffice.org
For additional commands, e-mail: users-help
at openoffice.org
-
To unsubscribe, e-mail:
users-unsubscr...@openoffice.org
For additional commands, e-mail:
users-h...@openoffice.org
Re: [users] Calc
Original message Date: Sat, 01 Jan 2011 11:15:29 +0100 From: Franz Wein f.w...@f-wein.com Subject: Re: [users] Calc To: users@openoffice.org Hi Joe use the right mousebottom - on the tabulator at the screenbuttom. Select the in the dropdown-menue insert spreadsheet - its siimilar to excel. Franz J Halka schrieb: I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] draw
Original message Date: Sat, 01 Jan 2011 08:16:03 + From: Mike Scott m...@scottsonline.org.uk Subject: Re: [users] draw To: users@openoffice.org Cc: Dan Armstrong dan...@gulftel.com On 30/12/2010 21:55, Dan Armstrong wrote: If you draw a square, ect. Why is the area blue? It's just the default - you need to see what you're drawing! If you right-click on it once drawn, you can pick the Line or Area property and change colour. How do you draw an eclipse around an object? When I do this I get an eclipse with a blue field blocking out the object. I thought that's what eclipses did :-) :-) But again, R-click and change to transparent if that's what suits. Oh, don't forget you can change the stack order as well, and put a given object 'behind' or 'in front' of another - R-click and 'Arrange'. Don't forget F1 brings up the help system. BTW you're not subscribed to this mail list, so may miss answers. Replies to list only please (users@openoffice.org) -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
Original message Date: Fri, 31 Dec 2010 21:59:43 -0500 From: webmas...@krackedpress.com webmas...@krackedpress.com Subject: [users] will I need to do the following . . . . To: users@openoffice.org users@openoffice.org I see that OOo is on RC8. When 3.3.0 comes out, will need to do an uninstall of OOo Debian or can I just install the version of 3.3.0 and then not use the following: sudo dpkg -i *.deb cd desktop-integration I know that when I was switching over from Ubuntu's Go-oo in its repository, every time I got to the desktop-integration, it gave errors saying the whatever was already in the menus. So the question really is, will I need to re-do the desktop-integration or will the installation of the debs be enough without the second step of the desktop-integration? If I need to do a full re-install, how do I remove OOo from the system and the menus so it will be a full, clean, install? --- To be honest, I am running both OOo 3.2.x and a beta of LibreOffice. I have been running OOo since it's early days before it had the ODF file formats included. There are some aspects of who is in control of the software project[s], that makes me look at both OOo and LO to see what all the fuss is about and where these two development Styles will actually come up with in the foreseeable future. Until then I will be running both on my Ubuntu [64-bit] desktop and OOo on my Vista [32-bit] laptop. The desktop is my testbed and my system I do most of my work on.
Re: [users] Re: Two questions about Impress
Original message Date: Tue, 28 Dec 2010 18:07:54 -0500 (EST) From: codyh...@comporium.net Subject: Re: [users] Re: Two questions about Impress To: users@openoffice.org, b...@billp.org Please unsubscribe codyh...@comporium.net from open office at once. I'm getting emails from people which should be going to your email.not to me. Thanks codyh...@comporium.net Original message Date: Tue, 28 Dec 2010 21:14:08 + From: bill purvis b...@billp.org Subject: Re: [users] Re: Two questions about Impress To: users@openoffice.org On Tuesday 28 December 2010, Gene Kohlenberg wrote: On 12/28/2010 9:25 AM, bill purvis wrote: 1: ... sorted 2: I want to include some movie clips in my talk. My video camera produces .mov files: 1280x720 pixels, MJPEG format PCM sound. When I try to insert (using Insert-Movie and Sound or Tools-Media Player) it says that this format is not supported. I'm not (yet) proficient in video formats but am willing to have a go at converting, but can't find anything that tells me which formats are supported. I'm running 3.2.0 at present, but I'm thinking of moving to 3.3 pre-release if that's reasonably stable. Many thanks.., Bill ... You will need to convert the .mov file to .avi. Use something such as RAD Video Tools to make the conversion. If you want to change the size of the video on the slide, go to ViewToolbarsMedia Playback. You can use the zoom function to change the size of the video. If you just drag a corner of the video frame to change size, it only changes the size of the box that the video appears in. I'm running under Linux, and used ffmpeg to convert from .mov to .avi. The resulting file is much smaller, but shows up OK with mediaPlayer. However, when I try to insert it into my Impress file I still get The format of the selected file is not supported. I have extracted the following details of the file: CRM01.avi: RIFF (little-endian) data, AVI, 1280 x 720, 30.00 fps, video: FFMpeg MPEG-4, audio: MPEG-1 Layer 1 or 2 (stereo, 16000 Hz) Any suggestions as to where I go from here? Bill -- +---+ | Bill Purvis, Model Engineer | | email: b...@billp.org | +---+ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Original message Date: Thu, 30 Dec 2010 10:53:16 -0800 (PST) From: J Halka jhjh...@yahoo.com Subject: [users] Calc To: users@openoffice.org I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH
Re: [users] draw
Original message Date: Thu, 30 Dec 2010 15:55:55 -0600 From: Dan Armstrong dan...@gulftel.com Subject: [users] draw To: users@openoffice.org If you draw a square, ect. Why is the area blue? How do you draw an eclipse around an object? When I do this I get an eclipse with a blue field blocking out the object. Thanks, Dan
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Fri, 31 Dec 2010 07:27:51 -0500 (EST)
From: codyh...@comporium.net
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
Original message
Date: Fri, 31 Dec 2010 12:16:25 + (UTC)
From: Sandro san...@e-den.it
Subject: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
Thanks Andrew,
Andrew Douglas Pitonyak andrew at
pitonyak.org writes:
Note that I have not tried anything that I am
about to suggest
1. Insert the new row where you desire it to
be.
2. Use the view cursor to select the row that
you desire to duplicate.
3. Use a dispatch to copy row to the
clipboard.
4. Move the view cursor to the new position
and
use a dispatch to paste
the row into the new row.
after sending this mail I did also investigate
the solution with dispatcher,
but I realized I couldn't understand how to
move
the viewcursor to the
correct location... moreover I mean to use it
in
a headless environ and I
wasn't sure that this is the best solution.
Anyhow this is what I did:
table = document.TextTables.getByIndex(0)
cell = table.getCellByPosition(0,1)
controller=document.getCurrentController()
frame=controller.getFrame()
view_cursor=controller.getViewCursor()
... how to move the cursor to the cell??
dispatcher = context.ServiceManager.
createInstance('com.sun.star.frame.DispatchHelper')
dispatcher.executeDispatch(frame,
'.uno:EntireRow', '', 0, tuple())
dispatcher.executeDispatch(frame, '.uno:Copy',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:Paste',
'', 0, tuple())
dispatcher.executeDispatch(frame,
'.uno:JumpToNextCell', '', 0, tuple())
Note: This will likely fail with a complex
table and special care is
required for complex content (such as when a
cell contains multiple text
objects; for example, an embedded image).
The case I'm dealing with now is simple but as
it
is part of a template
system that is public I can't make assumptions
on
how complex will the real
templates be.
I think that new provisions may exist for
copying text content. If that is
the case, you may be able to copy the text
content in each cell to the new
cell in the new row.
Can you explain what you mean by new
provisions
may exist for copying text
content. I think this is what I was looking
for
but I was not able to find
a way neather for copying text and style nor
for
pasting it!...
thanks for your time
sandro
*:-)
On 12/28/2010 11:36 AM, Sandro wrote:
Hi,
I already spent many hours on this problem
and I can't find the correct
approach. I really hope someone can help me
or point me in the correct
direction/reading.
I need to programmatically duplicate rows
of
a Table in openoffice writer.
It's not difficult to add rows via
table.Rows.insertByIndex(idx, count),
that adds empty rows and it's easy to add
text in that row assigning
DataArray to the CellRange. Doing this way
you loose control on the style of
the cells and specifically if a cell has
words with different style
(bold/italic) they get flattened to the
same
face. What I need is to
duplicate a row in a way that preserves the
style of each word in the
cell/row.
This is the last step of a Python template
system that uses openoffice
(http://oootemplate.argolinux.org). I
access
the document via 'uno'
interface in Python but any language would
do
to explain the logic behind
it.
thanks in advance
sandro
*
-
To unsubscribe, e-mail: users-unsubscribe
at openoffice.org
For additional commands, e-mail: users-help
at openoffice.org
-
To unsubscribe, e-mail:
users-unsubscr...@openoffice.org
For additional commands, e-mail:
users-h...@openoffice.org
Re: [users] draw
Original message Date: Sat, 01 Jan 2011 08:16:03 + From: Mike Scott m...@scottsonline.org.uk Subject: Re: [users] draw To: users@openoffice.org Cc: Dan Armstrong dan...@gulftel.com On 30/12/2010 21:55, Dan Armstrong wrote: If you draw a square, ect. Why is the area blue? It's just the default - you need to see what you're drawing! If you right-click on it once drawn, you can pick the Line or Area property and change colour. How do you draw an eclipse around an object? When I do this I get an eclipse with a blue field blocking out the object. I thought that's what eclipses did :-) :-) But again, R-click and change to transparent if that's what suits. Oh, don't forget you can change the stack order as well, and put a given object 'behind' or 'in front' of another - R-click and 'Arrange'. Don't forget F1 brings up the help system. BTW you're not subscribed to this mail list, so may miss answers. Replies to list only please (users@openoffice.org) -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Original message Date: Sat, 01 Jan 2011 11:15:29 +0100 From: Franz Wein f.w...@f-wein.com Subject: Re: [users] Calc To: users@openoffice.org Hi Joe use the right mousebottom - on the tabulator at the screenbuttom. Select the in the dropdown-menue insert spreadsheet - its siimilar to excel. Franz J Halka schrieb: I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [moderated]
Hi Amy, 2011/1/2 Amy Anderson momw...@aol.com: How do I get to the tutorials? Just go to the openoffice.org website and click on I need help with my OpenOffice.org. From there, you can go to the specific area, that you're interested in. Hope this helps. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
Hi, 2011/1/1 j art jart7d...@gmail.com: ? Please write next time your question in the body of your mail. And some sort of greeting would be nice too. :) To answer your question: As far as I know, OpenOffice.org cannot read MS Works files. If you have a Works installation somewhere, you can open your files there and safe in in .doc format. After doing this, you can read/edit the files with OpenOffice.org. Another possibility is, that you try the go-oo-version of OpenOffice.org or LibreOffice. I think I saw somewhere, that those two versions can read Works files - but I'm not 100 % sure about this. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
codyhill, what are you trying to achieve? You're flooding all the mailing lists with mails that just repeat the original message but don't add anything. Could you please stop doing this? Thanks in advance. If you have a question of your own, just write a new email and send it to users@openoffice.org and I'm sure, the list will help you with your problem. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office freezing
On 04/01/2011 20:30, brenda wrote: Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster Brenda If the problem persistes can you please let us know and include the operating system name and version and the version of open office you are working on and where you downloaded it from Thanks Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Strange problem with PDFs
webmaster @ krackedpress wrote: Can you device the work into sections when you need to deal with creating the PDF of it, and then use a PDF merge software to merge the smaller file together, so that error you described will not be there? I hope I don’t have to do that. Merging PDF files is something I haven’t done before, and would have to learn how to do. Luckily, the problem document doesn’t have to be finished for some time; but if no other solution emerges I will certainly consider that. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
Den 2011-01-05 11:37:12 skrev Sigrid Carrera sigrid.carr...@googlemail.com: Hi, 2011/1/1 j art jart7d...@gmail.com: ? Please write next time your question in the body of your mail. And some sort of greeting would be nice too. :) To answer your question: As far as I know, OpenOffice.org cannot read MS Works files. If you have a Works installation somewhere, you can open your files there and safe in in .doc format. After doing this, you can read/edit the files with OpenOffice.org. Another possibility is, that you try the go-oo-version of OpenOffice.org or LibreOffice. I think I saw somewhere, that those two versions can read Works files - but I'm not 100 % sure about this. Sigrid Yes, this is correct. I have never tried it myself, but at least the Works files are in the list of file formats in Go-oo. If your operating system is some of the well known GNU/Linux distributions, like Ubuntu, OpenSUSE, Fedora and more, Go-oo is already installed (but it appears as ”OpenOffice.org”). -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On 1/5/2011 5:41 AM, Sigrid Carrera wrote: codyhill, what are you trying to achieve? You're flooding all the mailing lists with mails that just repeat the original message but don't add anything. Could you please stop doing this? Thanks in advance. If you have a question of your own, just write a new email and send it to users@openoffice.org and I'm sure, the list will help you with your problem. Sigrid He is clearly receiving the messages through an email address that is subscribed and forwarding them to his codyhill email. Thus attempts to unsub do not work so he is going to punish us by sending empty replies. I will give him 24 hrs then set up a filter that will auto reply to his personal email address for each one asking him what his question is. If only ten others do so as well I suspect he will stop and ask a real question on how to stop receiving the emails he requested. -- Gene Young - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
RE: [users] Importing spreadsheet into database
Thanks to all for the positive responses. I will try this soon. -Original Message- From: Jeffrey Needle [mailto:jeff.nee...@gmail.com] Sent: Tuesday, January 04, 2011 8:22 PM To: users@openoffice.org Subject: Re: [users] Importing spreadsheet into database It's actually pretty easy. 1. Create your database table in base. For ease of use, make sure the fields are in the same order as they are in the spreadsheet. 2. Go to your spreadsheet, press Ctrl-A (to select all records), and the Ctrl-C, to copy the records to the clipboard. You can also use the Edit dropdown menus to accomplish the same thing. 3. Go back to your database, right-click on the table you've created, choose Paste, and all the records are sent to the database table. A simple copy and paste -- and works wonderfully! - Original Message - From: Rob Hall r...@globaleliteservices.com To: users@openoffice.org Sent: Tuesday, January 04, 2011 11:21 AM Subject: [users] Importing spreadsheet into database Hi, I am a new user to Open Office. I am trying to import a spreadsheet (excel format) into Database to do sorting and queries on. When I try to load the spreadsheet it default loads into Calc and I can't get it into Database. Any help or pointing in the right direction would be appreciated. Sorry if this doesn't get to the proper place for questions. Thanks ROB - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Importing spreadsheet into database
Am 05.01.2011 02:21, Jeffrey Needle wrote: It's actually pretty easy. 1. Create your database table in base. For ease of use, make sure the fields are in the same order as they are in the spreadsheet. 2. Go to your spreadsheet, press Ctrl-A (to select all records), and the Ctrl-C, to copy the records to the clipboard. You can also use the Edit dropdown menus to accomplish the same thing. 3. Go back to your database, right-click on the table you've created, choose Paste, and all the records are sent to the database table. A simple copy and paste -- and works wonderfully! No, it doesn't work that wonderfully. With default settings all columns become optional VARCHAR fields of lenght 255 which renders the table useless and bloated. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On Wed, 05 Jan 2011 07:56:18 -0500, Gene Young n2...@cfl.rr.com wrote Re Re: [users] will I need to do the following . . . .: I will give him 24 hrs then set up a filter that will auto reply to his personal email address for each one asking him what his question is. If only ten others do so as well I suspect he will stop and ask a real question on how to stop receiving the emails he requested. I like that. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office freezing
Have you tried restarting it? Support solar power in the developing world. http://www.everyclick.com/solaraid http://www.solar-aid.org/ From: brenda brendam...@hotmail.com To: users@openoffice.org Sent: Tue, 4 January, 2011 20:30:08 Subject: [users] open office freezing Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster
Re: [users] open office freezing
On 1/4/2011 2:30 PM, brenda wrote: Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster [Brenda (brendam...@hotmail.com) is not subscribed and probably will not see responses unless directly copied.] The timing aspect is interesting, but may not be relevant to the problem (how did you fix it so precisely? did something call your attention to the time?). If you are using a Windows system, the most common reason for a silent failure to open documents (that is, no error message) is that there is an old copy of the soffice.bin process running. If that's the case, use Task Manager to end any process of that name (which will also end any associated soffice.exe processes). OOo should then start normally. Uninstalling and reinstalling should not be necessary, though. A simple restart of your system should also work if you don't want to use the Task Manager. If this doesn't help, please tell us what operating system and version you are using, and what version of OOo, as well as any error messages you are seeing. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On 01/05/11 11:11, Vic Dura wrote: On Wed, 05 Jan 2011 07:56:18 -0500, Gene Young n2...@cfl.rr.com wrote Re Re: [users] will I need to do the following . . . .: I will give him 24 hrs then set up a filter that will auto reply to his personal email address for each one asking him what his question is. If only ten others do so as well I suspect he will stop and ask a real question on how to stop receiving the emails he requested. I like that. I would like my question answered, since I was the one that started the thread. I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
Hi, 2011/1/5 webmas...@krackedpress.com webmas...@krackedpress.com: On 01/05/11 11:11, Vic Dura wrote: On Wed, 05 Jan 2011 07:56:18 -0500, Gene Young n2...@cfl.rr.com wrote Re Re: [users] will I need to do the following . . . .: [...] I would like my question answered, since I was the one that started the thread. I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? I'm not sure. Disclaimer: I'm not using a .deb-based distro! I always install the desktop integration package as well. I'm not sure, if the old package finds your new installation. But to not have to run dpkg -i twice, just copy the desktop-integration package you will need into the higher up (DEBS) directory. Then start dpkg -i *.deb and let it figure out, what to install when. (For the record, I've done this in Mandriva and everything works fine.) Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc error
At 14:17 05/01/2011 +0530, Shabbir Shaikh wrote: We have one ods file attached which has some problem, Please check and tell how to rectify the problem. May I be bold and say that you are expecting a lot here? You shouldn't, I suggest, expect subscribers to a mailing list simply to take over when you have a problem. There is no substitute for hard work. Indeed. And there is no substitute for saying what the problem is, doing what you can with your problem file, and explaining what you did and what response you got, so that anyone trying to help doesn't have to repeat your work. In fact, although your attached file has the .ods extension, it is not a valid OpenOffice (Calc) spreadsheet document file. So it is not surprising that OpenOffice is reluctant to open it. The file contents start as if it is a Portable Document Format (PDF) file, but it also contains what appears to be parts of a Microsoft Excel document file as well as what appears to be garbage. The most likely explanation is that your disk drive has become corrupted, with the result that what appears to be your spreadsheet file is actually a mixture of parts of other files - perhaps even ones that you thought you had deleted. If this is so, the only solution is to go back to your most recent back-up copy of the spreadsheet document file and continue working from there. You will also want to run your system's disk checking software to sort out any other problems on the disk; there will almost certainly be some. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On Wed Jan 05 2011 13:12:14 GMT-0800 (PST) webmas...@krackedpress.com wrote: I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? To keep from having problems with the desktop-integration you will have to only install one version of OOo. I have Go-oo 3.2 from the Ubuntu repository and when I installed any of the OOo RCs I have the same problem. If your going to run the straight OOo then there should be no problem. I always remove the installed RC using the Package Manager before installing the next one. Then use the dpkg -i command to install the next. HTH Andy - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to underline a blank line of text, such that it could be typed?
On Mon, Jan 3, 2011 at 00:13, Brian Barker b.m.bar...@btinternet.com wrote: At 22:33 02/01/2011 +0200, Dotan Cohen wrote: A user is making forms for herself and other therapists. These forms will be printed, and to specify the place where text is to be typed there are lines on the page, created with four dashes and one Enter per line. This works fine, but the original author wants to type out her forms for herself, instead of filling in the printed ones. she has no problem typing on the lines created with the dashes, but when the text wraps a line the top line loses its underline! That's not surprising, since what you have created is not an underline but a paragraph border below each paragraph. And the text that wraps is one continuos paragraph, of course - which gets a single border after it, not after each line. I see, thanks. How can she prevent this from happening? Should she use a different type of line? Possibly. You could keep the original scheme, enter the text, and then go back, putting the cursor at the end of each line in turn and pressing Enter. This converts the passage into separate paragraphs, each of which will inherit the style and be given a trailing border. No! Here's another suggestion: o Put a left tab stop at the right margin (er, or perhaps right at the left, depending on your locale!). o Press Tab followed by Enter the required number of times. o Select all the lines and go to Format | Character... | Font Effects | Underlining (or right-click | Style | Underline, or click the Underline button in the Formatting toolbar). o If the entered text is not justified, this will leave the space at the end of each line not underlined. If this matters, you can add a Tab character at the end of each line. Thanks. Assuming Left to Right (it's not, as you properly guessed, but in the interest of a useful archive let's assume that it is) then what exactly is being accomplished here? I seem to have gotton lost after the second step, I must be putting the tabs in the wrong place, but if I understand what it is that you suggest then I may be able to cope. There are probably neater methods ... I hope so! Thanks, Brian. -- 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] Re: How to underline a blank line of text, such that it could be typed?
On Mon, Jan 3, 2011 at 08:45, Bob Estes bob_es...@comcast.net wrote: What you really need to do is set up an online form with fill-in fields. That sounds about right. Start with a new document and type in the necessary boilerplate. Check. Insert the fill-in fields with the desired formatting and default answers. (i.e. underlining, etc.) Here I got lost. Could you be more specific? From where does one insert the fill-in fields? Certainly not from Insert-Field, which is a completely different usage of the term field. 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] will I need to do the following . . . .
On 01/05/11 16:48, RA Brown wrote: On Wed Jan 05 2011 13:12:14 GMT-0800 (PST) webmas...@krackedpress.com wrote: I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? To keep from having problems with the desktop-integration you will have to only install one version of OOo. I have Go-oo 3.2 from the Ubuntu repository and when I installed any of the OOo RCs I have the same problem. If your going to run the straight OOo then there should be no problem. I always remove the installed RC using the Package Manager before installing the next one. Then use the dpkg -i command to install the next. HTH Andy I know that when I wanted to go from the Go-oo to the OOo version, I had to remove the original package completely as well as the menus. It seemed that there was something wrong if I did not remove the original package first and completely. I even had to remove the .openoffice.org folder as well, since something caused the default document to crash and not repair properly. So that was when I installed - finally - this version of OOo. I did not know if I would have any problems when the next version came out, such as the menus and such. I still have not reinstalled all of the extensions I use to use with the old Go-oo version that I started using since I came to Ubuntu back in Feb '10 on this machine. I may have to do a complete reinstall of Ubuntu to solve a problem with one of my software that seemed to have lost a dependency that was not fixed by all the other means in the terminal's options that I found. So this might have been a mute point. To be fair, I also have LibreOffice 3.3.0.1 RC something installed as well, since I wanted to see what it was all about. I may remove it after OOo 3.3.0.x comes out of RC. Or I may just have it there as a spare ODF suite if there is trouble with my copy of OOo, so I can finish my work and then fix the problem. I had to install KOffice the last time that happened and I use Ubuntu's version of GNOME instead of KDE, so this time I will have something a little closer to OOo whenever there is another problem that requires a reinstall and I am in the middle of a big project and close to my deadline. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . .
On Wed, 2011-01-05 at 19:43 -0500, webmas...@krackedpress.com wrote: On 01/05/11 16:48, RA Brown wrote: On Wed Jan 05 2011 13:12:14 GMT-0800 (PST) webmas...@krackedpress.com wrote: I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? To keep from having problems with the desktop-integration you will have to only install one version of OOo. I have Go-oo 3.2 from the Ubuntu repository and when I installed any of the OOo RCs I have the same problem. If your going to run the straight OOo then there should be no problem. I always remove the installed RC using the Package Manager before installing the next one. Then use the dpkg -i command to install the next. HTH Andy I know that when I wanted to go from the Go-oo to the OOo version, I had to remove the original package completely as well as the menus. It seemed that there was something wrong if I did not remove the original package first and completely. I even had to remove the .openoffice.org folder as well, since something caused the default document to crash and not repair properly. So that was when I installed - finally - this version of OOo. I did not know if I would have any problems when the next version came out, such as the menus and such. I still have not reinstalled all of the extensions I use to use with the old Go-oo version that I started using since I came to Ubuntu back in Feb '10 on this machine. I may have to do a complete reinstall of Ubuntu to solve a problem with one of my software that seemed to have lost a dependency that was not fixed by all the other means in the terminal's options that I found. So this might have been a mute point. To be fair, I also have LibreOffice 3.3.0.1 RC something installed as well, since I wanted to see what it was all about. I may remove it after OOo 3.3.0.x comes out of RC. Or I may just have it there as a spare ODF suite if there is trouble with my copy of OOo, so I can finish my work and then fix the problem. I had to install KOffice the last time that happened and I use Ubuntu's version of GNOME instead of KDE, so this time I will have something a little closer to OOo whenever there is another problem that requires a reinstall and I am in the middle of a big project and close to my deadline. If you are already using OOo from the OOo website, then your system is like mine. (Ubuntu 32 and 64 bit) I use a script to install OOo: #!/bin/sh cd /home/(user)/Downloads/OOo/OOO330_m18_native_packed-1_en-US.9556/DEBS sudo dpkg -i *.deb cd desktop-integration/ sudo dpkg -i *.deb Extract the installation files. In the second line, list the location of the OOo installation files instead of the location I use. Save these 5 lines as a text file with a meaningful name. Change the file's permission to make it executable. Open a terminal window. Run this script file. You will be asked for your user password. Enter it, and the script should install OOo and update the Office section of the Main Menu. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Importing spreadsheet into database
On Wed, 2011-01-05 at 16:06 +0100, Andreas Säger wrote: Am 05.01.2011 02:21, Jeffrey Needle wrote: It's actually pretty easy. 1. Create your database table in base. For ease of use, make sure the fields are in the same order as they are in the spreadsheet. 2. Go to your spreadsheet, press Ctrl-A (to select all records), and the Ctrl-C, to copy the records to the clipboard. You can also use the Edit dropdown menus to accomplish the same thing. 3. Go back to your database, right-click on the table you've created, choose Paste, and all the records are sent to the database table. A simple copy and paste -- and works wonderfully! No, it doesn't work that wonderfully. With default settings all columns become optional VARCHAR fields of lenght 255 which renders the table useless and bloated. I've had no such problems. Set field types and widths, and all is well. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to underline a blank line of text, such that it could be typed?
At 02:30 06/01/2011 +0200, Dotan Cohen wrote: On Mon, Jan 3, 2011 at 00:13, Brian Barker b.m.bar...@btinternet.com wrote: [...] Here's another suggestion: o Put a left tab stop at the right margin (er, or perhaps right at the left, depending on your locale!). o Press Tab followed by Enter the required number of times. o Select all the lines and go to Format | Character... | Font Effects | Underlining (or right-click | Style | Underline, or click the Underline button in the Formatting toolbar). o If the entered text is not justified, this will leave the space at the end of each line not underlined. If this matters, you can add a Tab character at the end of each line. Thanks. Assuming Left to Right (it's not, as you properly guessed, but in the interest of a useful archive let's assume that it is) then what exactly is being accomplished here? I seem to have gotten lost after the second step, I must be putting the tabs in the wrong place, but if I understand what it is that you suggest then I may be able to cope. The idea is that each line is actually a separate paragraph consisting simply of a tab character, skipping to the right margin. And it happens that if you apply the character property Underline to such paragraphs, the otherwise empty lines are indeed underlined. You then need to type any text at the beginning of such lines - before the tab character. A single line then becomes a paragraph of underlined text with the tab character at its end, and this carries the underlining to the end of the line. If the text wraps to more than one line, the underlining is continued, with the small problem that - in the case of unjustified text - any unused part of the line will not be underlined. As I mentioned, you can solve this, but only by the messy technique of putting tab characters back at the end of each line - after you have finalised your text, of course. You may think that you can do the same sort of thing using space characters instead of a single tab character. That appears to work until you type your text: then any trailing spaces cease to be underlined, so the idea fails. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: How to underline a blank line of text, such that it could be typed?
On 01/05/2011 04:36 PM, Dotan Cohen wrote: On Mon, Jan 3, 2011 at 08:45, Bob Estesbob_es...@comcast.net wrote: What you really need to do is set up an online form with fill-in fields. That sounds about right. Start with a new document and type in the necessary boilerplate. Check. Insert the fill-in fields with the desired formatting and default answers. (i.e. underlining, etc.) Here I got lost. Could you be more specific? From where does one insert the fill-in fields? Certainly not from Insert-Field, which is a completely different usage of the term field. Thanks! Try InsertFieldOther. Set the format. (i.e. text, general, etc.) Display (view)the field shading, select the field, and underline it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
