Re: Help Me Make This Faster

[toki]

On 06/22/2017 07:22 PM, QCIT3 MMisonora wrote:

> The computers we are using are Windows 7 computers that run on a Core 2 Duo 
> with 2 GB of RAM and a 32-bit Operating System.

Your first problem is that you don't have enough RAM for the OS you are
using.

The second problem is that you don't have enough RAM for the OS and
software that you want to use.

IOW, upgrade those computers to at least 8 GB RAM.

jonathon


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

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

Macro Troubles

[QCIT3 MMisonora]

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

Macro Code Trrou

[QCIT3 MMisonora]

Hi there,

I just gotten the macros on a file that was originally from Excel to OpenOffice 
to appear and sometimes run. However, on one of the macros there is a mistake 
on one of my lines according OpenOffice and was hoping if someone can tell me 
how to fix it. The line says "LastSn = rng.Find("*", rng.Cells(1), 
Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, 
SearchDirection:=xlPrevious, MatchCase:=False) .Row)"

Sent from Outlook

Re: Help Me Make This Faster

[Johnny Rosenberg]

2017-06-22 21:22 GMT+02:00 QCIT3 MMisonora :

>
> Hello there,
> Recently the company I am working for has downloaded your program,
> OpenOffice and have tried to open some files we have previously made files
> on Windows Excel with your program. However, it took about twenty minutes
> to load, so I was wondering why is it loading so slow and how can we make
> it load faster. The computers we are using are Windows 7 computers that run
> on a Core 2 Duo with 2 GB of RAM and a 32-bit Operating System.
> Please help,
> Emma
>
>
Have you tried to open it with LibreOffice? I think they worked a little
more with these kinds of issues. Maybe it will open faster, or maybe not. I
don't know since I only work with ODF, but it wouldn't hurt to try, I guess.


Kind regards

Johnny Rosenberg



>
> Sent from Outlook
>

Re: Can't get my old installation

[Destynnie Hall]

Thank you. This is what I was looking for.
I have no idea how I originally got this, but this has solved my issue.
Again, thank you.




*Destynnie Hall | *Content Director
McGuffin Enterprises SEO Technical Firm

On Thu, Jun 22, 2017 at 11:48 PM, Martin Groenescheij <
mar...@groenescheij.com> wrote:

>
>
> On 23/06/17 2:01 AM, Destynnie Hall wrote:
>
>> Hi there, I had an outdated version of openoffice installed and I decided
>> to update it yesterday thinking, hey, I never update these things, let's
>> give it a go.
>>
>> Well, now I can't find my openoffice writer. I can open openoffice and
>> select "text document" but I can't directly open up the writer anymore, as
>> the file doesn't seem to exist.
>>
>> All I used was the writer program (as I am a writer and the openoffice
>> program was by far the most comfortable writing program I have found.)
>>
>
>
> On your desktop select New -> Shortcut and past "C:\Program Files
> (x86)\OpenOffice 4\program\swriter.exe" into the field.
> Now you have a desktop icon that starts Writer with a new document
>
>
>
>> I've tried uninstalling the latest version and I tried each version down
>> to
>> 4.0.0, and I'm fairly certain I had a version above that, but they all did
>> the same and I could no longer access the writer directly.
>>
>> I currently have the latest version installed, but I thought I'd send out
>> an email before looking for a new writer program - I really did enjoy it
>> and I'm not entirely sure how to get it back, so if you could help me,
>> that
>> would be fantastic. I don't care much what version I get aha.
>>
>>
>