Hi Tony,
It looks like development on NebulaXLite only goes to 2009. Does it work
with Jbase 3.4 on XP (32 bit)? I looked on your site and in the FAQ, but
it didn't really tell me.
Thanks,
Charlie
On 03-22-2013 11:15 AM, Tony Gravagno wrote:
From: Sathya
Hi experts..
I have one problem in creatin a spreadsheet report with date format.
One of the column in the spreadsheet is a date and it is displaying
as
numbers. Please help me in printing it as a date.
BTW I'm using OCONV to write the value to the column.
The problem isn't with MV. When you say "spreadsheet" people here
imply Excel, and I'm guessing that's what you mean too. What most
people do is they generate a CSV file with no formatting and then
expect Excel to format it in specific ways. The simple answer is, if
you just want text in Excel, put a single quote before the value:
123, abc, '3/22/2013
You can also force it to text like this using a formula:
="3/22"
The immediate response might be "but I want a Date column". OK, but
you're not doing anything to tell Excel that the column itself should
use date formatting.
[AD]
This is exactly the reason why I created NebulaXLite. It gives you any
kind of real Excel formatting of your choice for any cell, column, or
row. With nothing but BASIC, you can:
- use set fonts, colors, text rotation, and borders,
- set column widths and row heights
- merge cells, use hyperlinks, add comments to cells
- set document properties, add multiple worksheets in a workbook
- and documents open in Google Docs and OpenOffice
Compare all of that (and yes, much more) to plain old delimited text.
Lots of companies here use NebulaXLite. It's free for developers and
only a one-time purchase price of $200 for production end-user
systems. Support and enhancements are free.
http://Nebula-RnD.com/products/xlite.htm
[/AD]
HTH
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
http://Nebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
