>>>>> "USM" == USM Bish <[EMAIL PROTECTED]> writes:
USM> On Sat, Mar 30, 2002 at 05:41:45PM +0530, Raju Mathur wrote:
>> >>>>> "Shridhar" == Shridhar Daithankar
>> <[EMAIL PROTECTED]> writes:
>>
>> >> though.. Thanks Shridhar, will give this a try after
>> returning >> to Office at the end of this extended weekend
>> :-). Will it >> manage the cells with formulae in them ?
>>
Shridhar> That depends upon how xls exorts them. If it exports
Shridhar> them as value then it should be OK. IMO it shoudl do
Shridhar> that.
>> Come to think of it, why should you export calculated values
>> at all? A database isn't supposed to have fields whose values
>> can be calculated from other fields, though some databases
>> support (virtual) calculated fields.
USM> In principle, I agree with you Raju, the problem is, if I do
USM> a CVS import, I have no knowledge of how the computed fields
USM> are going to appear. If they are blanks or filled with
USM> correct values, fine. If they are going to be filled with
USM> some junk it is another bother
Copy the spreadsheet and paste special (values only) into a blank
sheet. Export that.
USM> [snip]
-- Raju
--
Raju Mathur [EMAIL PROTECTED] http://kandalaya.org/
It is the mind that moves
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
