|
More site info...
OpenOffice.org Calc | Forum profile
|
|
Forum profile page for OpenOffice.org Calc on http://www.oooforum.org.
This report page is the aggregated overview from a single forum: OpenOffice.org Calc, located on the Message Board at http://www.oooforum.org.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "OpenOffice.org Calc" on the Message Board at http://www.oooforum.org is also shown in the following ways:
1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on OpenOffice.org Calc:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
102
|
379
|
772
|
|
Post:
|
213
|
915
|
1,890
|
|
|
OpenOffice.org Calc Posting activity graph:
|
Top authors during last week:
user's latest post:
Payroll Spreadsheet help
Published (2009-12-09 15:06:00)
OK, since the right column with the SSN#s is already only the last four digits then there is no need for the RIGHT function, so try... =IF(A2="";"";VLOOKUP(A2;Table;2;0);4) Edit: Oops! I didn't remove all of the RIGHT function... =IF(A2="";"";VLOOKUP(A2;Table;2;0)) Ken Johnson
user's latest post:
[SOLVED] Sorting loses formatting
Published (2009-12-09 14:24:00)
brentjroberts wrote: That got it!! Thanks and have a Merry Christmas!! You're welcome. Thank you, and merry Christmas to you, too. Now if you will, edit your first post in the thread, and add [Solved] to the subject line. Then it will appear in the subject list of the forum, and so makes it easier for other users to find what they need. A more precise subject line, like "Sorting loses formatting", might be useful too.
user's latest post:
Default cell size at startup...
Published (2009-12-09 09:15:00)
First try this: File > Templates > Organize. Right click My Templates - if you have any Default Templates defined then Reset Default Template will appear at the bottom of the list. If it does then select it and if Calc Document then appears select it. If that doesn't work then you probably have a glitch in your user profile which we can fix but that's pretty drastic as it deletes all you personal setting. An...
user's latest post:
MySQL and Calc Integration
Published (2009-12-07 03:10:00)
I have such a code: Which takes some value from database and put it in cell "C13" in "sheet2" Code: SQLQuery = "SELECT ""ID"" FROM ""BOOK"" WHERE ""NAME"" = 'YELLOW'" Statement = Connection.createStatement RowSetObj=Statement.executeQuery (SQLQuery) While...
user's latest post:
[SOLVED] Error in formula
Published (2009-12-07 07:31:00)
Ok thanks for the information. There is so many way to write a expression that some time it's confusing (for me) Thanks again for your time to explain Phil
user's latest post:
Problem with Select All
Published (2009-12-08 15:07:00)
[quote="IrnBru001"]I My two biggest headaches both relate to how Calc understands 'select all.' When using select all Calc selects the entire spreadsheet including all null rows and columns. So select all, selects all rows from 1 - 65536 and all columns A - AMJ, even when data might only exit for columns A1 - B3. This probably happens because Select All means select all ? I believe Lotus 123 had find last active...
user's latest post:
'vakue'
Published (2009-12-07 07:53:00)
Possibly a Mandriva Build Issue: How are the cells formatted? Text or Number? Does changing the format to Number do anything? > Also why can't I copy from openoffice to an email? I imagine it would fill up the forum servers - forum messages are text only and you can only link to other objects.
user's latest post:
SOS:need to recover corrupt ods...
Published (2009-12-08 04:48:00)
I used file recovery to look for erased backups and found some on portable ooo usb stick and my main pc. i could resore about 18 files. most of them were incomplete but i was hoping to salvage a content.xml file for merging with mij broken file. Lucky i was to salvage a working copy of my ods file just a week old. 7 days of data is better then many months. Im Saved so far. but regarding to the origins of the error. i hope someone at ooo can...
user's latest post:
SOS:need to recover corrupt ods...
Published (2009-12-07 02:56:00)
mercierb wrote: I am not familiar with the procedure in Windows, so I don't know if winrar is the good product to use. When in Windows, I often used the builtin Winzip utility. Think you have to activate it. Besides this I used also the WinZip program. In that time it was free, but now I see you have to pay for it, but there is a 14-day trial possibility. OK I booted the XP Windows machine. Cerated a new directory repair-ods copied the...
|
|
|
|
Latest active threads on OpenOffice.org Calc::
Started 3 days, 1 hour ago (2009-12-08 20:48:00)
by ken johnson
VLOOKUP in combination with RIGHT can return the last 4 digits.
Say somewhere in the document is a two column table, named "Table" and with first column Employee Name and second column SNN#.
When you use the column A drop down selection list to select Mickey Mouse in A2, the formula in B2 could be...
=IF(A2="";"";VALUE(RIGHT(VLOOKUP(A2;Table;2;0);4) ))
The VALUE function ...
Started 2 days, 6 hours ago (2009-12-09 14:59:00)
by ken johnson
=IF(Jan.C10="";"";Jan.C10)
if you don't want a 0 (zero) returned when Jan.C10 is blank.
=Jan.C10 if the 0 doesn't matter.
Ken Johnson
Started 2 days, 8 hours ago (2009-12-09 12:56:00)
by keme
Avoid the sort buttons on the tool bar.
Use menu command Data - Sort .
Select tab Options , and ensure that Include formats is ticked.
Otherwise, formatting will stick to the cell position instead of moving with the data.
Started 2 days, 12 hours ago (2009-12-09 09:15:00)
by JohnV
First try this:
File > Templates > Organize.
Right click My Templates - if you have any Default Templates defined then Reset Default Template will appear at the bottom of the list. If it does then select it and if Calc Document then appears select it.
If that doesn't work then you probably have a glitch in your user profile which we can fix but that's pretty drastic as it deletes ...
Started 2 days, 12 hours ago (2009-12-09 08:55:00)
by ken johnson
If the time is in A1 then try...
=ROUND(A1*24*60;0)/(24*60)
in a cell that has hh:mm time format.
The 24 comes from 24 hours per day and the 60 from 60 minutes per hour.
Ken Johnson
Started 2 days, 16 hours ago (2009-12-09 05:34:00)
by ken johnson
=IF(VALUE(A2:J2)=0;"";(A1:J1)/(A2:J2)) as an array formula returns...
{""; 2.5;1.11;1;"";1;1;"";1;10}
MIN(IF(VALUE(A2:J2)=0;"";(A1:J1)/(A2:J2))) returns 1
The first occurrence of this minimum is given by...
=MATCH(MIN(IF(VALUE(A2:J2)=0;"";(A1:J1)/(A2:J2))) ;IF(VALUE(A2:J2)=0;"";(A1:J1)/(A2:J2));0) which returns 4 ie the fourth column, column D.
What do you need to do ...
Started 3 days ago (2009-12-08 20:56:00)
by ken johnson
I'm not up to Calc macros yet but with VBA I used to inspect the code produced by the macro recorder when I wasn't sure about a method or property.
I turned on Calc's macro recorder, pressed F9 then stopped recording. The resulting macro code is...
Code: sub Main
rem -------------------------------------------------- --------------------
rem define variables
dim...
Started 3 days, 6 hours ago (2009-12-08 15:07:00)
by jrkrideau
[quote="IrnBru001"]I
My two biggest headaches both relate to how Calc understands 'select all.' When using select all Calc selects the entire spreadsheet including all null rows and columns. So select all, selects all rows from 1 - 65536 and all columns A - AMJ, even when data might only exit for columns A1 - B3.
This probably happens because Select All means select all ? I believe ...
Started 2 days, 15 hours ago (2009-12-09 06:40:00)
by Steven_Shelton
varunchandwani wrote: I am making three columns
Hour StartDate EndDate
what i want is if number of hours exceed by 8 for a particular date then automatically next date should be considered i.e. next date :shock:
I'm not entirely sure I understand the problem. Can you try to re-phrase it?
|
|
Hot threads for last week on OpenOffice.org Calc::
Started 6 days, 16 hours ago (2009-12-05 05:03:00)
by Ronin36
i run windows xp and open office 3. no ms office.
yesterday i saved my .ods file to my nas. like allways. no problems.
but when i came back from training and wanted to open it, i got a "Fout in indeling in subdocument content.xml op positie 2,7017(rij,kolom)"
after googeling i tried: - Copying origional file for testing.
- Opening if with ooo2 portable, it gave the same error....
Started 6 days, 5 hours ago (2009-12-05 16:03:00)
by SlideRule
Because, the parentheses do NOT match.
The number of left parenthesis ( must be the same as the number of right parenthesis ) .
In your formula above, you have 26 left parenthesis, but 25 right parenthesis.
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post title ( edit button ) if your ...
Started 3 days, 1 hour ago (2009-12-08 20:48:00)
by ken johnson
VLOOKUP in combination with RIGHT can return the last 4 digits.
Say somewhere in the document is a two column table, named "Table" and with first column Employee Name and second column SNN#.
When you use the column A drop down selection list to select Mickey Mouse in A2, the formula in B2 could be...
=IF(A2="";"";VALUE(RIGHT(VLOOKUP(A2;Table;2;0);4) ))
The VALUE function ...
Started 1 week, 1 day ago (2009-12-03 05:14:00)
by Villeroy
You described cells that have nothing to do with error J13. The precedents of J13 would be more interesting.
Select J13
Tools>Detective>Trace Error
Started 1 week ago (2009-12-04 09:23:00)
by Robert Tucker
For fractions over 32, I think:
Code: =INT(C8)&" "&INT((C8-INT(C8))/0.03125)&"/32"
Not (yet) worked out how to get it to automatically give it as quarters, eighths and sixteenths. I think it may be necessary/advisable to define a function to do so.
Started 4 days, 10 hours ago (2009-12-07 11:15:00)
by oaruhkul
I over wrote a Calc file by accident. When I tried to restore it from a backup, it was corrupted. I had exported the Calc file to a PDF file. Is there anyway to get get the PDF file back into Calc preserving the fields, text style etc. ??? This would save me the trouble of re-entering 22 pages of spreadsheet info .......
Started 6 days, 16 hours ago (2009-12-05 05:09:00)
by ken johnson
Say the account number is in A2 on each sheet and the data validity drop down list with the different sheet names is in A1, then...
=IF(A1="";"";INDIRECT("'"&A1&"'.A2"))
will return the appropriate account number.
Ken Johnson
Started 4 days, 12 hours ago (2009-12-07 09:29:00)
by mbaggia
This my first post on this forum, so first of all, hello!
I'm trying to create a spreadsheet to calculate wages, based on different pay rates.
So far I have successfully got total number of hours worked, by doing:
A1 = Start time
A2 = Finish time
A3 = Start break time
A4 = Finish break time
Hours worked in cell A5 is thus:
=(A2-A1)-(A4-A3)
I ...
Started 2 days, 12 hours ago (2009-12-09 08:55:00)
by ken johnson
If the time is in A1 then try...
=ROUND(A1*24*60;0)/(24*60)
in a cell that has hh:mm time format.
The 24 comes from 24 hours per day and the 60 from 60 minutes per hour.
Ken Johnson
Started 4 days, 2 hours ago (2009-12-07 19:53:00)
by redeville
Hi All,
I encountered problem when reading the date field from CALC document.
I used xCell = xSheet.getCellByPosition(CellY, CellX);
and
System.out.println(xCell.getFormula());
to print the value of the field which is in date format.
I got the followings:
For 4 jan 2009, it printed as 39817
For 9 jan 2009, it printed as 39822
For 4 jan 2009, it ...
|
|
Size: 958 bytes
