| Poll question |
|
Should We Have To Sacrafice Space at the Top or Bottom for Page Numbers, Or Should The Program Just Put them in their Proper Corners Without Taking Up Whole Lines?
|
| User of the Moment |
Viewing profile :: fedoracore
Joined: 3161 Days
Posts: 1
Location:
|
|
| Table to column |
Author:
Marki ::
Posted:
Tue May 21, 2013 2:28 am
Hi!
I want to generate one column from table. For example:
Table:
A1,A2,A3
B1,B2,B3
C1,C2,C3
to column:
A1
A2
A3
B1
B2
B3
C1
C2
C3
I've got table 40x40.
Thx
|
| trying to convert a DDE Macro over from VBA
Excel to SB OO |
Author:
DragonSky3 ::
Posted:
Mon May 20, 2013 6:00 pm
Hey everyone, I am trying to convert a DDE macro that takes quote-data from a
trading data-feed on my computer from VBA to SB for use in OOo. I have gotten
some of it switched over, but it errors out on this line first;
| Code: |
| Dim rngActiveRange As Excel.Range |
I have not been able to find something similar but here is all of the code to
get an understanding. Basically it looks at column A and Row 1 for the data to
populate the fields which are the Symbol and Field of data that I am requesting
like the Last Trade price of that symbol.
Here is the code any help you can give me would be wonderful and appreciated.
| Code: |
Dim rngActiveRange As Excel.Range
Dim count, FirstRow, FirstColumn, LastRow, LastColumn, TempRow, TempColumn
Dim myCount, newHour, newMinute, newSecond, waitTime
'retrieve the location of selected cells
Set rngActiveRange = Selection
FirstRow = rngActiveRange.Row
FirstColumn = rngActiveRange.Column
LastRow = rngActiveRange.Rows(rngActiveRange.Rows.count).Row
LastColumn = rngActiveRange.Columns(rngActiveRange.Columns.count).Column
'loop through the selected cells, and formulate the DDE Formula
'based on the row directly above the selection, and the column directly to the
'left of the selection
For TempRow = FirstRow To LastRow
For TempColumn = FirstColumn TO LastColumn
ActiveSheet.Cells(TempRow,
TempColumn).Select
'This will popluate the formula
=DDE("Source";"Symbol";"Field")
If ((Cells(TempRow, FirstColumn
- 1) <> " ") And (Cells(FirstRow - 1,
TempColumn) <> " ")) Then
ActiveCell.FormulaR1C1 =
"=DDE(""IQLINK"";""" &
Cells(TempRow, FirstColumn - 1) &
""";""" & Cells(FirstRow - 1,
TempColumn) & """"""
myCount = myCount +1
if (myCount = 100) Then
'we have processed 100 formulas, so pause for one second before
continuing
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now())
waitTime = TimeSerial(newHour, newMinute, newSecond)
Wait waitTime
'reset myCount to zero
myCount = 0
End If
End If
Next TempColumn
Next TempRow
End Sub |
Now some of it has already been changed and was able to have it work, but now
it keeps erroring out so any help you can give me would be great.
Thanks.
|
| Problem: copy and pasted text pastes on wrong
page. |
Author:
Dawna P. ::
Posted:
Mon May 20, 2013 3:08 pm
Hi,
I'm writing a document with many pages and using page and paragraph styles.
The left pages of the document (I'll call it book) have a narrow left margin
and a wide right margin. The right page is a mirror image of that. This might
be important or maybe not.
Until now I've been successfully copying and pasting a series of stories each
of which is a separate saved file I stored in folders on my desktop. The story
pages don't have the same page style as the the book pages into which I'm
pasting them. Now when I try to paste a story into a left hand book page, it
automatically pastes into a new right page instead.
I've been careful to double click on the same page and paragraph styles that
I've been using on previous book pages. Then when I hit the backspace button
to delete the page, the OpenOffice program crashes. I had three files open
when this happened, and it happened three times.
I tried killing the OpenOffice processes and deleting my profile. It didn't
fix it, and neither did verifying Vista permissions for program files, desktop
shortcut, the desktop folder with the save story files, and App Data.
Can anyone give me a solution to this problem?
|
| Margins keep changing. |
Author:
Physical/Spiritual ::
Posted:
Mon May 20, 2013 2:40 pm
Hi everyone, this is my entry into the community.
I'm writing a story using 2 page setup;
1" inside and .5" outside (mirrored)
but the margins keep switching.
I'm sure there is a simple reason why this is happening.
But I can't keep it from changing.
I'm using Format/page/inner/outer
and it looks great until I return to the typing.
Ideas?
Thanks,
Michael
|
| Adding Page Numbers Without Headers/Footers
Taking Up Space |
Author:
TooMuchLoginInfo ::
Posted:
Mon May 20, 2013 11:05 am
How can you add a page number without loosing space at the top or bottom of the
page?
I know how to add page number 'fields,' and I get that concept: the number will
appear anywhere you put the field, and the field will be equal to whatever its
value is on that page.
But here's the problem: how do I get this field to appear in the corner?
Because if I use the header/footer soultion, which has automation options to
make it really fancy (left/right based on even/odd, etc) I have to sacrafice
the first line of the document.
When I insert the header, everything is pushed down, and the aethetic is
gravely disturbed. There is a wasteland of whitespace, usefull if you want
there to be a title or name at the top of every page, and it is I suppose nifty
that if I wanted to I could automatically alternatively titled even/odd pages
with appropriate left/right justification alternating the title and my name.
BUT ALL I WANT TO DO IS HAVE A RUDDY PAGE-NUMBER. Auto-alternate would be nice.
But all I NEED is a page-number, without any loss of space.
Thanks for reading.
|
|
| Welcome |
Welcome to OOoForum.org, the OpenOffice.org Forum!
Register
|
| Stats |
Our users have posted a total of 387405 articles.
We have 268573 registered users.
The newest registered user is AdvisorHarry.
In total there are 87 users online:
RPG, 86 Guests
|
| This site is sponsored by: |
 |
|