|
More site info...
OpenOffice.org Forum at OOoForum.org - www.oooforum.org | Site profile
|
|
Site profile page for http://www.oooforum.org.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.oooforum.org.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.oooforum.org is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on OpenOffice.org Forum at OOoForum.org:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
487
|
1,403
|
2,931
|
|
Post:
|
1,072
|
3,045
|
6,218
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for OpenOffice.org Forum at OOoForum.org (http://www.oooforum.org)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
OpenOffice.org Forum at OOoForum.org posting activity graph:
|
|
http://www.oooforum.org Alexa graph:
|
Top authors on OpenOffice.org Forum at OOoForum.org during last week:
user's latest post:
Using Saved Listbox Entries In...
Published (2009-11-24 13:40:00)
Hello Quote: - me, I am no programmer, I hate to tinker with code I do not understand When you mean with programmers basic or an other programming language you can without it or a little. But when you are working with a database then you have to learn SQL. But also this depends on what you want. You can use easy code and that means using the GUI or using more difficult code. I think try to work without macros and try to use those things what...
user's latest post:
Printing documents with dot...
Published (2009-11-23 23:04:00)
For some printers and font setups, using the printer's internal fonts will speed up things considerably. However, I believe this depends on printer font awareness in the OS, rather than in individual applications. Do you compare MS Office and OpenOffice.org on the same computer, using the same fonts? Office applications will substitute missing fonts with similar fonts. If OOo and MSO use different substitutions for a particular font,...
user's latest post:
Keep cells empty...
Published (2009-11-24 12:57:00)
Try something like this. =IF(AND(A1>0;B1>0);A1*B1;"")
user's latest post:
LOOKUP, newbie question
Published (2009-11-24 14:50:00)
A database takes millions of rows in one table. Each row is enforced to be complete, unique and consistent. If there is still a need for spreadsheet calculations or data pilots you can use the very same database data in Calc. _________________ XUbuntu 9.04, OOo 3.1.1(Sun), Sun Java 1.5.0_06
user's latest post:
Chinese Input - Special...
Published (2009-11-24 11:34:00)
Can you not select the quotes you want from the Times New Roman selection and get the required result switching between half and full punctuation in your input method?
user's latest post:
recurrent text defined in one spot
Published (2009-11-22 12:55:00)
I am not entirely clear what you desire, so two things come to mind. One possibility is to use a cross reference, but this may not be what you want. This is a reference like: The reference is in Table 2. In this case, if I add or remove tables, then "Table 2" may change automatically to become "Table 4" or "Table 1". Another option is a field (probably a text field) that is then inserted...
|
|
|
Top 10 active forums on OpenOffice.org Forum at OOoForum.org during last week:
|
|
Top 10 forums on OpenOffice.org Forum at OOoForum.org:
OpenOffice.org Writer
- 49,806 posts
|
OpenOffice.org Calc
- 36,903 posts
|
OpenOffice.org Macros and API
- 25,023 posts
|
OpenOffice.org Base
- 18,550 posts
|
Setup and Troubleshooting
- 17,270 posts
|
General Discussion
- 11,577 posts
|
OpenOffice.org Impress
- 5,331 posts
|
OpenOffice.org Draw
- 2,329 posts
|
OpenOffice.org Math
- 1,496 posts
|
Site Feedback
- 1,354 posts
|
|
|
|
|
Latest active threads on OpenOffice.org Forum at OOoForum.org:
Started 6 days, 16 hours ago (2009-11-20 18:24:00)
by David
Started 3 weeks, 3 days ago (2009-11-02 22:51:00)
by cyningstan
I'm having a simpler but related problem to the one posted first. In my case I have an entire subform Resident positioned in the middle of its main form Case, so the order of fields is along the line of:
Case ID details
Resident details (name, address, etc.)
Case specifics (description, notes)
This is the natural way to order the information from a user's point of view. But...
Started 3 days, 3 hours ago (2009-11-24 06:36:00)
by David
The "numbers" will be in a single column. Add a helper column with code such as =VALUE(A1). Sort on that column, then hide it from view.
David.
Started 1 month, 3 weeks ago (2009-10-05 06:44:00)
by Villeroy
menu:Data>Text to columns...
Started 2 days, 18 hours ago (2009-11-24 15:51:00)
by David
Why compare? Have you tried widening the cells to accommodate the text? Have you tried turning on text wrap within the cells?
David.
Started 2 days, 21 hours ago (2009-11-24 13:08:00)
by Villeroy
This is a very bad idea. A spreadsheet is not a sheet of paper. There is no reason to split equally structured data. This makes everything more difficult.
Use a single list and http://wiki.services.openoffice.org/wiki/Documenta tion/OOo3_User_Guides/Calc_Guide/DataPilot _________________ XUbuntu 9.04, OOo 3.1.1(Sun), Sun Java 1.5.0_06
Started 3 days, 16 hours ago (2009-11-23 17:46:00)
by matinee55
oh, forgot to say I uninstalled & reinstalled OO but to no avail!
Started 3 days, 12 hours ago (2009-11-23 21:36:00)
by JohnV
Try Edit > Paste Special > Unformatted text.
Started 1 month, 2 weeks ago (2009-10-08 03:53:00)
by ken johnson
I could only do it using a helper column in column D (can be elsewhere though).
Say names start in A2, then enter this in D2 and fill down to bottom row of data or further...
=IF(A2="";"";A2&COUNTIF($A$2:$A2;$A2))
this helper column could be hidden.
Enter this in C2 then fill down to bottom row of data or further...
=IF(D2="";"";IF(VALUE(MID(D2;LEN(A2)+1;255))>...
|
|
Hot threads for last week on OpenOffice.org Forum at OOoForum.org:
Started 1 week ago (2009-11-19 16:34:00)
by softwarezman
Hey everybody, I've been looking for the entire day to try and find code examples on how to do this. Here's my situation.
I have a form with a dropdown list that I want to use to filter another form. I DON'T want to filter the second form with a standard filter as it takes FOREVER to pull everything and THEN filter it. That and it impacts how I do internal form filters (clicking the ...
Started 4 days, 4 hours ago (2009-11-23 06:04:00)
by wbraat
I am re-writing an access database and have a list box with its source set to SQL. The SQL retrieves 5 or 6 columns and only displays the first column. I want the list box to be bound to the first column and to display the first column. That part works great. However, I would like to create a macro in the Change event of the list box to copy the other retrieved columns to other fields in...
Started 6 days, 16 hours ago (2009-11-20 18:24:00)
by David
Started 1 week ago (2009-11-19 11:17:00)
by Villeroy
Close the office
Rename your new profile folder ~/. openoffice.org/3/user
Restart the office
When the first start wizard detected the old version2 profile it asks you to take over the old settings. REJECT THIS. Something is broken with the profile import between v2 and v3.
Copy your templates, auto-text and stuff manually, re-install your needed extensions, import your Basic macros, ...
Started 1 week ago (2009-11-20 09:24:00)
by JohnV
Is this what your looking for?
=IF(ISNUMBER(A1);A1*1.25;IF(A1 = "NO COLOR";390;400))
"NO COLOR" is case sensitive.
Started 1 week ago (2009-11-19 14:17:00)
by pauliv_de
I'm using OOO 3.1.1 on WINXPPro
I need to make a big Poster which is 200cm wide and 100cm high.
Via basic macro with writer I place some textframes with Text inside, this works fine until a certain size. It seem to me there is a bug inside writer.
If the size of the textframe becomes more than around 116cm width then immediately the text inside the frame is adjusted only 1 ...
Started 1 week, 2 days ago (2009-11-18 01:13:00)
by rothers
Why did you choose OO over Excel in he first place ?
Started 3 days, 23 hours ago (2009-11-23 10:45:00)
by Robert Tucker
HEX2DEC ?
http://wiki.services.openoffice.org/wiki/Documenta tion/How_Tos/Calc:_HEX2DEC_function
or is it DEC2HEX you require:
http://wiki.services.openoffice.org/wiki/Documenta tion/How_Tos/Calc:_DEC2HEX_function _________________ Linux Fedora 12, Windows 7, OOo 3.1.1
Started 4 days, 4 hours ago (2009-11-23 05:49:00)
by robert99
For OpenOffice 3.1, what are the respective maximum number of rows that can be handled in Base and in Calc?
I can view all of a large registered database in the upper Window of Calc , but attempts at importing it fully into Calc just seem to hang indefinitely.
Started 1 week, 1 day ago (2009-11-18 19:31:00)
by pitonyak
Nice.... Seems to be a bug!
|
|