Re: Character set

[Andrew Pitonyak]

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 office a prompt pops up asking what
>Character Set I want to use.
>What do I put?
>Please help
>Steven
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Incorrect formula of function RECEIVED.

[Andrew Pitonyak]

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 on maturity
is incorrect on the webpage of function RECEIVED.

RECEIVED = purchasevalue / ( 1 - days_difference/days_in_year). This is an
incorrect formula. There is no formula on the webpage of 'Derivation Of
Financial Formulas' either for this function.

 

Re: Recovery of documents

[Andrew Pitonyak]

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 your old computer SATA that would work with that 
particular device. The advantage of the device I linked to, is that if you have 
a hard drive and you don't want to put it into an enclosure or install it in 
your computer, you can just push it into place plug everything in and things 
will generally just work.

I have an older version of that and I use it all the time. When people say hey. 
Can you get something off this hard drive.

note that there are probably cheaper solutions, like simply plugging it into 
your existing computer if you have any ability to do that.

Yes, I know that there are more permanent external drive enclosures that don't 
leave the hard drive exposed. And if you want to use the drive off and, that 
would be a better solution.





⁣Get BlueMail for Android ​

On Mar 19, 2023, 1:04 PM, at 1:04 PM, John Thomas  wrote:
>I am 88 and not so swift anymore. My Win10 desktop computer power
>supply
>went out. I was able to save the HDD and an external drive backup. I
>have needed medical and legal records I need to recover. I have a new
>Win11 desktop. How can I get these documents? Please, please give meme
>help! Thank you. John
>
>
>--
>This email has been checked for viruses by Avast antivirus software.
>www.avast.com
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Fwd: Printing on an envelope

[Andrew Pitonyak]

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 experimentation. 

What I did, was to feed a regular sheet of paper and then I checked to see 
where it printed with respect to the envelope so that I could refine margins 
(and similar). So now I can print individual envelopes when I want to. I just 
pull up my "template" and off I go.

Not much help perhaps, but it is how I solved it for my infrequent use.


On Tuesday, March 07, 2023 17:39 EST, Shari Lynn Smith  
wrote:
 Hi Paul,

Please join the OpenOffice mailing list so you can /*reply directly*/,
and see all the responses:
https://openoffice.apache.org/mailing-lists.html#users-mailing-list-public

Can you let us know what you are trying to do exactly? Does you printer
allow you to print directly on to the envelope? Have you print directly
to an envelope with another program?

If you printer will print to an envelope directly, you should just need
to change the paper size in OpenOffice. Some printers are able to print
on envelopes some are not.

Shari


> From: Paul Wysocki
> Date: Tue, Mar 7, 2023 at 2:14 PM
> Subject:printing envelope assistance
> To:
>
>
> Hello!
>
> Through a Computer Store in Richland Center, WI, Open Office was downloaded
> on my computer.
>
> I am having great difficulty with trying to print an envelope. Please help!
>
> Thanks,
> Paul Wysocki
>

 

Re: File is damage

[Andrew Pitonyak]

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 file then you 
at least know that something is correct with the file. Note that some data can 
be recovered directly from the ZIP file but it is not a pleasant nor a fast 
solution. 

If the file is NOT sensative (but I suspect that it is) you can directly send 
me an email with the file off list and I can take a peek at the file for you. 
Note that the first thing that I will do, however, is to make a copy with a ZIP 
file extension and see if I can unzip the file; something that you can likely 
do yourself. 

Also take a look at the file length. 

Finally, and I should have asked this first, any chance you have a backup of 
the file?

If your file is named something like "bob.odt", in that same directory is there 
another file that starts with the name bob? That might be instructive. 



On Monday, February 27, 2023 15:35 EST, Sílvia Ribeiro 
 wrote:
 Hi,

Just say that cannot be open.

The file is so important.

Thank you


A seg, 27 de fev de 2023, 18:29, Rory O'Farrell  escreveu:

> On Mon, 27 Feb 2023 15:25:38 +
> Sílvia Ribeiro  wrote:
>
> > Good afternoon,
> >
> > I need help, I have an *.odt file
> > that cannot be opened, with very important content, do you have any
> > suggestions to eventually repair any hypothesis that I still need to
> > test, thank you.
> >
> > Best regards,
> >
> > Silvia
>
> When you try to open the file, is there any error message?; does it
> display onscreen full of ## or other characters, sometimes  characters.
>
> --
> Rory O'Farrell
>

 

Re: File Access

[Andrew Pitonyak]

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 ownership? Is the file set to be read only?

Can you make a copy of the file? Then use the copy until the permission thing 
is figured out?



⁣Get BlueMail for Android ​

On Feb 13, 2023, 7:18 AM, at 7:18 AM, alecphythian 
 wrote:
>I am being tol to obtain File Access from the owner. I am the owner and
>have been for many years. What’s gone wrong?
>
>Sent from Mail for Windows

Re: Forgot Password

[Andrew Pitonyak]

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 9:37 AM, Dave  wrote:
>
>
>On 28/09/2022 09:21, H S wrote:
>> Hallo,
>> I saved a document with a password and unfortunately forgot the
>password.
>> Can you please help me how to open the file again. Thanks in advance.
>>
>> Kind regards
>>
>> H.Rotar
>
>ODF (OpenDocument Format ISO/IEC 26300:2006 standard
>http://en.wikipedia.org/wiki/ODF)password protected files are almost
>impossible to open unless you have the correct password.
>
>While it will not resolve your current issue, for the future you might
>consider a good secure password manager to generate and store strong
>passwords for you.
>My recommendation would be the free open source Bitwarden password
>manager: https://bitwarden.com/
>
>
>
>Regards
>
>Dave
>--
>Please address any reply to users@openoffice.apache.org only.
>Messages sent to my personal email address will not be answered.
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Median Function Used as "Between"

[Andrew Pitonyak]

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. 
If you have only two values it might look something like this: 

=IF(AND(MIN(120,129) < B12,B12 < MAX(120,129)),"Yes","No")



On Tuesday, August 23, 2022 09:36 EDT, David Stuhr 
 wrote:
 Hello,

Can the Median function in Open Office Spreadsheet be used as a between
function?

When the following equation is entered

=IF(B12=MEDIAN(120;129);"Yes";"No")

and cell B12 contains 121 formatted as Number General the equation
returns No.

I have also tested the equation with the values 120 and 129 replaced by
cell references and the same false value (No) is returned.

I have also replace the value of cell B12 with the value 118 and the
same false value (No) is returned.

All of my research on the web indicates that this equation works in
other spreadsheet products.

I am using Open Office 4.1.13 on a Windows 11 PC.

Am I doing something incorrectly?

David

 

 

Re: Winding OpenOffice down

[Andrew Pitonyak]

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 based on ideology, not sure if that is still the case. I will concede 
that LO has had much more development than AOO. I am not sure if that is why 
most Linux distros use LO rather than AOO or if that is also based on ideology; 
never cared enough to look into it. 

I won’t bother with the entire history of AOO / LO, but, some people did not 
like the license used by AOO. At the time, it was not owned by Apache, I think 
it was owned by Oracle after Oracle purchased Sun Micro-Systems. In other 
words, the split was based in ideology (disagreement with the license). 

So LO forked from OpenOffice.org with their own license. Obviously they had to 
rewrite certain things to go with their license of choice. Soms is outlined at 
the Wiki page mentioned above. 

LibreOffice License
https://www.libreoffice.org/about-us/licenses
GPL / LGPL V3+  and Mozilla Public License v2.0

Apache OpenOffice License
https://www.openoffice.org/license.html
ASL

I am not sure it is a correct characterization and I am not going to spend time 
reading through all the license stuff, but I heard it summarized as follows: 

LO's license will allow the developer to own the coding they are sharing with 
the project, where AOO's really will give that project the ownership of the 
coding. Whether or not the "wording" is stating that, that is what most 
developers I have "talked" with have told me.

Without looking it up, I would have characterized the difference noting that 
ASL is more permissive than GPL. Specifically, if you modify or use GPL code 
the new code is GPL. Because of this, most companies forbid the use of GPL code 
to be used with code that they develop (or their code becomes GPL), which is 
kind of the point of the GPL. The code that I release (as in not for my 
employer) I release on a very permissive license, but that also means that 
others can take my code and sell it after minor modifications. 

LO immediately gained lots of traction with many contributors while Oracle 
decided what to do with OOo and then they eventually handed it over to Apache. 

Initially, the documentation group was working with both LO and AOO, but there 
was a falling out between the person leading the group and some people with 
AOO. I never fully understood the disagreement but noted that the primary 
individual indicated that they would no longer work on AOO documentation so the 
group producing LO documentation mostly abandoned AOO but are still strongly 
working on LO documentation. 




On Wednesday, June 22, 2022 17:30 EDT, Flaviu Tamas 
 wrote:
 Why hasn't OpenOffice been wound down & shuttered?

The existence of the website makes users assume that OpenOffice is
still actively being developed, when those users would be much better
served migrating to LibreOffice.

I've seen this conversation several times over the past few years in
various open source communities.

At the very least, a prominent notice that users should use
LibreOffice on the main OpenOffice site would be nice.

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

 

Re: Reveal Codes

[Andrew Pitonyak]

First, to identify a few problems with "reveal codes.

One problem with "reveal" codes with respect to OpenOffice is related to the 
use of styles compared to hard coded attributes. I perform most formatting 
using a style, but it is difficult to understand whether a single character is 
bold because it was made that way using a style or by a hard coded attribute.

Programatically, it is easy to traverse simple text and to recognize where 
things change. The hard part is understanding exactly why something changed. I 
do not remember off hand if it tells me when individual attributes change if 
the change is because of an applied style. Also from memory, I think that it 
will tell me when a style starts / ends, which makes removing an applied style 
tricky; something I have never tried programatically.

I have certainly written macros that would dump this information, but not in a 
nice easy to see way.

https://wiki.openoffice.org/wiki/Documentation/FAQ/Writer/FormattingText/Does_OpenOffice.org_have_a_Reveal_Codes_functionality_similar_to_WordPerfect%3F

https://bz.apache.org/ooo/show_bug.cgi?id=3395

https://forum.openoffice.org/en/forum/viewtopic.php?f=7=62137

https://wiki.openoffice.org/wiki/User:TJFrazier/Reveal_Codes

In 2004 (approximately), a macro was created by Ian Laurenson to roughly 
emulate some reveal codes functionality.

On my current computer I have LibreOffice (not OpenOffice) installed and I was 
able to make it work with a few fixes. No idea if it works with the current 
version of AOO (Apache OpenOffice). If you email me off list, and ask for a 
copy of my latest Documents/OpenOffice/RevealCodes/Ianz/RevealCodes3.odt, I can 
send you a copy. You will probably be very unhappy with how it works. Also, it 
is not something that I use. 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 Word feature may go by the same name but is
nothing like the Wordperfect feature because the structure of the files is
different.

If you have a line (or double line, or dashed line, or etc) across a page,
check for borders in the paragraph style both above the line and below the
line. I've had that happen to me before and frustrated the heck out of me
before I finally figured it out. Still happens sometimes. Don't know what
I'm doing to make it happen but have at least figured out how to get rid of
it.

On Sun, Mar 20, 2022 at 3:06 PM Jennie Bickerton
 wrote:

> Hi Steve,
> I am having problems in a document with paragraph numbers and
> sub-paragraph entries ( 1. and then A. etc.) and also a double line across
> the page that I have no idea how it got there. I know in Microsoft there
> was an "F#" that would open Reveal Codes so that I could then go in and
> remove whatever indent or code I had mistakenly inserted.
> Is there any reveal codes in Open Office?
> Thank you so much!
> Jennie Bickerton



--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

 

Re: FW: open office not recognizing JRE

[Andrew Pitonyak]

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. 
Without knowing more about what you do on your computer and your setup, I won't 
begin to try to tell you how to configure your computer to handle multiple 
versions of Java. But you probably want the latest version in your past and 
then you can probably configure open office and tell it specifically where to 
find the JDK but again, I have no way to easily test this. But hopefully that 
gets you started if you get no other answers.

I do this regularly on other computers when software has different requirements 
for which versions of Java, so it is common for me to have three or more 
versions of Java installed at the same time.

⁣Get BlueMail for Android ​

On Feb 6, 2022, 8:59 PM, at 8:59 PM, MICHAEL DENNIS  
wrote:
>STILL WAITING AN ANSWER ON THIS SITUATION. THANKS
>
>Sent from Mail for Windows
>MWD
>
>From: MICHAEL DENNIS
>Sent: Thursday, February 3, 2022 4:10 PM
>To: users@openoffice.apache.org
>Subject: open office not recognizing JRE
>
>
>
>I have installed the new version of Java Runtime(JRE), but my Open
>Office program is not recognizing that it is on my computer. I have the
>latest version of Open Office installed also.
>Any help would be appreciated.
>
>Thanks and…..hope you have a great day!
>
>Sent from Mail for Windows
>MWD
>
>
>
>Sent from Mail for Windows
>MWD

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

[Andrew Pitonyak]

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 that because one product is version 7 and one product is 
version 2, that one of them is more advanced than the other.  And don't take 
any of those version numbers is being meaningful in any way that I just quoted.

I use Fedora Linux that I think has a version release cycle of every 9 months. 
So I will soon be installing version 35 I think.

I'm sorry I don't have a comparison list between the two and since I don't 
really have access to a computer besides my phone I can't even search for one.

If you do find one or make a decision interested in what you find best of luck.

⁣Get BlueMail for Android ​

On Oct 10, 2021, 12:18 PM, at 12:18 PM, joseph dingler 
 wrote:
>Hello All, 
>
>Not sure I want to drown in all the drama/politics over at Oracle and
>how you acquired OO; but I would assume that you have a non-compete or
>other arrangement prohibiting you from 'giving-away' solaris or BSD
>compatible/ported OO?? I have 2 main questions that I'm needing of you?
>
>
>First and generally speaking; OO current version is 4.1 & Libre is 7.1,
>are you really that far behind because Oracle didn't dev OO or did you
>just adopt all their dev and just continue as your release versions? 
>
>Second, as the entire Linux Community have become FLAMING
>systemd-sexuals - while it is completely puzzling how there is such
>agreement about something as controversial as systemd -; among the TWO
>MILLION lines of un-audited code has suffered it's first crippling
>handicap... it appears that unix flavors are going to begin getting an
>infusion of interest, from mass exodus from the POXIS abomination...
>What are your intentions of a BSD/Open Indiana/Open Solaris install? 
>
>The 2nd question is of pressing importance, as I'mn looking into
>putting some development into a Unix Desktop & needing productivity
>tools to come standard in the distro. 
>
>
>
>Joseph Dingler 
>
>“If you take care of your people, your people will take care of your
>customers and your business will take care of itself.” ~ J.W. Marriott
>

Re: Can User Functions Be Created In OpenOffice Spreadsheet

[Andrew Pitonyak]

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 easier if you have the 
address so you can actually pull the cell and then look at properties but I'm 
hanging out in the car far from any of my documentation so that would be tricky 
to find.

The easiest way to do that is to make sure that the user-defined macro that you 
created is embedded in the document in question and then put it in the standard 
library so that it's automatically loaded. They're better ways to get around 
that but that's absolutely the easiest way to do it.

If you really can't figure it out let me know.

⁣Get BlueMail for Android ​

On May 26, 2021, 4:58 PM, at 4:58 PM, David Stuhr 
 wrote:
>Hello,
>
>I have an OpenOffice Calc (spreadsheet) that has over a thousand
>Hyperlinks and I would like to create a user defined function which
>would extract the URL from the Hyperlink and put it in a separate cell.
>
>I found an Excel example on the web which I pasted in below.
>
>Function GetURL(rng As Range) As String
> On Error Resume Next
> GetURL = rng.Hyperlinks(1).Address
>End Function
>
>Can this be done in OpenOffice Calc? I have looked for documentation
>but
>I probably using the incorrect terms so I have not found any
>information. I use both the Windows and Mac versions of Open office.
>Thank you. I enjoy reading the support you provide to users and I have
>learned several things. dds

Re: Open Office for Sraco Co. SAUDI ARABIA

[Andrew Pitonyak]

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

[Andrew Pitonyak]

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 
wording a bit wrong). What it really asks is if it should re-open the previous 
windows. This window hangs and she cannot do anything with it. 

So, first question. How can kate start AOO so that it will NOT prompt to 
recover files. Note that no data will be lost because everything is saved. 

Kate does not see a lock file in the directory, so there is probably not one. 

>From the finder window, she is able to open the file, but it seems like it is 
>running a second copy of AOO. I don't really know if it might really be 
>"OpenOffice" and not AOO. 

First question, how can she kill that initial window so that it stops coming up 
when the computer starts. 

On Saturday, February 06, 2021 14:04 EST, Kate  
wrote:
 Hi,

My open office program will not save a new file into PDF.. there is a window 
screen that keeps asking if I want to re open it or close..

I am needing immediate assistance, and could not find your number to call..
Please have customer support reach out to me so that we can trouble shoot 
together.

Thanks much,
Kate
505 670-8456

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


 

Re: emails

[Andrew Pitonyak]

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 send an email as follows: 

users-h...@openoffice.apache.org
users-unsubscr...@openoffice.apache.org

On Friday, December 11, 2020 13:36 EST, Wade Smart  wrote:
 Only you can do it.

On Fri, Dec 11, 2020, 12:35 Wade Smart  wrote:

> Unsubscribe
>
> On Fri, Dec 11, 2020, 11:14 BAINES JOHN 
> wrote:
>
>> Please stop Apache users subscription I am fed up with getting unwanted
>> emails
>>
>>
>> john baines
>>
>


 

Re: Font Colors

[Andrew Pitonyak]

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. 

Alternatively, select the text of interest, right click on it, choose 
character. Select the properties tab, there is a color area. 

Set the background color very differently, but for certain you did not ask 
about that. 

On Monday, November 30, 2020 08:15 EST, Glenn Little WB4UIV 
 wrote:
 Can the font color be changed in different cells of a spreadsheet?
I cannot locate anything that indicates that it can.

Thank you
Glenn

--
---
Glenn Little ARRL Technical Specialist QCWA LM 28417
Amateur Callsign: WB4UIV wb4...@arrl.net AMSAT LM 2178
QTH: Goose Creek, SC USA (EM92xx) USSVI LM NRA LM SBE ARRL TAPR
"It is not the class of license that the Amateur holds but the class
of the Amateur that holds the license"


 

Re: LibreOffice

[Andrew Pitonyak]

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 just try the other.

⁣Sent from BlueMail ​

On Oct 1, 2020, 4:45 PM, at 4:45 PM, John North  wrote:
>I know this is Apache that This is OpenOffice. Apache.
>However I would like to connect by email or talk to support person
>about a downloaded problem with LibreOffice. I actually started out
>with OpenOffice and still use it. This person actually referred me to
>LibreOffice.
>I know someone did help me last year in getting started.
>Help!
>John North
>
>Sent from my iPhone
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Hello my friend/world!?

[Andrew Pitonyak]

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 has a
>really
>nice look in my opinion.
>Thank you!

Re: Open Office Excel

[Andrew Pitonyak]

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:
>https://forum.openoffice.org/en/forum/viewtopic.php?f=9=102846=497589#p497589
>
>All Best, Joelle
>
>On 2020-08-25 13:33, Web Shari wrote:
>
>> Are you receiving any error message?
>>
>> The size shouldn't effect it's ability unless you have hundreds of
>sheets. Emails also shouldn't make a difference.
>>
>> Shari
>>
>> On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote:
>>
>>> Hi,
>>>
>>> One of my Open Office Excel files is not opening. My other files are
>>> opening fine. It is a very big file with a list of emails. I wonder
>if
>>> the links are too heavy or complex? Not that I really know what I am
>>> talking about. Is there anything I can do to retrieve my data?
>>>
>>> All best, Joelle
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[Andrew Pitonyak]

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 (LibreOffice), sometimes, what fails in one 
works in the other. Kind of a least resort for a casual user I think.




⁣Sent from BlueMail ​

On Aug 25, 2020, 1:33 PM, at 1:33 PM, Web Shari  wrote:
>Are you receiving any error message?
>
>The size shouldn't effect it's ability unless you have hundreds of
>sheets. Emails also shouldn't make a difference.
>
>Shari
>
>On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote:
>> Hi,
>>
>> One of my Open Office Excel files is not opening. My other files are
>> opening fine. It is a very big file with a list of emails. I wonder
>if
>> the links are too heavy or complex? Not that I really know what I am
>> talking about. Is there anything I can do to retrieve my data?
>>
>> All best, Joelle
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Program question

[Andrew Pitonyak]

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  
wrote:
>Greetings,
>
>I am unable to communicate to Calc using Agilent VEE. Graphic visual
>basic program that works seamlessly with Excel.
>Do you have a sample program to load data into cells for Calc in visual
>basic or for Agilent VEE?
>Thank you.
>
>Regards,
>
>Timothy Cheshire
>Quality Test Manager
>1-631-913-0400 ext. 210
>timot...@aa-tech.com
>
>AA Technology Inc.
>101 Trade Zone Drive
>Ronkonkoma, NY 11779
>P:1-631-913-0400 F:1-631-913-0401
>www.aa-tech.com
>
>NOTICE: This e-mail and the attachments hereto, if any, may contain
>legally privileged and/or confidential information. It is intended only
>for use by the named addressee(s). If you are not the intended
>recipient of this e-mail, you are hereby notified that any
>dissemination, distribution or copying of this e-mail and the
>attachments hereto, if any, is strictly prohibited. If you have
>received this transmission in error, please immediately notify the
>sender by telephone and permanently delete this e-mail and the
>attachments hereto, if any, and destroy any printout thereof.

Re: Get URL from Hyperlink

[Andrew Pitonyak]

They updated my email servers and they have decided that any document with a 
macro is invalid / dangerous. Will see if I can fix it or if I need to have the 
admin to id. It was fixed a few months back, but the server was updated. They 
are just trying to keep me safe Hate that to some 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 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 later.
>
> On Tuesday, August 18, 2020 17:40 EDT, David Stuhr 
>  wrote:
> Hello Brian,
>
> I had time today to copy the Basic macro code in the link provided today
> into a test spreadsheet. I pasted the code between "Sub Main" and "End
> Sub". I then saved the macro. When I attempted to compile the macro I
> got the following error.
>
> BASIC syntax error.
> Function not allowed within a procedure.
>
> What am I doing wrong?
>
> David
>
>> On 8/17/2020 9:12 AM, Brian Barker wrote:
>> At 08:18 17/08/2020 -0400, David Stuhr wrote:
>>> I have an OpenOffice spreadsheet that has over a thousand hyperlinks
>>> to an external www website. The information in each hyperlinked cell
>>> is the URL and descriptive text. From a search of the web it appears
>>> that Excel has a "get URL" function but a search of OpenOffice help
>>> did not return a similar function.
>>>
>>> Is there a method/way of getting the URL in a cell that contains a
>>> hyperlink and putting it in another? I want to do this to identify
>>> duplicate URL references.
>>
>> See
>> https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice
>> - which includes a function CELL_URL() which appears to provide what
>> you need.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>
>
>
>
>


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


 

Re: Get URL from Hyperlink

[Andrew Pitonyak]

Yeah, it would not send. Not sure if my server rejected the email, if his 
server rejected my server, etc. I need to look into it. 

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 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 later.
>
> On Tuesday, August 18, 2020 17:40 EDT, David Stuhr 
>  wrote:
> Hello Brian,
>
> I had time today to copy the Basic macro code in the link provided today
> into a test spreadsheet. I pasted the code between "Sub Main" and "End
> Sub". I then saved the macro. When I attempted to compile the macro I
> got the following error.
>
> BASIC syntax error.
> Function not allowed within a procedure.
>
> What am I doing wrong?
>
> David
>
>> On 8/17/2020 9:12 AM, Brian Barker wrote:
>> At 08:18 17/08/2020 -0400, David Stuhr wrote:
>>> I have an OpenOffice spreadsheet that has over a thousand hyperlinks
>>> to an external www website. The information in each hyperlinked cell
>>> is the URL and descriptive text. From a search of the web it appears
>>> that Excel has a "get URL" function but a search of OpenOffice help
>>> did not return a similar function.
>>>
>>> Is there a method/way of getting the URL in a cell that contains a
>>> hyperlink and putting it in another? I want to do this to identify
>>> duplicate URL references.
>>
>> See
>> https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice
>> - which includes a function CELL_URL() which appears to provide what
>> you need.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>
>
>
>
>


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


 

Re: Get URL from Hyperlink

[Andrew Pitonyak]

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 later. 

On Tuesday, August 18, 2020 17:40 EDT, David Stuhr 
 wrote:
 Hello Brian,

I had time today to copy the Basic macro code in the link provided today
into a test spreadsheet. I pasted the code between "Sub Main" and "End
Sub". I then saved the macro. When I attempted to compile the macro I
got the following error.

BASIC syntax error.
Function not allowed within a procedure.

What am I doing wrong?

David

On 8/17/2020 9:12 AM, Brian Barker wrote:
> At 08:18 17/08/2020 -0400, David Stuhr wrote:
>> I have an OpenOffice spreadsheet that has over a thousand hyperlinks
>> to an external www website. The information in each hyperlinked cell
>> is the URL and descriptive text. From a search of the web it appears
>> that Excel has a "get URL" function but a search of OpenOffice help
>> did not return a similar function.
>>
>> Is there a method/way of getting the URL in a cell that contains a
>> hyperlink and putting it in another? I want to do this to identify
>> duplicate URL references.
>
> See
> https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice
> - which includes a function CELL_URL() which appears to provide what
> you need.
>
> I trust this helps.
>
> Brian Barker
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>


 

Re: Get URL from Hyperlink

[Andrew Pitonyak]

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 Calc document directly. 
Because the macro is in the Standard Library of the document, the macros are 
always available for that document as functions. On the other hand, I think 
that you cannot import the Standard library into another library container 
(such as a document), so you would need to manually copy the macros into a new 
document. 

Enough testing for me for now, I have some other things I need to do, but, 
watch for the document by itself. I do not believe that I can post the document 
(attachement) to the list. 

cheers!


On Tuesday, August 18, 2020 17:40 EDT, David Stuhr 
 wrote:
 Hello Brian,

I had time today to copy the Basic macro code in the link provided today
into a test spreadsheet. I pasted the code between "Sub Main" and "End
Sub". I then saved the macro. When I attempted to compile the macro I
got the following error.

BASIC syntax error.
Function not allowed within a procedure.

What am I doing wrong?

David

On 8/17/2020 9:12 AM, Brian Barker wrote:
> At 08:18 17/08/2020 -0400, David Stuhr wrote:
>> I have an OpenOffice spreadsheet that has over a thousand hyperlinks
>> to an external www website. The information in each hyperlinked cell
>> is the URL and descriptive text. From a search of the web it appears
>> that Excel has a "get URL" function but a search of OpenOffice help
>> did not return a similar function.
>>
>> Is there a method/way of getting the URL in a cell that contains a
>> hyperlink and putting it in another? I want to do this to identify
>> duplicate URL references.
>
> See
> https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice
> - which includes a function CELL_URL() which appears to provide what
> you need.
>
> I trust this helps.
>
> Brian Barker
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>


 

Re: Error saving the document_Sharing Violation

[Andrew Pitonyak]

I think someone else recommended a newer version...

If you are using an add on, make sure it is compatible with the updated version.

Google should be your friend when finding the latest download.. :-)


⁣Sent from BlueMail ​

On Jul 24, 2020, 8:27 PM, at 8:27 PM, mannteck  wrote:
>
>Yes Andrew, it worked! You nailed it. I think your thoughts about the
>extension I was using was not native to the file and caused the
>problem. What's funny though is that it had been working and saving my
>edits? I also like your idea of going with the new version is a wise
>move. I'm going 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: Andrew Pitonyak
> Date: 7/23/20  12:47 PM  (GMT-07:00) To:
>users@openoffice.apache.org Subject: 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 MicrosoftWindows 7 professional on Dell XPS
>laptop version 6.1.7601 Service Pack 1Build 7601/64 bit with Open
>Office 4.1.3.When I want to save my Word 97/2000 document , after
>clicking the savebutton, there is this Windows pop up that says "error
>saving the document'Online Zoosk Profile.doc'; locking problem. Sharing
>violation whileaccessing the object". This is the only photo I could
>find to show youthe problem, file name is wrong is all. anyone can help
>me to solve this?thanks[image:
>IMG_20180529_123700.jpg]<https://forum.openoffice.org/en/forum/download/file.php?id=34976=view>
> 

Re: Error saving the document_Sharing Violation

[Andrew Pitonyak]

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 Open Office 4.1.3.
When I want to save my Word 97/2000 document , after clicking the save
button, there is this Windows pop up that says "error saving the document
'Online Zoosk Profile.doc'; locking problem. Sharing violation while
accessing the object". This is the only photo I could find to show you
the problem, file name is wrong is all. anyone can help me to solve this?
thanks
[image: IMG_20180529_123700.jpg]



 

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

[Andrew Pitonyak]

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 test (of interest), is to copy some of those black lines where you 
expect words to be and paste them into a regular text editor (on windows, 
notepad is a common choice). This should tell you if it is just a font problem 
(or similar). 

Best of luck.

Andrew

On Friday, June 12, 2020 06:54 EDT, Anne Scherliess  
wrote:
 Dear open office team, my openoffice just updated itself to 4.1.6 and after 
this i wanted to continue writing my book and the entire chapter just shows 
black lines and no words whatsoever. I am devastated about this, what can I do 
to resurrect my work?
Please please help me, thankyou,
Anne Scherliess

http://www.theaterathome.de

https://www.schauspielervideos.de/fullprofile/schauspielerin-anne-scherliess.html
 
https://www.schauspielervideos.de/fullprofile/schauspielerin-anne-scherliess.html

https://www.castforward.de/members/profile/anne-scherliess

http://www.filmmakers.de/anne-scherliess 
http://https//www.filmmakers.de/anne-scherliess

https://www.spotlight.com/8016-8979-3087 http://www.spotlight.com/8016-8979-3087

http://www.anne-scherliess.com


 

Re: Microsoft payment demand

[Andrew Pitonyak]

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 on how to do that, but a quick 
Google search and show you how to reassociate the file types.

Also, you should be able to manually load your word processor and then use file 
open to open the document

⁣Sent from BlueMail ​

On Mar 8, 2020, 10:39 AM, at 10:39 AM, Wade Smart  wrote:
>Depending payment for OO or for the OS?
>My wifes W10 laptop has LO installed and
>we have not seen that dialog box.
>
>
>--
>Registered Linux User: #480675
>Registered Linux Machine: #408606
>Linux since June 2005
>
>On Sun, Mar 8, 2020 at 8:57 AM Stuart Walton
> wrote:
>>
>> Since I updated the version of Windows 10 I was using on my PC, I
>find I am no longer able to access my Open Office .odt douments without
>getting a big dialog box from Microsoft demanding payment. None of my
>files is saved in Word, but it won’t let me access them even so. I have
>saved everything on to a USB device, but it won’t let me access them
>there either. I tried copying the existing files into new .odt files
>and it won’t let me do that either.
>>
>> How come Microsoft is taking over an entirely separate free
>word-processing system? And is there anything I can do to get around it
>without paying Microsoft for their system, which I don’t want?
>>
>> 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: more field fun.

[Andrew Pitonyak]

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: 

https://wiki.openoffice.org/wiki/Documentation/FAQ/Writer/FormattingPagesAndDocuments/How_do_I_make_page_numbers_alternate%3F

I do notice, however, tha tyou say "page 3" is numbered as xi (11), so you 
would need to make sure that the real page number is correct if you rely on 
that to generate the number. 

On Saturday, February 22, 2020 17:33 EST, Felmon Davis  wrote:
 great help!

through some trickery with 'manual breaks' and 'page styles' I have
almost everything in shape.

however -

imagine you have ten consecutive pages all without footer and
unnumbered except for pages 3, 5 and 7; on those pages you want a
footer and you want a roman numeral, for instance ix on page 3, xi on
page 5 and xiii on page 7.

inserting a number generates the same numeral on each page.

ah, I guess the trick is to do a different page style for 3, 5 and 7.

need a break; will pursue this strategy later unless there's a better
idea.

f.

--
Felmon Davis

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


 

Re: Showing number as binary

[Andrew Pitonyak]

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 Andrea Vt :
>
>> Hi all :-)
>>
>> Is there a way to show a number as binary with a separation?
>>
> Yes, there seems to be.
>
>>
>> E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010)
>>
>> Thanks and have a nice day
>>
> Have a nice day you too.
>
>
> And maybe I should answer the question I think you meant to ask too: ”How?”
>
> Here's one way. I don't have Apache OpenOffice so I can't test it, but I
> tested it with LibreOffice and I think it would work in Apache OpenOffice
> too:
> =VALUE(BASE(42;2))
> Now format the cell like the following:
> Right click the cell → click Format cells…
> Select the Number tab.
> In the field ”Format description”, enter the following:
> " "
> Hit OK.
>
> Note that if omitting the quotes, typing   in that field will
> fail, (the cell will display 00 101 010). I'm not sure why though.
> As I said, I tested this in LibreOffice, hopefully it will work in Apache
> OpenOffice too.
>
>
> Kind regards
>
> Johnny Rosenberg
>

After some more experimenting I found this way, that differs from the other
method in the following ways:

- No need for using cell formatting
- The cell content is a string rather than a number

And the cell formula looks like this:
=TEXT(VALUE(BASE(42;2));""" """)

Of course you should replace ”42” with a cell reference or a formula in
most cases, like this:
=TEXT(VALUE(BASE(A1;2));""" """)

Sorry for stating the obvious… 


Kind regards

Johnny Rosenberg

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


 

Re: Showing number as binary

[Andrew Pitonyak]

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 :-)
>
>Is there a way to show a number as binary with a separation?
>
>E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010)
>
>Thanks and have a nice day
>
>Andrea
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: OpenOffice tech support

[Andrew Pitonyak]

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 errors within OpenOffice and need tech 
support. Is there someone I could speak with on the phone or livechat with on 
the computer?

Thank you,

Brie Gallup
Office Manager, Tonal Rehabilitation & Pilates LLC
413-464-2512

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


 

Re: Original Open Office.

[Andrew Pitonyak]

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 to be valid, any Last Will and Testament still has to be
>printed, signed, and witnessed.  Recognition of electronic versions is
>still not in the works by legislation.  Find your printed original
>Will, take it to a wills & trust lawyer, and have him/her produce a
>codicil that makes the updated changes.  Keep the original and the
>original of the codicil together in a safe place.  
>
>OpenOffice.org DOES NOT and has never stored copies of your documents.
> They exist only on your computer(s) or cloud storage that you have
>attended.
>
>
>On December 3, 2019 at 6:52:58 AM, Wade Smart (wadesm...@gmail.com)
>wrote:
>
>Keith, first - this is a public list to people all over the world.
>Do not ever post personal information on a public list.
>
>Second, all your documents are stored on your pc and if
>it was destroyed, if you do not have a backup, your documents  
>are unfortunately lost.
>
>
>--
>Registered Linux User: #480675
>Registered Linux Machine: #408606
>Linux since June 2005
>
>On Tue, Dec 3, 2019 at 7:45 AM KEITH PAICE
> wrote:
>>
>>
>> Dear sir, I used the Original Open site for many years. However I
>recently have had my PC. destroyed. How can I now get access to the
>original Open Office which contains various letters & documents which
>are mainly associated with my current Last Will & Testament. These
>documents need to be updated. Therefor I am desperate to be able to
>locate these files.
>> My Details are. Name : Keith John Paice. E-Mail :
>k.j.paice@btinternet. com
>> Can you tell me how I can access these files held on OpenOffice.org
>These document were entered on Open Office at least 6 years ago.
>> I look forward to you reply & hopefully what I need to do to access
>my documents held in Original Open Office. Regards,
>> Keith. Paice. UK Tele number. 01454320415
>> Sent from Yahoo Mail on Android
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Fwd: Is Open Office Going Away?

[Andrew Pitonyak]

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
>their
>students to download Open Office for free from your homepage. Recently,
>I've got wind that Open Office might be going away and/or students
>won't be
>able to download it for free in the near future. So, I just wanted to
>follow up with you to see if that's truly the case or just empty rumor?
>
>Thank you much,
>
>MK

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

[Andrew Pitonyak]

I define my own variables for counting things such as figures. When you insert 
a caption, this creates a frame that contains both the figure and the caption. 
Especially if you have floating figures, this seems like a good idea. First, 
there are a few times when things go poorly if you let things float around; for 
example, importing into other things or exporting as HTML (to name two). Worse, 
many years ago, there was a bug that caused OOo to completely fail to load a 
document with exactly this configuration if another set of things lined up 
perfectly. I had a very large document that just would not load becaues of it. 
I ended up editing the XML version of the document until I found the spot that 
caused the problem. The bug was fixed, of course, but I have not used that 
method since then. Well, not for most of my documents.

I always embed my images as a character and let them flow with the text. By 
always, I really mean almost always. This allows me to do things such as have 
three images on a single line with a single caption. Sure, I can do it the 
other way, but, the I need to embed the other two images into the frame (and 
similar). 

I have my own paragraph style for things such as figures, tables, and code 
listings. Last I checked this is exactly how the documentation project does it. 
I did it because that is how the documentation for OOo was done. 



On Tuesday, September 03, 2019 13:50 EDT, "W. Robert J. Funnell, Prof." 
 wrote:
 On Tue, 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. 

Andrew, I'm curious about why you don't use the Insert > Caption
feature for figures and tables.

- Robert


 

Re: spacing before/after group of paragraphs.

[Andrew Pitonyak]

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
last_quote_par

Use properties similar to the following: 
For first_quote_par and next_quote_par: set the "next style" to be 
"next_quote_par". 
For last_quote_par, set the next style to be whatever you normally use for your 
text.
Set any specific line spacing for before and after as you desire for the 
different paragraphs in the style. 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. 

For my uses, I don't need the "first_quote_par". Also, the last_quote_par has 
suitable values in case I have a single line of code. If this is not true in 
your case,  you might also need to define "single_quote_par" for when you have 
only a single paragraph for your quote. 

Note that I do something similar for page styles. I have a style named 
"first_page_in_chapter" and "next_page_in_chapter". 



On Tuesday, September 03, 2019 13:14 EDT, Felmon Davis  wrote:
 On Tue, 3 Sep 2019, Brian Barker wrote:

> At 17:54 02/09/2019 -0400, Felmon Davis wrote:
>> it's easy to set up a style to indent a paragraph with two line spaces
>> separating it from the rest of the text fore and aft.
>
> I'm sorry to have to disappoint you but, although OpenOffice is available for
> a range of operating systems, it is not available for Typewriter, which you
> appear to use. It's only when using a typewriter that you space paragraphs by
> "lines", of course: in a word processor you are not restricted to lines and
> so set paragraph spacing simply by distance.

cute remarks (including 'archaic need' below). gotta get the word out
to OpenOffice too since the dialogue, 'Indents & Spacing', refers
to 'line spacing' - perhaps it is a typewriter!

thank you for the substance of your remarks, but I'm not sure they
help. I think I haven't described my problem adequately.

I can make a 'style' which indents a paragraph say .03" left and right
and say .08" above and below.

I call this 'text-indent' and when the authors in the volume have
extended quotations, I can format them with a click on the style.

but in some cases the quotations themselves comprise two paragraphs. I
don't want the two paragraphs separated from each other by .08". I was
asking is there a way of making a style which separates two paragraphs
from the surrounding text but not from each other. I suspect not.

ok if not; I'll have to do it by hand.

>> suppose I want a style that will keep two paragraphs together, separated by
>> one line but separated from the rest by two spaces before and after the
>> couplet. is that doable?
>
> o It's a bit messy (though it satisfies your archaic need to think in lines),
> but you could separate the two blocks of text by two successive line breaks
> (Shift+Enter) instead of a paragraph break. You could still adjust the
> vertical spacing by changing the font size in the intervening empty line. The
> two blocks would then actually constitute a single paragraph, of course.

I know I can do the work by hand. but I wanted to encapsulate it in a
style.

> o Alternatively, you could apply local paragraph formatting to the pair of
> paragraphs (or probably just one of them), to override the paragraph style
> formatting.
>
> o Here's an idea. Put your pair of paragraphs into a single table cell (one
> column, one row). (You won't want a table border.) Apply a different
> paragraph style (perhaps Table Contents?) to your pair of paragraphs, with
> smaller spacing (one "line"). Then also set spacing after the table to make
> up the necessary difference between the pair of paragraphs and the following
> material (the other of your two "lines").

in the present text there are only a couple of instances where I want
do this kind of indentation but the table solution would be unwieldly
even then, and prohibitive in papers with more instances.

> I trust this helps.

thank you for the ideas!

f.

--
Felmon Davis

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


 

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

[Andrew Pitonyak]

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 have been using Open Office. Yesterday, I installed Microsoft Office
>365 Personal. Now I have the following issue:
>
>I cannot open xlxs files. I have to use Open Office and cannot open
>with Microsoft Office. This is true of Words documents too.
>
>Does Open Office take precedence over Microsoft Office?
>
>I need to import xlxs files into JotForm and cannot do so at present.
>
>Could you please help?
>
>Thanks so much,
>Juliana

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

[Andrew Pitonyak]

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 to do that in Windows, try Google. I 
don't know how to do any of that because I don't use Windows really, I'm a 
Linux guy, but I understand the problem.

Hope it helps at least a little.

⁣Sent from BlueMail ​

On Aug 31, 2019, 6:39 AM, at 6:39 AM, Juliana  wrote:
>Hi Team,
>
>I have been using Open Office. Yesterday, I installed Microsoft Office
>365 Personal. Now I have the following issue:
>
>I cannot open xlxs files. I have to use Open Office and cannot open
>with Microsoft Office. This is true of Words documents too.
>
>Does Open Office take precedence over Microsoft Office?
>
>I need to import xlxs files into JotForm and cannot do so at present.
>
>Could you please help?
>
>Thanks so much,
>Juliana

Re: templates

[Andrew Pitonyak]

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

[Andrew Pitonyak]

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 cannot edit (or see) certain 
sections. If yes, how were the passwords set for this section? 

Is the macro fully available to see / edit without using a password? 



On Friday, March 01, 2019 09:39 EST, Mark Hodgen  
wrote:
  
Good Afternoon,


 
We have been using Open Office spreadsheets for a few years. Our document 
manager who created the spreadsheet with Macros has since left, and now we have 
no access to update the passwords that the Macros set.


 
Please advise if there is a workaround to accessing the Macro password 
protected area?


 
Screen shot below for assistance:


 



 
Kind Regards

Mark Hodgen
Operations Director


w: +44 (0)2892 616 800
m: +44 (0)7929 059 072
mark.hod...@datumireland.com


 


 

Re: Excel

[Andrew Pitonyak]

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 assumes that you really want to install Excel 
and says "sorry, we do not support that here".


So, despite the fact that I rarely use apple products, and most of my 
interactions with iPads and iPhones have been very negative, perhaps I 
should answer.


If you look here:

https://discussions.apple.com/thread/8198018

It states that the only way to install apps on your pad is to use the 
App store and that neither OpenOffice nor LibreOffice are on the app 
store.


If you really do want excel:

https://itunes.apple.com/us/app/microsoft-excel/id586683407?mt=8

There is apparently another app called "Numbers" that is well rated, 
but I did not look into it.




On 2018-08-09 21:52, Michael Lass wrote:

Sent from my iPad Please help me get Excel hooked up to my I pad
or is this possible?
Thank you very much !
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org


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

Re: SV: Help numbering papers

[Andrew Pitonyak]

I can think of no way to print multiple directly with a different result every 
time unless

1. You use mail merge

2. You generate a multi-page document using a field that increments

3. Use a macro that prints and increments multiple times.

Others probably have better ideas than I.

⁣Sent from BlueMail ​

On Jul 3, 2018, 3:51 AM, at 3:51 AM, Caroline Molin  
wrote:
>I have a single document and when I print 50 copies I need a new number
>for each one. So it would be 9990001 on the first and 9990050 on the
>last. I have never made a macro so I guess I'll have to look into that.
>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 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 with the text 9990002.
>
>
>OR
>
>Were you hoping to print the document, request 10 copies, and have it
>print with a different number each time?
>
>OR
>
>You have a single document containing the same text 50 times and each
>copy  contains a different number?
>
>
>In my mind, I would write a macro to change the number then print the
>document (if that workflow is possible), but I write many macros!
>
>
>On 2018-07-02 5:59, Caroline Molin wrote:
>> Hello, I work for a company called Betonglarsson. We use Apache
>> OpenOffice to print transport reports (see attachmet). Now I need
>> help
>> to add the order number where it says NUMBERS, and I need those
>> numbers to change everytime that I print one. I normally print 50 at
>> a
>> time and I have been manually writing the order number on these but I
>> was wondering if there is a way to add an order number to these like
>> a
>> page number? Our order numbers normally starts with the numbers on
>> the
>> licence plate. Here is an example "9990001". We have about 40-50 cars
>> so I need to be able to change the numbers each time I need to print
>> for another car. Thank you in advance!
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Help numbering papers

[Andrew Pitonyak]

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 with the text 9990002.



OR

Were you hoping to print the document, request 10 copies, and have it 
print with a different number each time?


OR

You have a single document containing the same text 50 times and each 
copy  contains a different number?



In my mind, I would write a macro to change the number then print the 
document (if that workflow is possible), but I write many macros!



On 2018-07-02 5:59, Caroline Molin wrote:

Hello, I work for a company called Betonglarsson. We use Apache
OpenOffice to print transport reports (see attachmet). Now I need 
help

to add the order number where it says NUMBERS, and I need those
numbers to change everytime that I print one. I normally print 50 at 
a

time and I have been manually writing the order number on these but I
was wondering if there is a way to add an order number to these like 
a
page number? Our order numbers normally starts with the numbers on 
the

licence plate. Here is an example "9990001". We have about 40-50 cars
so I need to be able to change the numbers each time I need to print
for another car. Thank you in advance!

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

[Andrew Pitonyak]

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 7:32 PM, Mike  wrote:
>Exactly!  He can discuss OO without proselytising his religion.  I also
>
>find it offensive, intrusive and irritating.
>
>Mike Shearer
>
>On 18/11/2017 9:41 am, John Hart wrote:
>> On 11/17/2017 5:11 AM, James Knott wrote:
 God bless you!
>>> I find that offensive.  Religion is delusion, which has no place in
>the
>>> real world.
>> Just because you have a defective concept of God, is no reason for
>> starting
>> a flame war on this list. He provided links that may or not be
>relevant,
>> comments about them are useful, discussions about religion have no
>> place in this list!
>>
>
>
>
>
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Andrew Pitonyak]

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 away from this discussion group.
>
>Please purge that Muslim evangelist out of this group for his offensive
>post.
>
>On Fri, Nov 17, 2017 at 4:32 PM, Mike 
>wrote:
>
>> Exactly!  He can discuss OO without proselytising his religion.  I
>also
>> find it offensive, intrusive and irritating.
>>
>> Mike Shearer
>>
>> On 18/11/2017 9:41 am, John Hart wrote:
>>
>>> On 11/17/2017 5:11 AM, James Knott wrote:
>>>
 God bless you!
>
 I find that offensive.  Religion is delusion, which has no place in
>the
 real world.

>>> Just because you have a defective concept of God, is no reason for
>>> starting
>>> a flame war on this list. He provided links that may or not be
>relevant,
>>> comments about them are useful, discussions about religion have no
>place
>>> in this list!
>>>
>>>
>>
>>
>>
>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>>
>
>
>--
>Howard Blum
>Pro Mobile Notary
>PO Box 834
>Novato, CA 94948
>415-898-4130
>http://pro-mobile-notary.com

Re: I need some help

[Andrew Pitonyak]

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 really curious what your application is...

So you need to do something like "=A1 - 71" in to cell B1.


3. I need to divide the result of columns 1 and 2 by "5'


Do you mean that column C must contain (A1 - 71) / 5, and you need to 
pull the value from column B?





4  I need to divide the result of columns 1 and 2 by "8"



5. I need to divide the result of columns 1 and 2 by "11'




Suzanna Reiff
suzannare...@aol.com


Is this for a class, or do you simply need to create some data for your 
own personal use?


Are you trying to use regular formulas, or an array formula?

Re: reveal codes

[Andrew Pitonyak]

On 2017-08-10 7:14, Rory O'Farrell wrote:

On Thu, 10 Aug 2017 07:08:16 -0400 (Eastern Daylight Time)
Robert Funnell <robert.funn...@mcgill.ca> wrote:


On Thu, 10 Aug 2017, Stephen Nichols wrote:

> Let me clarify.  The “codes” revealed are not what your 
thinking of — tags with bracketed text, XML code, etc..  I think 
that the viewing option should more properly be called “Reveal 
Structure” since it simply shows what formatting instruction has 
been given and where, specifically things like, typeface and size, 
indentations, line spacing, etc..


You're right that what is wanted is not an exact display of the 
actual
internal coding but rather some visual indication of what's going 
on.


To me the value of RevealCodes in WordPerfect was not just in seeing
the structure but in therefore being able to position the cursor
before or after (or inside or outside of) a particular style. This
would be just as useful in OO and LO.

- Robert


If one turns on /Format /Styles and Formatting, it clearly indicates
the current formatting style at the cursor position.

/View /Non printing characters is helpful in showing spacing and
paragraph/line ends.



I tested the reveal codes macro years ago. last time I tried it, I had 
to make changes to the underlying code to make it work. I don't remember 
exactly what it showed, or, how it showed it. Also, it did not entirely 
work as the system worked in WP, not that I entirely remember how that 
worked, but, here are some issues with reveal codes in LO / AOO.


The first issue is related to styles. So, if you want to know why your 
text is bold, it may be because there is a style making it so and it may 
be because someone applied direct formatting. So, coming out of the 
gate, there is always the question of what does one show with reveal 
codes? Do you show the styles or just the formatting? For sure this is 
useful functionality.


I don't even remember exactly what WP did. Could I start "BOLD" and 
then not turn it off? This is not possible the way that AOO is written.


I think that the bottom line is that "sure, it would be great", it is 
possible to do, the created extension provides (does it still work?) 
some approximation, the developers have not yet considered it 
sufficiently interesting to work on it (and I think it would require 
significant time to integrate it).


I think 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

[Andrew Pitonyak]

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 last styled character, the text you 
add

will also be styled. You need to position your cursor after the first
_unstyled_ character that follows, insert your new text, and then 
back

up and delete that first unstyled (and now unwanted) character. With
RevealCodes turned on in WordPerfect, you would just position your
cursor after the end-of-style indicator and start entering unstyled
text.


well, the only difference is that you may NOT be able to position the 
cursor outside of the formatting mark. something that reveals the codes 
would clearly show that this is the case. So, what you would need to do 
is to place the cursor as close as you can get, and then manually set / 
change the style. The only functionality that you are missing is things 
such as:


1. An ability to force the cursor past a formatting mark or style, 
which may not be possible to do with AOO. No, really.
2. The ability to delete a formatting mark from within "reveal codes" 
window. I think you could do that in WP anyway.


Both of these could be worked around in a native version of the 
capability, but, for now, that is not available, and, I do not expect it 
to be available anytime soon since I have not heard that anyone was 
working on it. So, the question is, (1) how can you request that it be 
added [open a request] and (2) how can you use what is currently 
available to solve your existing "problem" to accomplish your goal. The 
way that I usually work around this is by placing the cursor where I 
want it and start typing. if it starts working in Bold, and I don't want 
bold, then I highlight it and make it not bold (as one example). Would 
it be faster to press the "show me codes" key, move the cursor, then 
type? Maybe. I don't think that we have the problem with empty tags in 
AOO that we had in WP, so I don't think that you need to use it to 
remove empty tags.


So, you might want to find that reveal codes macro (I think that 
someone had a link to it) and give that a try, see about opening a 
feature request, and, if you are unsure how to work around a specific 
behavior, describe it.


It will not be the same, even if someone can carefully defines how it 
should work in AOO (because it cannot be exactly the same because of 
styles). Best of luck


andy

Re: Lost Password

[Andrew Pitonyak]

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 normal password variation 
patterns;
* Try each of those variant patterns, until you find the correct 
password;


In other words, there is no back door; sorry.

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

[Andrew Pitonyak]

On 2017-06-29 15:55, QCIT3 MMisonora wrote:

Hi there,

I am a new user to OpenOffice and was wondering if when I write lets
say a spreadsheet with macros on it and sent to someone who would 
have

to open that file in Excel cause they don't use OpenOffice, would the
macros still work or would it not work like when one opens an Excel
file with macros and it doesn't work.

Thanks,

Emma


It is very very unlikely that it would work because the internal object 
models for manipulating a document are different. If all your macro does 
is say print a number using the print statement or message box, 
probably; but I hvae not tested it.


Andrew Pitonyak

Re: Macro Troubles

[Andrew Pitonyak]

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 use 
"Target.RangeAddress.StartColumn". If this is already a Range address, 
then you should be able to use "Target.StartColumn".


I know this is not a cell address, or Column would already work. Does 
it work if you use "Target.getCellAddress().Column"?


Sadly, you probably need to fix (1) before looking at (2).

Question (1) is more difficult because you want to perform a search.

I assume from the name that rng is a sheet range, Sadly, searching in 
AOO is much more difficult than in Excel (using macros).


If you comment out the offending lines, does it complain if you use 
something like:


rng.CreateSearchDescriptor()

If that does not cause a failure, then you have a sheet cell range and 
you can create a search descriptor. I hvae no idea about the use of 
Lookat or LookIn.


Here are some of the properties that are probably supported by your 
search descriptor.


STRING  ImplementationName = ScCellSearchObj
STRING  ReplaceString =
BOOL  SearchBackwards = False
BOOL  SearchByRow = False
BOOL  SearchCaseSensitive = False
BOOL  SearchRegularExpression = False
BOOL  SearchSimilarity = False
INTEGER  SearchSimilarityAdd = 2
INTEGER  SearchSimilarityExchange = 2
BOOL  SearchSimilarityRelax = False
INTEGER  SearchSimilarityRemove = 2
STRING  SearchString =
BOOL  SearchStyles = False
INTEGER  SearchType = 0
BOOL  SearchWildcard = False
BOOL  SearchWords = False

I am guessing that this does a row based search, so you might begin 
with something like:


Dim oSearchDescriptor
oSearchDescriptor = rng.CreateSearchDescriptor()
oSearchDescriptor.SearchByRow = true

Your macro searches in the direction last used (or so it seems), if 
not, it seems that you can probably set SearchBackwards to true or false 
depending on the direction that you want.


Beyond that I am only guessing. Is this looking for the text "*"? I 
have no idea what your second parameter does there.


If you can fill out the search descriptor, you will probably need to 
use something like this totally untested


  Dim oFound
  oFound = rng.findFirst(oDescriptor)
  Do While Not IsNull(oFound)
' Do something with the oFound object
' Off hand, it looks like you really only need to find the first 
thing
' and then use it for something. Maybe you really just need to find 
the last one, I can only guess.

' I am really guessing on this next line.
oFound = rng.findNext(oFound, oDescriptor)
  Loop



On 23.06.2017 13:24, QCIT3 MMisonora wrote:

Hi there,
I have an excel file with macros on it and have gotten it onto
OpenOffice, but the coding for the macros on the file keep saying
there is an error, so I was wondering if anyone can please inform me
as to how I can fix these two lines in two separate codes.

   1. LastSn = rng.Find("*", rng.Cells(1), Lookat:=xlPart,
LookIn:=xlFormulas, SearchOrder:=xlByRows,
SearchDirection:=xlPrevious, MatchCase:=False) .Row

   2. TargetCol = Target.Column


Thanks.


Sent from Outlook

Re: word

[Andrew Pitonyak]

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 supported format and submit that.


There may be a few formatting issues when saving in a different format, 
but, these usually require complicated constructs not used when 
submitting for publication; for example, worrying about precise 
placement of a figure relative to a paragraph. These sorts of things are 
usually changed by an editor using fancy programs to get the layout as 
they want it, so it has, in my experience, not mattered.


Even if it did matter, support is sufficiently good, that it still does 
not matter (in general).



On 01.03.2017 09:25, Alan Strauss wrote:

I have an article I am writing that is required to be written in
microsoft word.  My friend said that the word processing system
provided with open office is exactly the same as “word”.  If I
submit the Article in the open office text system will they be able 
to

use it without any problems?

thank you

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

Re: Excited Aspiring Writer Looking to gain Experience

[Andrew Pitonyak]

 

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/


https://www.libreoffice.org/get-help/documentation/ 

On 30.01.2017
14:06, Kevin wrote: 

> Hello there, 
> 
> I'll keep it short as I'm
sure you're busy; my name is Kevin and I'm an ambitious young writer
trying to make a name for myself in the writing world. I think I can
provide you with some great work at Apache Open Office and hope there is
an opportunity for me to create some original work for you in a non-paid
role. 
> 
> Recently, I started a sports blog called USS Sports Machine
with some talented friends from college but I'm looking for other
opportunities to expand my range and learn more everyday. Here is my
most recent post for USSSM: 
> 
>
http://www.usssportsmachine.com/news/2016/12/2/netflix-now-allows-downloading-of-content

> 
> Hopefully you can find a use for my talents, as I'm a pro with
Wordpress and blogging and pick up content management systems very
quickly. Please let me know if you can find a spot for me, I can write
about absolutely anything and everything! 
> 
> If unfortunately you're
the wrong person to speak with, I would sincerely appreciate you
forwarding along my information to the right person.Thanks in advance!

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

 

Re: converting MS Works files

[Andrew Pitonyak]

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
>OpenOffice. You can do this using a online document converter or by
>using doxillion converters
>
>Sent from my iPhone
>
>> On Nov 29, 2016, at 5:11 AM, Joseph J. Haubrich
> wrote:
>> 
>> How can I convert my MS Works files to Open Office?
>> Especially MS Works Database file.
>> What files does Open Office support?
>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: converting MS Works files

[Andrew Pitonyak]

⁣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" 
 wrote:
>How can I convert my MS Works files to Open Office?
>Especially MS Works Database file.
>What files does Open Office support?
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: DOCX file extension

[Andrew Pitonyak]

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 are willing to do this and can't see how, mail 
this list and ask for help with that.⁣

Sent from BlueMail ​

On Nov 26, 2016, 3:21 PM, at 3:21 PM, Felmon Davis  wrote:
>On Sat, 26 Nov 2016, Larry Gusaas wrote:
>
>>
>>
>> On 2016-11-26, 1:59 PM Jim McLaughlin wrote:
>>> Not directly.  One of the many "features" of OO 4,x.x
>>
>> BS. I can open any docx files that have been sent to me with Apache 
>> OpenOffice.
>
>not complete BS - I have encountered .docx files I cannot open. if I 
>then load them up to google-docs, they open fine and I can save them 
>as .odt or whatever. I'd say out of about 300 .docx files I've dealt 
>with since September (I've dealt with many more actually in this 
>period), I stumbled across this once. typical rate in my experience.
>
>I'm still on 4.1.1.
>
>f.
>
>  >
>>> On Sat, Nov 26, 2016 at 6:59 AM, David Kendal  wrote:
>>> 
 Hello,
 
 I have the most recent version of Open Office but am unable to
 open DOCX files sent to me.
 
 Is there a way of opening these files?
 
 Thanks,
 
 David Kendal
>>> 
>>> __
>>> 
>>
>>
>>
>
>-- 
>Felmon Davis
>
>In the beginning there was nothing.  And the Lord said "Let There Be 
>Light!"
>And still there was nothing, but at least now you could see it.
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

RE: Questions about AOO Users

[Andrew Pitonyak]

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 answers by November 28, 2016
>
>Thank you again.
>
>Crystal Buckneberg
>crystal.buckneb...@southeasttech.edu
>Computer Programming Student
>Southeast Tech AITP Webmaster
>
>-Original Message-
>From: Buckneberg, Crystal R
>[mailto:crystal.buckneb...@southeasttech.edu] 
>Sent: Wednesday, November 23, 2016 12:59 PM
>To: users@openoffice.apache.org
>Subject: Questions about AOO Users
>
>Dear Sir or Madam,
>
>Greetings!  My name is Crystal Buckneberg and I am currently working on
>a project for Technical Writing (A college level class I am currently
>taking at Southeast Technical Institute in Sioux Falls, SD USA) that is
>comparing MS Office, OpenOffice and LibreOffice and then making a
>recommendation to a client on which one to use.  I have a few questions
>that will help me to pull this document together if you have a few
>minutes of time.
>
>I will need an answer on or before 28-Nov-2016 so I have time to
>integrate your information into the report.
>
>
>1.)What is your official title within the Apache Software
>Foundation organization?
>
>2.)Approximately how many users of OpenOffice are there worldwide?
>
>3.)Do you have an estimate as to how many of those users are in the
>United States?
>
>4.)On average per year, how many times does OpenOffice release an
>update/patch?
>
>I need to know this information by November 23, 2016 so that I can
>integrate this information into my report.
>
>Thank you for your time and consideration.  I hope to hear from you
>soon.
>
>Sincerely,
>Crystal Buckneberg
>crystal.buckneb...@southeasttech.edu
>Computer Programming Student
>Southeast Tech AITP Webmaster
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Andrew Pitonyak]

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 think you can insert a 
field containing the current file name.


Insert -> Fields-> Other... on document tab under type click filename 
and under Format click the format you want. That will insert the name 
of the current document in the format specified. You must save the 
document for the field to be populated.


Sorry, but this works - of course - in a text (Writer) document. The
questioner wants the same functionality instead in a spreadsheet
document.

Brian Barker


Thanks Brian, smack head.

Now that I have computer access, I see that you are correct.

In Calc, you can use this, which includes the current sheet.

CELL("filename")

If you just want the URL without the sheet name, this will suffice:

=MID(CELL("filename");2;FIND("'#";CELL("filename"))-2)

I won't bother pulling out the filename without the path and URL.

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

[Andrew Pitonyak]

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)
>
>WIN10x64
>
>
>
>
>I would like to include the full path or filename within a CALC cell
>and 
>within the print range area.  Is this possible ?
>
>Regards,
>
>VinceB.
>
>
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: mp4 video not supported in Impress

[Andrew Pitonyak]

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 encode the 
contained video? It is similar to saying that you cannot play the video 
contained in a ZIP file. OK, so the comparison is not really good, 
but


If the codec used is not supported, then for certain you cannot do it.

I spend little to no time doing this sort of thing, but, I believe that 
you can use a program called "mediainfo", but I would first check to see 
if your OS supports just giving you that information with an already 
installed tool:


https://sourceforge.net/projects/mediainfo/
https://mediaarea.net/en/MediaInfo

Again, I have NOT tried these two programs, but I found it listed in 
the following article that lists five tools to find out about the codecs 
used


https://www.raymond.cc/blog/determine-audio-video-codec-required-to-play-downloaded-movies/

Now, that said, give this a read:

https://forum.openoffice.org/en/forum/viewtopic.php?f=10=44180



On 09.09.2016 12:44, Julian Thomas wrote:

I am unable to insert an mp4 video in OO 4.1.2 in either windows 10
or Macos.  Is there a fix for this?
 —
jt - j...@jt-mj.net

Do unto those downstream as you would have those upstream do unto
you. - Wendell Berry





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

Re: Ribbon Interface

[Andrew Pitonyak]

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 currently working on a project where I've had to use excelwhat
>a
>pain!!
>
>On Thu, Sep 8, 2016 at 9:04 PM, Tai Nen Chow 
>wrote:
>
>> Hi, just wonder when will Open Office release ribbon interface
>version?
>>
>>
>> Best regards,
>>
>> Open Office Supporter(Malaysia)
>>

Re: Updates

[Andrew Pitonyak]

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

[Andrew Pitonyak]

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  wrote:
>
> A quick lesson on top posting. 
>
> A: Because it messes up the order in which people normally read text. 
> Q: Why is top-posting such a bad thing? 
> A: Top-posting. 
> Q: What is the most annoying thing in e-mail? 
>
> http://en.wikipedia.org/wiki/Posting_style 
>
> Skip H 
>
>
> - 
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org 
> For additional commands, e-mail: users-h...@openoffice.apache.org 

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

[Andrew Pitonyak]

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 helps 
little. If you ate already well versed in their use or is generally easier to 
use them than not, but you can usually must ignore them and it does not matter.

I have a friend who uses word perfect. In all her documents she set spacing in 
her paragraphs by adding spaces. She saw no use for that whole setting the 
margins and indents.. Until she had to change them and / or insert text.

On Jun 25, 2015 7:57 PM, Jim McLaughlin jjim.mclaugh...@gmail.com wrote:

 Anthony - 

 I'm with you.  The whole styles approach is ridiculous. 

 I still have a  great fondness for Word Perfect.  The Reveal Codes 
 function gave me total control.  Even more so than Micro$loth Word. 

 Sadly, for all practical purposes, Word Perfect is functionally dead. 

 OO is a  poor second, IMHO. 

 On Thu, Jun 25, 2015 at 5:26 PM, Anthony J. Rudgers anthonyrudg...@att.net 
 wrote: 

  What do you do if most every document you create with your word processor 
  (WP) is in a different style,  you don't know its style until you 
  finish creating it?  For my personal use, I create a lot of specialized 
  lists  inventories w/ my WP, in addition to creating documents  written 
  articles in many  varied  formats.  To address the responder of my initial 
  posting, let me say:  I've invested a lot of time in trying to become 
  proficient in Writer styles w/o much success.  Also, I bought every 
  reference I could find on 'Writer,' but still couldn't get that Writer WP 
  to produce the documents I needed in the format I wanted.  What is more, 
  when I was required to re-edit a Writer document at a later time, I found 
  the re-editing often undid all the formatting I thought I had built into 
  the Writer document.  I don't mind investing in computer programming 
  technology that serves my needs.  (For a selfie aside,  I started in 
  the computer business in 1961,  was, at various times, fluent in 7 ea. 
  different computer languages.  So I know what it means to invest one's 
  time  effort to acquire proficiency w/ a particular software product.)  I 
  decided w/ Writer that I wasn't making progress getting my work done. 
  Therefore, I decided to invest my time  energy elsewhere.  In consistency 
  w/ my previous experience,  I chose to invest my time  energy in the 
  so-called tried  true--in this case MS Word.  My priority has always 
  been on getting my work done efficiently,  not on learning to become 
  proficient w/ any particular software product. 
  
  Best wishes, 
  
  Anthony J. Rudgers 
  Orlando, FL 
  Posted: June 25, 2015; 8:25 pm 
  
  -Original Message- From: Dale Erwin 
  Sent: Thursday, June 25, 2015 2:10 AM 
  To: users@openoffice.apache.org 
  Cc: Anthony Rudgers 
  Subject: Re: warning - Editor Wars!!!--how about some heresy on behalf of 
  the Joe 6-Pack word processor user 
  
  On 6/23/2015 10:53 PM, Anthony J. Rudgers wrote: 
  
  As to word processors suitable for the general user, my vote is for 
  Microsoft Word.  While, like most everyone on our Planet, I'd like the 
  proverbial free lunch, I don't expect to get one.  However, I found I 
  can 
  get MS Word to give me the text I want to type almost always.  But when I 
  use Writer, I keep getting something I have to constantly diddle with to 
  get it to appear in the form I want.  And, if I want something fancier 
  than 
  simple text, I can get that too with MS Word.  I'd like Writer fine if 
  only 
  I could sit down at my computer  prepare a document using it without 
  constantly undoing all the things built into Writer that I've never 
  figured 
  out how to turn off or to modify. Of course I had to pay a somewhat steep 
  price to get a WP that served my needs, but my time is valuable to me too, 
  so the ease of use  the reliability of MS Word seems well worth the cost 
  in the long run. 
  
  
  I think if you would take the time to learn how to use styles you would 
  find that Writer can be just as versatile as Word, if not moreso.  I 
  struggled against it for a long time before I finally broke down and 
  made the time to learn how to use them. 
  
  Dale Erwin 
  
  - 
  To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org 
  For additional commands, e-mail: users-h...@openoffice.apache.org 
  
  - 
  To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org 
  For additional commands, e-mail: users-h...@openoffice.apache.org 
  
  

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org

Re: Email association

[Andrew Pitonyak]

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 have Comcast.net.  I don’t have a lot of experience with computer 
 functions but I have been trying to figure this out. Looking forward to being 
 able to get this working. 


 Thanks 

 Jamie 






 Sent from Surface

Re: Problem

[Andrew Pitonyak]

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 mickey being so bloody 
 useless. When I have 2 excel files open at the same time it crashes. Then it 
 uses the recovery feature but doesn’t recover the file to where it crashed 
 only to the last save therefore its not a recovery is it!!! As I have to 
 start all over again. Sort the act out please and get it corrected.

Re: A question

[Andrew Pitonyak]

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 tetimo...@hotmail.com 
 To: users@openoffice.apache.org 
 Sent: Tuesday, March 24, 2015 9:47 PM 
 Subject: A question 


  Hi, My computer crashed and so I had to save my document but now it says 
  it is locked how do I un lock my file? Please advise thanks 
  
  ~Molly 
  
  
  
  
  
  
  
  
  Sent from Windows Mail 


 --- 
 Tato zpráva byla zkontrolována na viry programem Avast Antivirus. 
 http://www.avast.com 


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