| Poll question |
|
Is automatic numbering the work of Satan?
|
| User of the Moment |
Viewing profile :: ColD
Joined: 2306 Days
Posts: 1
Location:
|
|
| How do you set the default font in OOo Calc
for CSV import? |
Author:
bobtestact ::
Posted:
Fri Jan 01, 2010 6:04 pm
Whenever I import a CSV file with OOo Calc, it is always displayed in the
"Liberation Sans" font. There's another font that I would prefer to
use by default for this.
Where can I change this default font? Hopefully, somewhere (either in the UI or
a config file) there should be a setting with a value of "Liberation
Sans" that I can change to the font of my choice.
(I tried setting a default template, but that didn't work. The default template
appears to be applied only to a new blank spreadsheet, and it not used for CSV
import.)
I use Ubuntu 9.10.
|
| limit on sorting in table |
Author:
dhagner ::
Posted:
Fri Jan 01, 2010 5:57 pm
I have 321 page of information and I am trying to sort the fields... Is there
a limit and what is the page limit...
Nane Event date place
I am trying to sort 1st the place and then event and then dates....
|
| Access Database Form Controls with macros |
Author:
ottoshmidt1 ::
Posted:
Fri Jan 01, 2010 5:18 pm
I can easily access form controls if this form is built in Writer with
following command, for example:
Sub butt
Dim Doc As Object
Dim Form As Object
Dim Ctl As Object
Doc = ThisComponent
DrawPage = Doc.DrawPage
Form = DrawPage.Forms.GetByIndex(0)
Ctl = Form.getByName("TextBox")
msgbox Ctl.text
End Sub
How would I get a textbox string from Database Form? It seems that
ThisComponent.Drawpage method doesn't work for Base.. 
|
| Select box size. |
Author:
donmac64 ::
Posted:
Fri Jan 01, 2010 4:51 pm
Select box.
When I select multiple rows and columns Excel used to show the size of the
selected area in the ”Name Box” (10R x 4C). In Calc it shows the min and
max row and column (b3:h10). I can’t find any where to show this the other
way.
This Difference is driving my girlfriend insane and is nagging me to switch
back to Excel. HELP!
Is it possible to show the selected box size somewhere, anywhere! The status
bar would be fine.
|
| Trapping Constraint Violations in a
Form/Macro |
Author:
gladtobegrey ::
Posted:
Fri Jan 01, 2010 4:16 pm
I'm new to Base/HSQL.
I have a simple HSQL database table which includes, inter alia, two Date fields
- ValidFrom and ValidTo. I also have a Form defined for data maintenance on
that table.
I want to ensure that ValidTo is >= ValidFrom when entered (via the Form),
so I've defined a Constraint. The constraint works fine, but the default error
message displayed when the constraint is violated is pretty unpleasant for the
intended (non-technical) end user. I want to trap the violation and issue a
more user-friendly error message.
So, can some kind someone explain how I can trap the error raised by the
Constraint violation in a Form macro when entering new records? I've tried
searching various fora, including this site, with no success. I've also tried
coding the (OpenOffice Basic) macro several ways, with no joy - all I get are
the default error messages. I suspect I'm using the wrong Form event, or
something like that.
Help?
|
|
| Welcome |
Welcome to OOoForum.org, the OpenOffice.org Forum!
�
Register
|
| Stats |
Our users have posted a total of 319307 articles.
We have 82936 registered users.
The newest registered user is bobtestact.
In total there are 42 users online:
dhagner, novaguy, pinorosso, 39 Guests
|
| This site is sponsored by: |
 |
|
