.xlsm in Libre Office

J_B

I'm doing an OFGEM RHI application but they need me to fill in their HLA 1.4.xlsm (heat loss assessment)
https://www.ofgem.gov.uk/publications-and-updates/heat-loss-assessment-questionnaire
but, although I can open it in Libre Office Calc I am unable to enter data into some of the boxes.

Help!!

bod1467

LibreOffice may not handle Macro files very well. (That's what the M in xlsm means).

Can you not find someone to let you use their PC with MS Excel on it?

J_B

bod1467 wrote: »

LibreOffice may not handle Macro files very well. (That's what the M in xlsm means).

Can you not find someone to let you use their PC with MS Excel on it?

Yes, did that ... his PC had a virus but I didn't have time to fix it - going on hols tomorrow!! :mad:

gb12345

bod1467 wrote: »

LibreOffice may not handle Macro files very well. (That's what the M in xlsm means).

If LibreOffice is anything like OpenOffice in its macro handling (and I don't believe that the Libre project have done work on it to make it Excel compatible) then there is no way to run Excel macros as there are a number of fundamental differences between the syntax of VBA and the Open/LibreOffice versions of basic.

J_B

Sorry to drag this up again

Just looked on Flea Bay and seen M$ Office Starter Lean Version
http://www.ebay.co.uk/itm/Microsoft-Office-2010-Starter-Word-Excel-Only-Lean-Version-for-Windows-7-Vista-/310806893119

Would this do .xlsm files??

johnmc

Try the Excel Viewer;
http://www.microsoft.com/en-gb/download/details.aspx?id=10

J_B

johnmc wrote: »

Try the Excel Viewer;
http://www.microsoft.com/en-gb/download/details.aspx?id=10

But I need to work on the 'macro enabled' spreadsheet, not just view it.

gb12345

J_B wrote: »

Sorry to drag this up again

Just looked on Flea Bay and seen M$ Office Starter Lean Version
http://www.ebay.co.uk/itm/Microsoft-Office-2010-Starter-Word-Excel-Only-Lean-Version-for-Windows-7-Vista-/310806893119

Would this do .xlsm files??

The ad says that the Excel version included is "Excel Starter". According to this feature list, Excel Starter will open .xlsm files.

J_B

gb12345 wrote: »

The ad says that the Excel version included is "Excel Starter". According to this feature list, Excel Starter will open .xlsm files.

I'm here again

Just got round to trialling my newly installed MS Office Starter

Well, they didn't lie ... it will open .xlsm files, but sadly, it won't then let me work on them :mad: it wants me to buy the 'proper' version.

Which is the best deal for M$ Office for an occasional user on Win7???