Tuesday, February 22, 2011

Creating and Mounting ISO CD images

Make an image
[root]# mkisofs -J -r -T -o newcd.iso /home/myfiles

Mount the ISO image file
[root]# mount -t iso9660 -o loop newcd.iso /mnt/test-cd

Burn CD image
[root]# cdrecord -v speed=2 dev='/dev/scd0' newcd.iso

Burn DVD image
[root]# dvdrecord -v speed=1 -dao dev=0,1,0 newcd.iso

Mount the CD-ROM
[root]# mount -t iso9660 -o loop /dev/hdc /mnt/cdrom

Sunday, February 20, 2011

Using Text in formula by using the INDIRECT function

Using Text in formula by using the INDIRECT function in OpenOffice Calc

Additional Link


C7=1
D7="Sheet1"
E1=2
Reference Sheet Name="Sheet1"
Current Sheet Name="Summary"

Formula:
=VLOOKUP($C7; INDIRECT(CONCATENATE($D7;".$B$3:$I$21")); E$1; 0)