On Tue, 9 May 2006 12:29 am, Dennis Marks wrote: > "Dan Lewis" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > On Sunday May 7 2006 05:06 pm, Dennis Marks wrote: > >> I have created a time sheet in a Writer document. There is > >> a table with dates that are generated using a starting > >> date. It all works fine as long as I don't use any > >> functions. > >> > >> What I was trying to do is create a label for the second > >> half of the month. It will be either 16-28, 16-29, 16-30, > >> or 16-31 depending in the number of days in the month. I > >> don't seem to be able to use any type of function to create > >> this. Both logic and date functions are ignored and only > >> the date within the function is displayed. Is this a bug or > >> a limitation of tables? > > > > I was able to do this in Calc but not in a Writer table. > > It is possibility a limitation of tables. > > This is what I did in Calc. > > I set a date in the month in A1. > > In B1, I entered this formula: > > ="16"&" - "&TEXT(DAY(A1);DAY(EOMONTH(A1;0))). > > > > Dan > > I know how to do it in calc. The problem is that I do a mail > merge to create a time sheet for each employee. I'll just > leave the heading 16-31.
I'm not an expert in the use of OO, nor do I entirely understand what you wish to do. However is it not possible to create your table in Calc and then copy/paste the relevant section to the text document. Or perhaps in writer use Insert/Object/OLE object/Spreadsheet Malcolm Kay --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
