I am new to OpenOffice, hope I am not duplicating a topic. Couldn't find one similar.

I am trying to create a workbook using one sheet for inventory (SKU, Items, Cost per Item) and a second sheet for an invoice that will autofill product descriptions when entering the SKU. I was able to create this in Excel but having no success whatsoever in Calc! Cannot even get the invoice to link to the items sheet much less the formulas to make the invoice work! Here's the extra issue...

An extra step is needed for items that are priced by length. Example: 8"-wide metal roofing is $ 1.00 per inch. I was willing to write it up as total inches but customers like to see the Feet/Inches so they know they're getting 4 lengths of metal that is 8' 3" each. The invoice should appear:

(see attachment)

I cannot get anything to work in Calc but really like its options and the idea of using OpenOffice instead of Windows. If anyone can offer help it would be GREATLY APPRECIATED.

Where to begin, where to find an easy-to-understand how-to for formulas. I have searched our library system and unable to find anything about Calc formulas. THANK YOU