[libreoffice-users] Using A:A in LO Calc

Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; 
VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

_______________________________________________________


Hi:

Somewhere within Calc 7.3 there is a setting for allowing a full column 
range reference, e.g., [A:A], to be entered within a calc formula. I 
believe this functionality was added in Calc 5.0. I don't know if it is 
a global effect or is implemented on an individual spreadsheet basis.

I have used it once before, but am unable to locate it now. I seem to 
recall that there are three options available, including:

1. RxC
2. Excel format
3. ? can't recall, perhaps scientific notation?

Please help.

TNX for reading about my problem.

Regards,

VinceB.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy