Re: Character set

What kind of file is it? What is the file extension? If this is a document that was saved using open office, then the file has probably been damaged. Is this a text file? ⁣Get BlueMail for Android ​ On Aug 3, 2023, 8:49 AM, at 8:49 AM, stevenradeck wrote: >In trying to open a file in OPEN

Re: Incorrect formula of function RECEIVED.

I think that your formula is missing the "discount" or percentage. I have seen the formula published on the Microsoft help pages and it too does not show any derivation.  On Monday, May 01, 2023 12:24 EDT, Vijay Vardhan wrote:  The formula of function RECEIVED for calculating received value

Re: Recovery of documents

If you're hard drive has already been removed from the computer, you might be able to use something like this https://www.amazon.com/Thermaltake-External-Enclosure-Docking-ST0014U-D/dp/B01J4XNLN6 Don't just buy the thing I linked, but understand first, is your hard drive that was removed from

Re: Fwd: Printing on an envelope

I rarely print envelopes, but on my printer, I usually just print landscape and manually feed an envelope. I do use the mechanism to feed an envelope. The problem with that, however, is that some feed the envelope in the middle and some on the right or left side. So I expect this to take some

Re: File is damage

Copy the file (yes, make a copy) and name the file something like  x.zip See if the file can be opened. ODT files are stored in a ZIP format so you should be able to see the files. If the file cannot be opened as a ZIP then the file is likely not recoverable. If you are able to open the ZIP

Re: File Access

What operating system and version? I assume since version of windows. I am not well versed in file permissions on windows or Mac (Linux I know well) Are you able to find your files with the file explorer? If you right click on n a file and look at the properties are you able to see fine

Re: Forgot Password

If it's vital you can try a password cracker, but that would be really slow you'd have to write it as a macro... For that to work it would surely help if you had a good idea what the password was though because each attempt takes time ⁣Get BlueMail for Android ​ On Sep 28, 2022, 9:37 AM, at

Re: Median Function Used as "Between"

The median is found by adding the "middle values" and dividing by two so the answer is 124.5.  B12 contains 121 and 121 is not equal to 124.5. If cell B12 contained 124.5, then the answer would be Yes rather than No.  You could write a macro to determine "between" or just write the comparisons.

Re: Winding OpenOffice down

https://en.wikipedia.org/wiki/Apache_OpenOffice https://en.wikipedia.org/wiki/LibreOffice LibreOffice (LO) Apache OpenOffice (AOO) This is from my memory and I am not checking my facts, so here it goes: I was under the impression that AOO still has contributors The original split was

Re: Reveal Codes

e. I considered extending it, but there is always a question of available time.  Andrew Pitonyak On Monday, March 21, 2022 10:15 EDT, Alan B wrote:  There is no reveal codes in OpenOffice. Reveal Codes was a Wordperfect feature. The Word feature of the same name is activated by Shift+F1. The W

Re: FW: open office not recognizing JRE

I asked Google which versions of Java are supported by open office and if the results are to be believed, you probably should also install open JDK 8. I assume you're running Windows given the tree using Windows email. And yes you can have multiple versions of Java installed at the same time.

Re: OO disappears, forcing people to Libre & then reemerges as Apache...

I'm not going to attempt to address the licensing issues that you bring up, but let me mention something about versioning. Version numbers are rather arbitrary, and if you want to know if something is far behind or not, instead, look at the feature set of the two versions. Don't just assume

Re: Can User Functions Be Created In OpenOffice Spreadsheet

you can write user defined functions it's very easy. The easiest way is to pass the value of a cell and then just return a string or whatever you want. I don't remember what happens when you pass the cell value like that if you are parsing out text and pulling out a URL property it's probably

Re: Open Office for Sraco Co. SAUDI ARABIA

I am a moderator, but I did not approve that specific message.  Well, I think I am. I am moderator for some of the lists.  Seems silly that the moderator list is not available to the other moderators.   

Re: Open Office Frozen Need assistance immediately

I am not certain if Kate has subscribed so I am copying her directly.  Kate is using a Mac that is 14 years old. The OS is version 10.11.6 When AOO is started, it wants to recover her files. But AOO hangs whether she tells it to recover the files or not (my words, not hers, so I might have the

Re: emails

Only partially useful. If John is not aware how he subscribed and how to remove himself, he needs a bit more direction.  https://openoffice.apache.org/mailing-lists.html#:~:text=To%20unsubscribe%20from%20the%20mailing,e%2Dmail%20you%20are%20unsubscribed. I believe that it says that John can

Re: Font Colors

Yes. And, although I think you only wanted a yes or now, in case I was wrong  I did a quick test. Either select the cell (or the text of interest) and click on the A in the toolbar with a colored line under it. You can change the color with the drop down on that icon as well. 

Re: LibreOffice

So are you having trouble downloading Apache open office, or downloading libreoffice? the products are very similar in nature, and started as the same project and then they split. I have been known to use both so that I could test them for different things. If one really stymies you perhaps

Re: Hello my friend/world!?

Which format? Be specific. OpenOffice 3.0 sports docx, for example. ⁣Sent from BlueMail ​ On Aug 30, 2020, 12:09 PM, at 12:09 PM, Casa Casa wrote: >Have though about give support to Microsoft office formats??? I mean >the >new ones. >People will feel encouraged to migrat to your platform which

Re: Open Office Excel

Excellent... And Rory is awesome... ⁣Sent from BlueMail ​ On Aug 26, 2020, 2:13 AM, at 2:13 AM, mermaidl...@gwi.net wrote: >Thanks Shari for responding, > >I was able to sort it out with the help of RoryOF on the forum. Take a >look for more details:

Re: Open Office Excel

What is the documents file extension? I'm How large is the file? If you cannot do it, I might be able to convert it to an ods (calc) file for you. That said, excel may be able to write an ods file directly. It is better, of course, if you do it yourself. If AOO cannot do it, I might try LO

Re: Program question

I might have an example from inside VB in either AndrewMacro.odt or oome.odt on my website. Not a position that I can check that right now. I know I tried it once just to do it but I don't remember the particulars. ⁣Sent from BlueMail ​ On Aug 19, 2020, 11:06 AM, at 11:06 AM, Timothy Cheshire

Re: Get URL from Hyperlink

extent.  On Tuesday, August 18, 2020 18:37 EDT, Steven Ahlers wrote:  Andrew you need to remove the .INVALID from the end of his email address. Sent from my iPhone > On Aug 18, 2020, at 5:25 PM, Andrew Pitonyak wrote: > >  > Nope, sorry, I did the work, but I could not send an email t

Re: Get URL from Hyperlink

> On Aug 18, 2020, at 5:25 PM, Andrew Pitonyak wrote: > >  > Nope, sorry, I did the work, but I could not send an email to your email > address. Did not bother trying to figure out why, might be because my email > is not letting me send the macro attachment, in which case I need to

Re: Get URL from Hyperlink

Nope, sorry, I did the work, but I could not send an email to your email address. Did not bother trying to figure out why, might be because my email is not letting me send the macro attachment, in which case I need to fix my outgoing email server or if yours rejected it. I will look at this

Re: Get URL from Hyperlink

My best guess is that you pasted the macro into the subroutine that is created when a module is created.  I created a Calc Document and then I placed the macro as a module in the standard library of the Calc document. I tested the code and it seems to work just fine.  I will mail you the

Re: Error saving the document_Sharing Violation

to do that. Do you have the link for me to go to so I >can download much faster?Thank you for all your help. I will come to >you in the future when I need help again. Excellent >service!!RegardsGary TSent from my Samsung Galaxy smartphone. > Original message From: Andre

Re: Error saving the document_Sharing Violation

Are you able to use "save as" and use a different name?  On Thursday, July 23, 2020 13:04 EDT, Gary Teckenbrock wrote:  Hello, Getting this on my screen when trying to save files. Running Microsoft Windows 7 professional on Dell XPS laptop version 6.1.7601 Service Pack 1 Build 7601/64 bit with

Re: please help, my whole chapter is unreadable after update

If you want me to test load your document, send a copy to my home email address (assuming there is nothing sensitive) and I can take a peek in case it is just something with your configuration that went bad. I have never seen this so  The fact that the doc loads is a good sign.  A quick

Re: Microsoft payment demand

Microsoft word is probably associated with OpenOffice documents so when he double clicked on one the automatic association probably tried to load a Microsoft product. It is a simple matter to reassociate the file types. I'm not a strong Windows user so I won't even try to provide instruction

Re: more field fun.

I do not have time to look deeply into this, but, I do believe that you can have differnet behavior for left / right pages for a page style. I think they talk about it here: 

Re: Showing number as binary

Can I just say that this is for certain the best solution I have seen to accomplish this. Did not know that you could do that. On Wednesday, February 19, 2020 15:16 EST, Johnny Rosenberg wrote:  Den ons 19 feb. 2020 kl 21:08 skrev Johnny Rosenberg : > Den ons 19 feb. 2020 kl 10:09 skrev

Re: Showing number as binary

I wrote a macro to convert to / from binary. You cannot specify the base or the number of digits. I don't remember if it is published in OOME or AndrewMacro, but but are on my web site for download. ⁣Sent from BlueMail ​ On Feb 19, 2020, 4:09 AM, at 4:09 AM, Andrea Vt wrote: >Hi all :-) >

Re: OpenOffice tech support

Just a bunch of volunteers here, can you post some specific examples? Some of the people here are pretty sharp. I may not be one of them, but many are! :-) On Thursday, February 06, 2020 13:25 EST, i...@tonalrehabandpilates.com wrote:  Good afternoon, I am experiencing unusual formatting

Re: Original Open Office.

If you only have the originals, you might be able to use OCR to convert to text, faster than retyping. I did this with great success since I only had printed copies and then I was able to make changes. ⁣Sent from BlueMail ​ On Dec 3, 2019, 10:21 AM, at 10:21 AM, David Belina wrote: >In order

Re: Fwd: Is Open Office Going Away?

I was not aware of any rumors that it was going away, but if it does, have them download LibreOffice. They have the same root. ⁣Sent from BlueMail ​ On Sep 18, 2019, 11:23 AM, at 11:23 AM, Mike Kuldayev wrote: >Hello, > >I'm working in an online school and our teachers frequently encourage

Re: Captions [was Re: spacing before/after group of paragraphs.]

3 Sep 2019, Andrew Pitonyak wrote: > ... ... It sounds like you might want to add something like "keep > with next paragraph", or something, but, I usually only use that for > things such as captions where I really need to keep the caption with > a figure, table, or code listing.

Re: spacing before/after group of paragraphs.

I think your new description is very good... I missed the point the first time.  This is how I solve a similar problem using styles. My interest is source code, but, very generically, assume you define three different styles names named something like:  first_quote_par next_quote_par

Re: Running OpenOffice and Microsoft Office at the Same Time: Issue

and one final comment, try opening office and then using file open to open the file in question rather than just double-clicking on it, that should get you there until you fix the association problem ⁣Sent from BlueMail ​ On Aug 31, 2019, 6:39 AM, at 6:39 AM, Juliana wrote: >Hi Team, > >I

Re: Running OpenOffice and Microsoft Office at the Same Time: Issue

Far from home without a computer, but, my guess is that this is related to file extensions, my guess is that when you double-click on a file it opens in open office as opposed to Microsoft office because open office is the last thing that you installed. If you do not receive a response on how

Re: templates

It is called "impress" and it is included. ⁣Sent from BlueMail ​ On Aug 29, 2019, 1:43 AM, at 1:43 AM, contact...@hushmail.com.invalid wrote: > >Hi, >What is the Open Office equivalent to using Power point? Is it about >the same word processor? > > Thanks, >Carol > Sent using Hushmail

Re: Macro Protected Spreadsheet

Cannot see the image, I think that images are removed by the email list. I do not understand your problem, can you clarify (be more precise)? Now let me be more precise: When you say "password protected area", does this mean that portions of the spreadsheet are password protected so that you

Re: Excel

My assumption is that you are not really asking how to install Excel, since that is a Microsoft product and this is a mailing list for OpenOffice products... I assume, therefore, that you desire to install Apache OpenOffice and that you desire to use Calc. The only answer as of now

Re: SV: Help numbering papers

. >Thanks for the help. > >-Ursprungligt meddelande----- >Från: Andrew Pitonyak >Skickat: den 2 juli 2018 16:25 >Till: users@openoffice.apache.org >Ämne: Re: Help numbering papers > > >I just wanted to clarify: > >You start with a document that contains

Re: Help numbering papers

I just wanted to clarify: You start with a document that contains the text, which is always a number, "9990001". You open the document and print the document. The document prints the text "9990001" as part of the document, but, after print, the text reads "9990002". You save the document

Re: [SUSPICIOUS MESSAGE] Re: Problems with Apache_OpenOffice_4.1.4_Linux_x86-64_install-rpm_en-US

Obviously he has that as a signature for all outgoing email... There is almost nothing of substance that someone won't find offensive, including open office. Your only remedy is probably too have the list automatically remove all signatures. ⁣Sent from BlueMail ​ On Nov 17, 2017, 7:32 PM, at

Re: [SUSPICIOUS MESSAGE] Re: Problems with Apache_OpenOffice_4.1.4_Linux_x86-64_install-rpm_en-US

Please stop trolling. If you don't like it take it up with moderators. You are wasting bandwidth. ⁣Sent from BlueMail ​ On Nov 17, 2017, 8:00 PM, at 8:00 PM, Howard Blum wrote: >If this religious injection does not stop, I find it sufficiently >offensive >to totally walk

Re: I need some help

On 2017-10-25 13:15, Suzanna Reiff wrote: I want to construct a document. Spreadsheet document? It has fiver columns : 1. base number 2. I need to subtract '71' from the number in column 1. then : So you need to set column B to contain what is in Column A and subtract 71? I am

Re: reveal codes

nk that the best path forward would be to open a feature request and then if sufficient people vote for it or express interest, it might be done. Andrew Pitonyak

Re: reveal codes

As far as I can tell, neither of these things helps what I'm referring to. As an example: let's say you apply the Emphasis character style to a sequence of characters, and then later want to add some following characters that don't have that style. If you just position your cursor after the

Re: Lost Password

On 2017-07-06 13:22, Toki wrote: On 07/06/2017 04:51 PM, Gregory Truby wrote: I am wondering how I can delete the password or bypass it? Or even reset it? Your best chance of recovering the document, is to: * Wwrite down what you think the password is; * Construct variants of that, using the

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

box, probably; but I hvae not tested it. Andrew Pitonyak

Re: Macro Troubles

Trying to remember which will get me flamed less, top posting or bottom posting . Lets start with (2) because it is the easiest to answer. So, the answer is, I have no idea, it depends on what object Target is. Is this a Cell? A Range? If this is a SheetRange, then you should be able to

Re: word

I have written numerous articles for publication using OpenOffice with no problem. I think that you must first determine what format is required/supported by the publisher (DOC, DOCX, ODT, etc). If they directly support ODT, you are finished. if not, then you simply save your file in a

Re: Excited Aspiring Writer Looking to gain Experience

Hey Kevin, Here are a few links that may be useful Start here: https://wiki.openoffice.org/wiki/Documentation/Contribute These others might also be relevant depending on your preferred method of helping: http://www.openoffice.org/documentation/

Re: converting MS Works files

He is using a database file... I barely know that works exist so don't know if it can do things like export to csv⁣ Sent from BlueMail ​ On Nov 29, 2016, 1:10 PM, at 1:10 PM, Isaac Schrader wrote: >Or just convert the document to .odt format the main output of

Re: converting MS Works files

⁣https://forum.openoffice.org/en/forum/viewtopic.php?f=13=55968 That link may help... I saw something that implied that libre office may support the files, but I did not pursue that. Sent from BlueMail ​ On Nov 29, 2016, 8:09 AM, at 8:09 AM, "Joseph J. Haubrich"

Re: DOCX file extension

if the latest version can't handle it, T try libre office. of that can't handle it you may be stuck with mso. If the document is not proprietary, create a bug ticket and attached the document so the devs can fix aoo. traveling right now and it is difficult for me to look up the link... if you

RE: Questions about AOO Users

Start your research here ⁣https://en.m.wikipedia.org/wiki/Apache_OpenOffice Sent from BlueMail ​ On Nov 23, 2016, 2:31 PM, at 2:31 PM, "Buckneberg, Crystal R" wrote: >My apologies I misprinted the date on when I needed the answers by. > >I need the

Re: Is there an insert Filename or insert Full Path Available?

On 27.10.2016 00:00, Brian Barker wrote: At 10:19 26/10/2016 -0400, Keith N. McKenna wrote: On Oct 25, 2016, 8:03 PM, at 8:03 PM, Vince Bonly wrote: I would like to include the full path or filename within a CALC cell ... Andrew Pitonyak wrote: I have no computer access right now, but I

Re: Is there an insert Filename or insert Full Path Available?

I have no computer access right now, but I think you can insert a field containing the current file name. ⁣ Sent from BlueMail ​ On Oct 25, 2016, 8:03 PM, at 8:03 PM, "VinceB." wrote: >AOO412m3(Build:9782) - Rev. 1709696 >2015-10-21 09:53:29 (Mi, 21 Okt 2015) >

Re: mp4 video not supported in Impress

First question, since I know little to nothing about this that is not many years out of date: Q1: Are you able to insert other video formats? The obvious OGG Vorbis format comes to mind. If you can embed other formats, then MP4 is just a container, do you know what codec is used to

Re: Ribbon Interface

I would say more accurately, some people live it and some people hate it... At the moment there is no plan to go in this direction Sent from BlueMail On Sep 9, 2016, 8:27 AM, at 8:27 AM, Chuck Davis wrote: >Hopefully, never. It's a major productivity killer!! > >I'm

Re: Updates

You obviously feel strongly about this as do many others who prefer the other way. Please do not start this religious war yet again. On 26.02.2016 14:20, jd1008 wrote: PLease, I ask people to stop TOP POSTING!!! It destroys the sequential flow of the thread!!! See bottom for my reply.

Re: Top posting

Please don't start this again. It is personal preference and highly dependent on your reader.  I don't even think that I can bottom post with my client on my phone.. This client is kind of horrid. A discussion on top or bottom usually devolves.  On Oct 13, 2015 5:13 PM, William K Helbig Jr

Re: warning - Editor Wars!!!--how about some heresy on behalf of the Joe 6-Pack word processor user

I have found styles a real time saver... Imagine a 600 page document and you device that you want top change the don't color of all identifiers for contained coffee examples. I can do it very quickly. For what I refer to as garbage documents (quick letters, half page simple formatting, etc) it

Re: Email association

How do you normally attach other things; for example a photo or PDF document? On May 26, 2015 10:11 PM, jamie...@comcast.net wrote: Not understanding why I can't attach something from OO to my email.  I really don't know what to do about this.  I have been reading and trying but nothing.  I

Re: Problem

If you have files that cause a crash them perhaps you can open a bug report and attach your files... I routinely have far more than two files open with no problems. On May 5, 2015 6:55 AM, Sean Prytherch seanprythe...@outlook.com wrote: Hi, I know your product is free but it’s taking the

Re: A question

You have a document... Let's call it Bob.odt. is there a file in the same directory  named Bob.lck? Delete this file while you are not running open office. On Mar 24, 2015 8:08 PM, Jan j.jesen...@seznam.cz wrote: Taste preparing by linux live. - Original Message - From: Molly Teti