asked 2012-05-10 16:49:58 +0200

I have set an addresses as "A1+B1", "A2+B2", etc. When I reopen the file, all the references to address default to $A$1+$B$1, etc. Is there anyway to set the default for the entire sheet/file? Or have them remain as entered?

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2012-05-10 20:10:33 +0200

Janus Troelsen
31 ● 1

Are you saving to the OpenDocument format (.ods)? If not, there might be conversion problems.

link delete flag offensive edit

Comments

It only happens to one .xls file. Other file, the calculation formula remains the same. I'll try saving it as an .ods and see if there are changes.

joaquinx ( 2012-05-11 18:11:36 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-05-10 16:49:58 +0200

Seen: 59 times

Last updated: May 10 '12

absolute address