Re: File locked for editing by unknown user

[Joost Andrae]

Hi John.

perhaps removing the file .lock within the Windows user directory fixes 
your problem


C:\Users\Your_Username\AppData\Roaming\OpenOffice\4\.lock

Am 14.12.2023 um 12:10 schrieb John Mehta:

I've just activated the RansomeWare option in my AntiVirus program and now
get the message "File locked for editing by unknown user" when I try to
open an existing text or spreadsheet. I can open a copy, edit that, and
save it with a new file name.
But how can I unlock my files to continue using the original file names?



Kind regards, Joost


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

Re: Spreadsheet

[Joost Andrae]

Hi,

the easiest way to fix this within a spreadsheet is to do a 
search&replace with regular expressions option activated.


open the search&replace dialog using Ctrl+F and activate "regular 
expression" within the "more options" part of that dialog.


search: .*

replace: &

This will remove all trailing single quotes from cells.

Kind regards, Joost

Am 26.06.2023 um 16:00 schrieb Martin Groenescheij:

Hi Frank, Please fix the Cells first.



Make sure all are formatted as Numbers and check that no value is preceded with 
a apostrophe ' .












 On Sat, 24 Jun 2023 18:22:15 +0200   wrote ---





Thank Martin, havn't tried it yet. I seem to take one step forward and two 
back. Last time I tried to build this spreadsheet Im could do a multiplication 
like A1*A2 then grab a symbols in the bottom right corner of the cell and drag 
it down to get B1*B2 etc. Now I can't get the symbol.

Sorry to be pain in the proverbial

Frank




On Saturday, 24 June 2023 at 16:41:40 BST, Martin Groenescheij 
 wrote:







=SUM(A1:A14) Not =SUM(A1;A14)










 On Sat, 24 Jun 2023 12:10:33 +0200   wrote 
---





Thanks Martin, moving on I am now having trouble summimg a column of numbers 
(each being the result of a multiplication). In the formula bar Iwant to  type 
sum(A1;A8) but ~I am trying to chick on the cells A1 etc which puts the cell in 
the formula but when I hit ; the whole formula is replaced with the colon.

Frank




On Friday, 23 June 2023 at 18:02:56 BST, Martin Groenescheij 
 wrote:





Could it be that one ore both Cells is formatted as Text?

If you copy values from another source it could be copied as text which you 
could check in the formula bar, it shows then with a leading apostrophe e.g. 
‘123



Simple way to check is to enter =VALUE(B1)*VALUE(C1)

















 On Fri, 23 Jun 2023 18:40:36 +0200 
mailto:frank.ledb...@sky.com.INVALID 
wrote 



Having problem multiplying the values in two cella.I have tried =B1*C1 for 
example but it doesn't workDisappointed as my attempt at division worked fine 
on a previous worksheet using for example=A1/B1Please help if you canFrank




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

Re: Can't edit my PDF files

[Joost Andrae]

Hi,

maybe you're looking for this OpenOffice extension:
https://extensions.openoffice.org/en/node/17351

Kind regards, Joost

Am 24.05.2023 um 15:48 schrieb W. Robert J. Funnell, Prof.:

David -

My first thought is that in the past you were scanning your documents with 
optical character recognition (OCR) turned on, and that now it's turned off for 
some reason.

With OCR turned on, the PDF file contains the actual text and also an image of 
the page. With OCR turned off, the PDF file contains only the image.

- Robert


From: David Di Giacomo 
Sent: May 24, 2023 09:09
To: users@openoffice.apache.org 
Subject: Can't edit my PDF files

Hi,
   My name is David Di Giacomo and I have been an Apache Open Office user 
for many years and have never encountered any problems with it. I think it is a 
great program. However in the last 2-3 weeks I have encountered a problem, it 
will not allow me to edit imported PDF documents.
I will explain what process I have always used in order to implement Open 
Office,
1.) I scan a required document on my HP printer and send it to my computer as a 
PDF file.
2.)I then open the scanned document, highlight it and then press control/C to 
copy this document.
3.) I then open Open Office and click on Text Documents, when the Open Office 
blank pages appears I then press control/V to paste this document. I have 
always used this method and never have had any issues.
This is where my problem begins, when the importation to Open Office has been 
completed,  the document does appear but is imported with small squares on each 
corner and middle outer edges. I then click my cursor outside the document and 
the squares disappear but as soon as I go back into the body of the document a 
cross hair symbol appears which allows me to relocate the document but will not 
allow me to edit any of the text.
Telstra has downloaded all extensions but unfortunately it still did not work.
I really would appreciate if you can assist me with this problem for as I said 
before I really like using this program.
If you can't fix this problem could you please suggest an alternative program.
   Best Regards
 David Di Giacomo







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

Re: Help neede IN GERMAN

[Joost Andrae]

The question of the user has been answered directly by email.

Regards, Joost

Am 11.02.23 um 19:08 schrieb Michael Ferlings:

Hallo,
während der Arbeit
hat sich plötzlich die Menüsprache bei Open Office von Deutsch auf 
Englisch geändert. Trauriges Smiley

Wie kann ich das wieder zurück stellen ??
Grüße





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

Re: Cell grid lines not printing

[Joost Andrae]

Hi James,

the cell grid lines won't print. You have to add cell borders (menu item 
/Format/Cells.../ tabpage Borders; within the format bar there's also an 
entry called Borders)


Kind regards, Joost

Am 05.12.2022 um 15:25 schrieb Jim Munroe:

When I create a new spreadsheet showing the cell grid lines, when I print it 
the grid lines are not showing – how do I make them print?

James Munroe
1 Badgers Corner
East Goscote
LEICESTER
LE7 3WS email: jim.mun...@btinternet.com



Sent from Mail for Windows






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

Re: Embedded link

[Joost Andrae]

Hi John,

it depends on what kind of link this is.

If you dragged a document from the systems file manager then this object 
might be embedded as OLE object. If you doubleclick onto this object 
then the assigned application will open as object within the 
spreadsheet. To remove the object just select it and press the delete 
button.


If it is a hyperlink then allocate the cell cursor to a cell next to the 
cell containing the hyperlink, then use the keyboard to go the the cell, 
press the F2 function (edit mode) key and delete the content of that cell


If it is a form control object (eg. a button or a combo box) then select 
the select button in menu item /View/Toolbars/Form Controls/, select 
that object in design mode (on) and press the delete button.


Kind regards, Joost

Am 22.08.2022 um 11:51 schrieb John Mehta:

Hi,

I've got a link to one of my files embedded in a spreadsheet. I don't know
how it got there and I want to get rid of it. It's not associated with any
cell but it is always in the same place in the spreadsheet. I can't select
it by right clicking my mouse and left clicking opens windows explorer at
the referenced file.

Can anyone tell me how to remove this embedded link, please?

John.






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

Re: Fragen zu AndrOpenOffice

[Joost Andrae]

Hallo Marco,

AndrOpenOffice ist ein von Apache OpenOffice unabhängiger Fork des von 
Apache OpenOffice angebotenen Sourcecodes.

Idealerweise sprichst Du den Entwickler mal direkt auf seinem Blog an:

https://andropenoffice.blogspot.com/

Grüße, Joost

Am 27.01.2022 um 10:37 schrieb Marco Dressel:

Sehr geehrte Damen und Herren,
ich habe mir kürzlich die Vollversion von AndrOpenOffice gekauft. Die
Rechtschreibfunktion funktioniert leider weiterhin nicht. Und ich möchte
auf NAS zugreifen, sobald ich dies versuche, schließt sich OpenOffice
meistens automatisch.
Ich bitte sie um Hilfe, meine Probleme zu lösen.
Vielen Dank!

Mit freundlichen Grüßen
Dreßel





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

Re: Site en français

[Joost Andrae]

Bonjour Pierre,


voilà:

http://www.openoffice.org/fr/

Télécharger OpenOffice en français:

http://www.openoffice.org/fr/Telecharger/

Cordialement, Joost


Am 04.01.2022 um 15:19 schrieb Pierre POMMIER:


Bonjour

Comment mettre a jour Open office en français

Merci




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

Re: Bug report openoffice 4.1.10 Mac

[Joost Andrae]

Hi,

transparency is not part of the cell formatting options but of the 
graphics object formatting options.


I suspect you're using a Mac OS system:

Regarding crashes when using transperency it might be possible that it 
is a problem of the Quartz graphics system of Mac OS. The graphics 
system Quartz is based upon PDF. Quartz AFAIK doesn't support transparency.


You could try out the printing output options in /tools/options/printing 
to reduce or disable transparency to avoid this crash.


Kind regards, Joost

Am 01.10.2021 um 13:00 schrieb Rishi Giovanni Gatti:


Good morning,

I need to report a bug.

How to reproduce:

Create a new empty spreadsheet.
Select a few cells.
Color the background with any color.
Chose some cells into the so colored cells.
Apply TRANSPARENT BACKGROUND.
The application crashes immediately when you push the transparent background 
button.

Regards





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

Re: Arabic Content

[Joost Andrae]

Hi,

in OpenOffice the option CTL (complex text layout) needs to be enabled.
You can find this in menuitem /tools/options/language settings/language
Within the listbox CTL you can choose Arabic as defalt document language.

Kind regards, Joost


Am 04.07.2021 um 06:17 schrieb alwjeeh 77:

Hi
Does Openoffice Support right to lift languages such as Arabic?

Sent from Mail for Windows 10






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

Re: A question

[Joost Andrae]

Hi,

when inserting a photo into a Writer document then mostly the photo 
dimensions are bigger than the width of the page.
You can select the photo and resize the photo (or any other graphical 
object) symetrically by pressing Shift+Strg and then selecting one of 
the handles which you can see when you mouse select the photo first an 
then drag the size to the size needed.


You can place a photo whereever you want by changing the anchor of that 
object to 'page'. Select the photo then take look into the frame object 
bar. There's an anchor symbol. By pressing this button a little menu 
pops up where you can select 'page'


Hope it helps...

Kind regards, Joost



Am 29.06.2021 um 14:52 schrieb Dan Lewis:
A photo can be placed wherever you want to do so the way you want to do 
it. However, this requires the knowledge of styles. This has been ever 
since OOo.org 1.0. The Writer Guide contains a chapter on styles. The 
Writer chapter in the Getting Started Guide does also. One of these two 
guides also contains a second chapter on styles. Search for these books, 
download them, and study these chapters. You should have no problems 
afterwards.


You have written this email to a mailing list, and I among a vast number 
of people have read it. I have sent you a CC so you would see what I 
have written also to this mailing list. Please, if you have more 
questions about Open Office, email them to the mailing list and not to 
any of the people who also reply to your question.


Dan

On 6/29/21 7:51 AM, Dean Bauwens wrote:

Dear Sir,
Dear Madam,

This morning I had some difficulties with Openoffice.

Why not provide a rotary knob for photos in a writing
When you want to add an image in a text, openoffice always placed it 
in the length (horizontal).

Are photos mathematically constructed with values?
Could you explain why I had to put this in a table first.

Yours Sincerely,
Dean Bauwens







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

Re: Excel equivalent

[Joost Andrae]

Hi Brian,

a literal is a text. If you want to replace a number which is formatted 
as text by having a single quote as the first character then you can 
start the replace string with a single qoute ' to leave it as a literal.


Alternatively you can format this number string as text (menu item 
format cell)


In both cases search&replace replaces the string accordingly

Kind regardsm Joost


Am 03.05.2021 um 14:09 schrieb Brian Barnard:

In your spreadsheet handler I recently tried to edit a column of literals
(all numeric) but your find and replace would not replace the
characters that I entered with the new ones.  In the same column were
alphabetic literals and I could replace these with no problem.  As a result
of this I have had to buy Office 2019 and uninstall Open Office





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

Re: Wijziging van Open Office 4.1.9US naar Open Office 4.1.9 NL

[Joost Andrae]

Hi Luc,

U kunt het taalpakket NL installeren en dan de taal wijzigen onder
Menu-Onderdeel /Tools/Options/Language Settings/Languages

eg.
https://sourceforge.net/projects/openofficeorg.mirror/files/4.1.9/binaries/nl/Apache_OpenOffice_4.1.9_Win_x86_langpack_nl.exe/download

Kind regards, Joost

Am 23.04.2021 um 10:27 schrieb Luc Callens:

Verkeerdelijk  download versie US
Update naar Open Office 4.1.9 NL Nederlands  lukt niet.
Melding Open office is al geinstalleerd.
Nieuwe installatie NL wordt vroegtijdig voltooid en afgesloten.
Kan bestanden met Open Office niet meer openen of bijwerken.

Verzonden vanuit Mail voor 
Windows 10





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

Re: spellcheck - continuously causing problems

[Joost Andrae]

Hello Chris,

please check the setting for the default document language in menu item 
/tools/options/language settings/languages


Kind regards, Joost

Am 12.04.2021 um 11:42 schrieb Chris Addington:

hi

openoffice spellcheck

spellcheck constantly causes problems - in standard new text document 
(selecting top lhs symbol) it doesn't work


have setup a template new text document in which spellcheck works from 
time2time


-> openoffice is unreliable




regardschris






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

Re: Bug using OpenOffice and Microsoft Office together

[Joost Andrae]

Hi Ewald,

select a docx document in WindowsExplorer (single click in the document 
name) and select "Open With..." (öffnen mit...) via context menue (right 
mouse button click) and select MS Word to open this document with it. 
Wihin this dialog there is a checkbox where you can select to always 
open documents with this file extention with whatever application you 
select.


When you installed OpenOffice within the setup program you selected to 
open MS Office documents wit OpenOffice


Kind regards, Joost

Am 11.02.2021 um 13:30 schrieb ewald.jan...@mnet-online.de:

Hello,

  


I searched in your FAQ for my problem but could not found a solution.

  


The problem:

I have installed OpenOffice together with Microsoft Office 2019 both with
newest versions. I’m working with Windows 10 Home 64-Bit newest Version.

If I use Windows menus in order to call a new Word document, I cannot find
Microsoft Word:

   

  


I searched for the reason and finally found the reason: installing
OpenOffice a registry entry reserved for .docx will be changed by OpenOffice
to “OpenOffice.docx”:



  


Normally (if no OpenOffice installed) this entry contains “Word.Document.12”
as I can see in my notebook with Windows 10 Home 64-Bit and Microsoft Office
2010).



  

  


What to do for a solution?

  

  


Thanks for your help and sincerely

  


Ewald Janker

Stiftsbogen 33

81375 München

mailto:ewald.jan...@mnet-online.de




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

Re: Apache Open Office 4.1.8 ... does it work on 64-bit Windows

[Joost Andrae]

Hi,

the application runs very well on my 64 bit Windows 10.

Kind regards, Joost

Am 02.01.2021 um 17:34 schrieb Nic Cols:

I have a new MS Surface, running Windows 10. Can I run AOO 4.1.8 on it?

Nic Cols
Garner NC
706-570-9859





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

Re: I need help with an Open Office Writer task.

[Joost Andrae]

Hi Linda,

maybe changing the "After" default in menu item Format->Numbering on the 
tabpage Options might do what you want.


Kind regards, Joost


Am 05.12.2020 um 19:27 schrieb Linda Hull:

I have Open Office 4.1.6 on Windows 10.

I opened an archive with 7Zip, and in it, I have several files.  Each file
is a book of an Aramaic translation to English, of the Bible, having
several chapters.  Each chapter has verses numbered 1. 2. 3. etc.

In order to use the files in an IRC Eggdrop bot, we need them to be 1:1.
1:2. 1:3. and so on, for each chapter, so 12:1. 12:2. 12:3. etc etc.

There are twenty-seven books in the New Testament of a standard Christian
King James Bible, and that is 260 chapters, about 7,958 verses (varies by
translation).

This is a formidable task.  Is there a way to use OpenOffice to
automatically insert the correct Chapter numberings?


An example, showing a Chapter break:

28. Him whom we preach; and we teach and we educate every person in all
wisdom, to confirm every person as perfected in Yeshua The Messiah;
29. For in this I also labor and fight with the help of the power that is
given to me.

Colossians Chapter 2

1. But I want you to know what struggles I have for you and for those in
Laidiqia and for those others who have not seen my face in the flesh,

*

The material is not really .txt it is a series of Word documents.

I hope you can help?

Thanks a lot!

Linda





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

Re: Default Value field in a table formatted to Date

[Joost Andrae]

Hi,

I'm not quite sure what you like to accomplish.
Within Calc you can use the formula TODAY()

So if you enter =today() into a cell you'll get the current date.
If you save this within a spreadsheet document and if you load that 
document then this cell will show you the current date.


Kind regards, Joost

Am 12.11.2020 um 09:04 schrieb DAB DAB:

Hi, I am new to openoffice and have used MS Access in the past. I have created 
a table called Customers and have 3 fields CustomerID, Name and Date. The date 
field type is date. When I open the table I want the Date field to default to 
today’s date so I don’t have to keep inputting a date.

What is the best way to do this in openoffice?

Sent from Mail for Windows 10






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

Re: openoffice issue

[Joost Andrae]

Hi,

maybe the developers of https://github.com/sbraconnier/jodconverter can 
help you.


Kind regards, Joost

Am 08.09.2020 um 06:51 schrieb 17734808...@163.com:





this is my issue !!!
window 10 and jdk8
I can't find the relevant problem on Google, so I have to ask you to help me 
solve it
9月 08, 2020 12:29:05 下午 org.artofsolving.jodconverter.office.ProcessPoolOfficeManager 

信息: ProcessManager implementation is SigarProcessManager
1 [OfficeProcessThread-0] DEBUG Sigar  - Failed to load sigar-amd64-winnt: can 
not find lib path
org.hyperic.sigar.SigarException: Failed to load sigar-amd64-winnt: can not 
find lib path
at org.hyperic.sigar.Sigar.loadLibrary(Sigar.java:170)
at org.hyperic.sigar.Sigar.(Sigar.java:100)
at 
org.artofsolving.jodconverter.process.SigarProcessManager.findPid(SigarProcessManager.java:34)
at 
org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:59)
at 
org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:54)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:113)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess.access$000(ManagedOfficeProcess.java:25)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess$1.run(ManagedOfficeProcess.java:52)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run$$$capture(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Exception in thread "main" 
org.artofsolving.jodconverter.office.OfficeException: failed to start and connect
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:58)
at 
org.artofsolving.jodconverter.office.PooledOfficeManager.start(PooledOfficeManager.java:96)
at 
org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.start(ProcessPoolOfficeManager.java:56)
at com.kh.thunder.controller.OfficeToPdf.getOfficeManager(OfficeToPdf.java:72)
at com.kh.thunder.controller.OfficeToPdf.office2pdf(OfficeToPdf.java:106)
at com.kh.thunder.controller.OfficeToPdf.openOfficeToPDF(OfficeToPdf.java:39)
at com.kh.thunder.controller.OfficeToPdf.main(OfficeToPdf.java:28)
Caused by: java.util.concurrent.ExecutionException: 
java.lang.UnsatisfiedLinkError: 
org.hyperic.sigar.ptql.SigarProcessQuery.create(Ljava/lang/String;)V
at java.base/java.util.concurrent.FutureTask.report(Unknown Source)
at java.base/java.util.concurrent.FutureTask.get(Unknown Source)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:56)
... 6 more
Caused by: java.lang.UnsatisfiedLinkError: 
org.hyperic.sigar.ptql.SigarProcessQuery.create(Ljava/lang/String;)V
at org.hyperic.sigar.ptql.SigarProcessQuery.create(Native Method)
at 
org.hyperic.sigar.ptql.ProcessQueryFactory.getQuery(ProcessQueryFactory.java:66)
at org.hyperic.sigar.ptql.ProcessFinder.find(ProcessFinder.java:68)
at org.hyperic.sigar.ptql.ProcessFinder.find(ProcessFinder.java:56)
at 
org.artofsolving.jodconverter.process.SigarProcessManager.findPid(SigarProcessManager.java:36)
at 
org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:59)
at 
org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:54)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:113)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess.access$000(ManagedOfficeProcess.java:25)
at 
org.artofsolving.jodconverter.office.ManagedOfficeProcess$1.run(ManagedOfficeProcess.java:52)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run$$$capture(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)





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

Re: Spreadsheet Formula Hiding "0"

[Joost Andrae]

Hi,

you can also format those cells using the user defined cell format # to 
suppress so called leading zeroes in cells.


->format->cells->numbers->Format Code: #

Kind regards, Joost

Am 02.06.2020 um 00:51 schrieb David Robley:
There is an option to globally suppress display of zeros - see Tools | 
Options | OpenOffice Calc | View and uncheck Zero Values in the Display 
section.


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


On 2/6/20 7:43 am, Snapafun wrote:

Great suite - Thanks.

I love to hide the "0" value in cells yet to be populated and to do so 
I use the =IF(Target Cell>0;Actual Formula;"") setup.


This works well for me upon the Target Cell being the result or a 
manual entry.


However, this doesn't work when the Target Cell contains a formula. ( 
I appreciate that the formula setup as above is correct and that it 
now recognizes that the Target Cell is populated so is ">0" - just 
that viewed in real life - no actual value yet exists.)


Maybe there's a way of re-addressing the value "0" in the 1st part 
though it would be nice for a private user to be able to keep their 
formulas simple.


So - not necessary a fault or bug or anything at all - just a thought 
in case it's possible.




Cheers




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

Re: Registering a Template in Calc

[Joost Andrae]

Hi VinceB,

just use menu item File->Templates->Save...
to save a template.

Within the File->Templates menu you'll find also a dialog to organize 
templates.


Kind regards, Joost

Am 15.05.2020 um 19:04 schrieb WA.TWORSX via AOL:

AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Win10-64 bit Home w/desktop PC




I am wondering if there is a better method to use to "register" a newly 
created template in AOO-Calc.  What I have just done is;


1. Delete content of any and all cells that contain numeric data and/or
    unwanted text strings within an existing, similar, Calc spreadsheet
    (.ods)
2. Save the spreadsheet file in a template file format (.ots)
3. Use Windows File Explorer to drill down to the 'template' folder,
    (C:\Users\username\AppData\Roaming\OpenOffice\4\user\template), and
4. Save the newly created template

Step 3. above takes a bit of time to finish.  Is there an easier way to 
accomplish this task within AOO-Calc?  Can someone point me to the 
relevant documentation or offer an easier procedure?


Thanks for reading this, and please stay safe.

VinceB.








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

Re: Connecting to database remotely

[Joost Andrae]

Hi,

if you have installed a 32 bit java (I would recommend Java 8 in this 
case and it should be 32 bit because OpenOffice is 32 bit) and you've 
connected OpenOffice with the installed Java via menu item 
tools->options->OpenOffice->Java

then you can setup a JDBC remote connection to your database

click on "Database" on the OpenOffice dashboard
check the "connect to an existing database" radio button
then click on "Next >>>" button

place your cursor into the field "Datasource URL" and press the F1 key 
where this kind of unified resource locator (URL) is discribed more 
deeply (eg. mysql://hostname:port/database_name)


If you run both your desktop PC and your notebook within the same 
network you have to check the IP address (or hostname) of your system 
you want to connect to


Checking the IP address of this system:
press the Windows button (start menu)
type cmd and open the command line
type ipconfig /ALL
note the IPv4 address because this is the address you have to add to the 
hostname part of the datasource URL


You have to know the port address of the database and you have to know 
the name (eg. accounting) of your database you want to connect to.


Maybe you need to install a database driver on your client system. This 
driver has to be selected then.


An alternate variant can be the connection using a ODBC connection
This connection has to be configured within the ODBC settings dialog 
(search for ODBC in Windows system settings). Once set up within your 
Windows system the configuration within OpenOffice is quite similar.


Kind regards, Joost



Am 16.05.2020 um 09:50 schrieb Jose Molina:

Im trying to connect to a database created on my laptop running on windows 10 
pro and trying to connect it so I can open it on my desktop running on windows 
10 home. How does one do that, exactly?

Sent from my iPhone





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

Re: Email App from Openoffice

[Joost Andrae]

Hello Anan,

the standard email app is a setting within your MacOS system

open the settings of "Mail"

There it should be possible to define the standard email app

Kind regards, Joost


Am 12.05.2020 um 10:55 schrieb Anan Narang:

Hi

I have been using open office for a while on my macbook, on most of the files i 
have client contact emails, usually when i click on these email address, the 
apple mail application open up for me to continue writing the emails to 
selected email address from the .ods file, however this seems to have changed i 
recently downloaded new version of open office, and when i now click the email 
address links on the file instead of apple mail opening up the web browser open 
with my gmail account.

How do i change this back to opening to Apple mail

thank you





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

Re: Difficulty to control printing of a Calc file

[Joost Andrae]

Hi VinceB,

use the menu item /View/Page Break Preview/

In this view you can easily drag the blue lines displayed on the page 
where you want to, eg. if you want to scale the content to one page 
printouts then drag the right line of the "Page 1" line to the outer 
right side.


Using the right mouse button within this view you can define manual 
column or row breaks at any positon you want.


Or mark the content you want to print and press the right mouse button 
and select the context menu item "Define Print Range"


Afterwards you can leave this "Page Break Preview" by selecting menu 
item /View/Normal/
All settings are persistent until you close the document. If you save 
the document this setting is persistent if you close and reopen the 
document.


In menu item /File/Page Preview/ you can use the slider to scale the 
document to something you want to look it like.


If page margins do not fit then you can control these in menu item 
/Format/Page/ on the tab page "Page". Within this dialog click into one 
of the fields Left, Right, Top or Bottom. If you now press the PageDown 
button on your keyboard then the dialog automatically selects the 
minimum setting for this page margin the operating system configured 
printer driver supports.


Kind regards, Joost Andrae



Am 30.04.2020 um 17:58 schrieb WA.TWORSX via AOL:


AOO415m1(Build:9789) -  Rev. 18174962017-12-11 17:25

win10x64 home desktop

--

It seems that print-settings for my Calk file do not stick. (Wasted 
several sheets of ink.) A change of page-breaks also causes a change of 
scaling, or width, of the printed document. Is that normal?



Please, someone remind me of which slider control, near top  or near 
bottom of screen, actually controls print-output scaling factor and 
which controls the screen scale factor. I might be using the incorrect one.



Please be well and stay safe.


VinceB.




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

Re: ASCll Filter Options

[Joost Andrae]

Hello,

OpenOffice does not import PDF documents. It only exports files into PDF 
format. If you want to import PDF files then you might want to add a PDF 
import extension from https://extensions.openoffice.org/


I still use the Oracle one.

Kind regards, Joost


Am 21.04.2020 um 04:23 schrieb KAS955:

Hello. I am located in Canada. When I click on a pdf document in my list of 
documents (File/Open) it brings up the window noted above ASCll Filter Options. 
The Character Set comes up as Western Europe (Windows-1252...) If I say OK, I 
can’t read the document. I don’t see an option for Canada or North America... 
can you advise what I should do?
Thank you.

Patricia Bruneau
Strata KAS955






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

Re: Spreadsheet

[Joost Andrae]

Hi Gerry,

you can work wit cell templates. Therefor open the template dialog by 
using function key F11 and create a new one by pressing the right mouse 
button ontop of this dialog. Then select the "New" link. Hint: Assinging 
a name to this template helps...


The function you want to use then is the water can button where you can 
assign multiple cells with all that formating defined within the cell 
template.


Otherwise (without using templates) you could also multi select all 
those cells there you want to change the colour and then assign the 
background colour at once.
In the icon bar you find a button for background color. Press it once 
and then select the dialog title and drag it somewhere else (select the 
title and hold down the right mouse button)


Using templates is a very powerful tool as it allows you to work with 
inheritance of templates so a child template can inherit objects of it's 
mother template. And cell templates can be exported to an other 
document, so you can easily create a template library.


Based upon the usage of cell templates it's quite easy to use the 
feature of conditional formatting (Format menu)


Kind regards, Joost


Am 20.03.2020 um 16:19 schrieb Gerry Woodard:

I would like to not have the color table change to the cell color when
selected. I would prefer that the color selection indicator remain fixed
until needed. For example, if I want to change several cells from red to
black, need only select black once from the table, Hope this is clear.
Thanks.
Jerry Woodard
*.* “Energy and persistence conquer all things.”* – Benjamin Franklin*
* “Make America Great Again.” - Donald Trump*





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

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[Joost Andrae]

Hi,

if you format cells using a cell formating template (function key F11)
then you can easily change this cell formating by changing the cell 
formating template (eg. by adding background color red to this 
template). If you change this template then all cells where you assinged 
the template to change it's formating immediately.


It think it's a better way then using search&replace.

Kind regards, Joost



Am 14.03.2019 um 19:44 schrieb Martin Groenescheij:




On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL  
wrote:


Hi David:

I do not think you understand what I am attempting to do, so I'll try to 
clarify what my goal is.

In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I meant to 
type that word in Bold font.  Is there a way to change the already typed word 
(e.g., Goes) to be in bold font by use of the Find & Replace function?


You can use Conditional Formatting to make a whole Cell bold, just check if the 
Cell contains “Goes” and create a new Paragraph Stype.



I am not attempting to highlight an area within the spreadsheet.  I do not 
program in vbs, or any other language for that matter. :-) Years ago, I started 
to learn machine language for the Motorola 6809E chip, but have not ever put 
what I learned to use.

TNX for your reply.


VinceB.




On 3/14/2019 11:54 AM, David Belina wrote:
The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For example, if the
cell presently shows:

 Goes

I want it to be replaced with:

*Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected:  Fewer Options,
with none of the boxes checked.  I have also selected: Search in:
"Values" (near the bottom of that window).
**

Is there a way to change / replace the assigned attributes when using
Find & Replace function in AOO-Calc Spreadsheets?

Regards,

VinceB.







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

Re: Font support

[Joost Andrae]

Hi Bill,

if your system does support Persian input and if it supports Persian 
fonts then you might want to configure Complex Text Layout in menu item 
/Tools/Config/Language Support/Languages


If you activate the checkbox within this dialog for CTL then you can 
select Persian language support. You probably have to restart OpenOffice 
to activate the changes.


If you activate CTL then OpenOffice activates the support for RTL (right 
to left) input schema, etc.


Kind regards, Joost

Am 07.01.2018 um 07:59 schrieb Bill & Janet Washington:

Hi Folks,

     I frequently print out some Persian (Farsi) documents for some 
Persian friends, but Open Office often does not play nice with the Farsi 
font which is written right to left.


when I cut and paste the text into a Writer page some text displays 
correctly, some displays as blocks and some runs off the page.


Sometimes I can get the blocks to display correctly by adding carriage 
returns or spaces,


For example try cutting and pasting a block of text from this web page:

https://www.bible.com/bible/118/JHN.1.nmv

to a Writer Document.

This occurs with Open Office 4.1.5

When I cut and paste the same text into Word it displays correctly - The 
only Font package installed is "English"


Is it possible to correct this anomaly?

Best Regards

Bill Washington







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

Re: Question about Calc

[Joost Andrae]

Hello Herbert,

select a cell range (all the cells you want to have within your chart) 
containing some data (including textual headers of the columns and rows, 
like within the example below)


Apples  Bananas
Monday  1,00 €  2,00 €
Tuesday 4,00 €  4,00 €
Wednesday   3,00 €  5,00 €
Thursday5,00 €  2,00 €
Friday  4,00 €  4,00 €
Saturday3,00 €  3,00 €

Then click the chart symbol within the symbol panel or select menu item 
/Insert/Chart (in the German localization it's called Diagramm)


Within the chart dialog you can select the chart type, the data range 
and you can define if you want to have the data visualized in rows or in 
columns. You may also define a title, sub title, and the description of 
the x or the y axis. After finishing the dialog by selecting the finish 
button you have an embedded chart object within your document.


When double clicking the embedded object you open this object within the 
inplace mode where you can select each chart object to do some 
formatting like changing the background colour and many more things. 
(tip: select an item and do right mouse click)


Kind regards, Joost

Am 26.08.2017 um 19:44 schrieb Herbert Gnaś:

Hello,

I am making a chart in the Calc program, how to make the values visible on
the chart?

Regards,
Herbert Gnaś





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

Re: Open Office writer Hebrew Language

[Joost Andrae]

Hi Neal,

you're looking for this ?

http://sourceforge.net/projects/openofficeorg.mirror/files/4.1.2/binaries/he/

Maybe you want to install the language package (langpack) ontop of your 
installation. Afterwards you can switch the application language in menu 
item /tools/language (and then restart OpenOffice to make it happen)



Am 22.12.2015 um 14:04 schrieb neal jacobs:

I presently use OO 4.2.1 writer English. I would like to have Hebrew as a
second language using the open office writer. Please advised me how I can
install the Hebrew language.
Thank you,
Neal Jacobs




Kind regards, Joost


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

Re: Open office multiple instance

[Joost Andrae]

Hi,

yeah this link is much better!


Am 13.12.2014 um 16:36 schrieb Rajesh Kher:

Try this link

http://www.openoffice.org/docs/setup_guide/mu_install.html



Kind regards, Joost


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

Re: Open office multiple instance

[Joost Andrae]

Hi,

I assume you just started the setup program and installed the 
application but this way OpenOffice is not prepared for a multi user 
environment. Please take a look at the following WIKI entry:


https://wiki.openoffice.org/wiki/MediaWiki:Collections/Administration_Guide

Am 13.12.2014 um 08:56 schrieb shivam educational society:

Dear Sir/Madam

I am facing a problem regarding not opening of multiple instance of Open office.
actually I am running a LAN for our Computer LAB in which all the
workstations are connected by N-Computing with Server. Openoffice
packages are installed on server but it is not opening on all
workstations. It support only one instant at a time and displays an
error message on other workstations i.e. "Cannot open on multiple
instant, It is already opened on other instance".
Kindly help to resolve this issue, so that it can can be opened on
multiple instant.



Kind regards, Joost



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

Re: How Do I Change Text in the Legend of a Chart?

[Joost Andrae]

Hi Fred,

you usually just need to change the title of the colums within the 
source data set. If you create a chart within AOO then the chart is an 
OLE (object linking and embedding) object. Such objects share a 
connection to the source data within the document where you create the 
chart. In Writer (the wordprocessor) the source data is usually stored 
within a table and within Calc (the spreadsheet module) the source data 
is part of this document where every element (cell) of this document can 
be a source of a chart. I Calc to find out which table part is used as 
source data then open that document and doubleclick the chart. In this 
case source data for this chart is highlighted. In Writer unfortunately 
it isn't. This would be a useful feature to implement...



Am 23.11.2014 um 19:36 schrieb FC:

 I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit.

 I'm only an occasional chart maker.  I created a chart years ago,
of Column, Stacked, with three Data Sets.

 Will some kind person please remind me how to change the text
in the Legend for the three Data Sets?

 Fred





Kind regards, Joost


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

Re: Error Report Tool

[Joost Andrae]

Hi Andrea,

the retirement for CrashReporter on the Windows platform is somehow 
understandable as the requirement to archive every Windows debug build 
that has been released is too expensive for the project now but on other 
platforms (like on Linux) where the CrashReporter used the backtrace 
functionality of the achitectures system kernel library it would benefit 
AOO's "supporters" because users can provide a stack trace when they're 
asked for. The current developers should re-think about the decision to 
retire the CrashReporter.




This is due to outdated documentation and messages. The error reporting
tool was retired in recent releases. If you have a repeatable way to
cause a crash, please give all details in Bugzilla
https://issues.apache.org/ooo/ or in the Forum (easier)
https://forum.openoffice.org/

Regards,
   Andrea.


Kind regards, Joost



---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Style and Font size

[Joost Andrae]

Hi,

for OpenOffice Writer you'll find the setting in menu item
/tools/options/OpenOffice Writer/Basic Fonts (Western)/

Have fun, Joost

Am 01.03.2014 10:02, schrieb randy.marsh...@telus.net:

How do I set my Style I.e. Arial and Font size 12 to be my default every
time I open "Open Office" I can't seem to figure out where I do this. I don
t want the current default



Love the program



Thanks





---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: OpenOffice 4.0.1

[Joost Andrae]

Moin Hans-Werner,

if you want to use the native Windows file dialog which contains the 
link to the Windows Desktop then you can configure it in menu item 
/Tools/Options/OpenOffice/General.


Nochmal auf Deutsch:
Wenn Du den Speichern-Dialog suchst, welcher die Verknüpfung zum Windows 
Desktop beinhaltet, dann solltest Du auf den nativen Windows Dateidialog 
umschalten. Diesen kannst Du unter /Extras/Optionen/OpenOffice/Allgemein 
einstellen. In diesem Dialog gibt es eine Checkbox zur Nutzung des 
OpenOffice-Dialogs, welche Du einfach nur deaktivieren musst.


Gruß, Joost

Am 19.12.2013 09:29, schrieb Stöver, Hans-Werner:

Hi,

Openoffice was a very good and easy to use program.
With the last versions it got more and more useless.
I was using OpenOffice from the beginning in Hamburg for about more than 14 
years now.
But yet I deleted this for me useless program and I bought Microsoft Office.
Microsoft is expensive, but Microsoft looks what the people need
and not what  the coder likes and puts inside.
Who made the decision to change the "save", "save to" and the "Open" dialog?
Why must I click so many times to find my desktop for saving documents?
Why is the direct link in the saving dialog to "desktop", "network" and "my 
documents" gone?

It is just the same as Adobe it does with the Adobe reader.
In former times it was a very good and useful program.
Now it is big and slow and for presenting and reading PDFs it is useless.
The same happened to OpenOffice.
 From a nice and good program you made a pack of shit.
So keep it and I will use Microsoft Office in future.

In Germany we call this "Kundenverarschung"

Only my minor opinion.

Regards
Hans Stöver





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

Re: Save big file

[Joost Andrae]

Hi,

and once it is loaded you save it using "Save As...". Loading this file 
containing the "repaired" structure loads in an acceptable amount of time.


btw. the file referenced in 
https://issues.apache.org/ooo/show_bug.cgi?id=123457 is really a beast...


Kind regards, Joost


Am 20.10.2013 10:48, schrieb Andrea Pescetti:

TN Patriot wrote:

So yes, there does seem to be a bug with opening and saving large files.


No. Large files, in general, open and save with similar performance in
3.x and 4.0.1, or are opened by 4.0.1 faster than 3.x.

But there are a few problematic files, like the one discussed in issue
123457; this particular file is automatically generated and has invalid
internal pointers, so it is in no way a typical example of "large file".

Regards,
   Andrea.




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

Re: HP LaserJet question

[Joost Andrae]

Hi Doug,

I've an idea what happened to you: Maybe reducing the complexity of 
graphical objects on the printed output may help you.

Go to menu item /tools/options/OpenOffice/printing
and activate both checkboxes to reduce transparency and gradients within 
the printed output. Perhaps that's it because postscript cannot reduce 
such content on it's own and the input data on the printer can become 
very very large.


Am 07.09.2013 01:16, schrieb Doug:

I have an HP LaserJet 2200dn, networked with 3 computers--one normally
running Windows 7 and two normally running PCLOS. From Linux, when
I send it something to print, sometimes--not always--the busy light will
start to flash, and then it may print a couple hours, or a day later, or
never. Other times it will print right away. Does anyone
reading here know of a way to "tickle" it to make it print what it's
sitting on? (Other times, it prints right away.)
(There is no HP support--the printer is over 5 years old, so HP
has disowned it.)


Kind regards, Joost


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

Re: Open Office Org Apache

[Joost Andrae]

Bonjor Richard,

vérifiez les modules orthographiques aux "/Outils/Gestionaire des 
extensions" si il'y à plus de un module pour Francais et inactivez les 
autres modules pour Francais. Je pense que c'est un erreur connu pour 
cette version...


Am 11.07.2013 11:37, schrieb Richard Coatanroch:

Bonjour, j'ai installé open office 3.4 sur mon ordinateur Windows 8,
malheureusement, le correcteur d'orthographe ne fonctionne pas.
J'ai réussi à le faire fonctionner un court instant, puis je suis retourné
sur le site" Langue" et son activité a cessé, un peu comme s'il y avait
quelque chose qui lui interdit de fonctionner. Vouas seriez très aimables
de bien vouloir me donner la solution .
Merci



Cordiallement, Joost


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

Re: color of recorded changes

[Joost Andrae]

Hi Gary,

just enter a name in /tools/options/user data/ or modify one item within 
that dialog. The colors used are differentiated by user data.


Am 10.12.2012 00:45, schrieb Gary Aitken:

How does one determine / change the color used when recording changes to a 
writer document?

I'm working with a .docx from ms word, which I will export as a .odt.
When I turn on Edit/Changes/Record the color used (there are no others in the 
document) is a very difficult to see light tan/yellow.

Is there a way to assign the color used by author?



Kind regards, Joost



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

Re: Spell

[Joost Andrae]

Hi,

Am 14.11.2012 19:11, schrieb Mark Soderburg:

Recently my word processing documents have started to open with virtually
every word underlined in red as if they are all misspelled. Has my
dictionary or spell checker become un-attached somehow? I tried to cure by
a re load of 3.4.1 but no luck.Thanks   I am using windows



please check the installed spell checkers within the application (menu 
item /tools/extension manager/) and if there are dupicates for our 
language. If this is the case then uninstall those not needed within 
that dialog.


If your language is not listed within the extension manager then have a 
look at http://extensions.services.openoffice.org/en/dictionaries
I believe you'll find one to install for your language. There are 
diverse spell checkers available. You just need to choose one of them 
suitable for your language and install it by opening the oxt file. 
Usually your operating system will pass this file to be opened with 
OpenOffice.


Kind regards, Joost


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