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

Hi Vince,

Using a new Calc table in column B1 I've entered the formula "=sum(A:A)"
and enter
No error revealed and the sum is updated in B1 after each discontinued
entries in the A column.

Best regards

 Version: 7.4.2.3 / LibreOffice Community
Build ID: 22949782292d40bc0751a2b0b2cf40927460a4f8
CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3
Locale: en-US (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Le 20/11/2022 à 17:42, Vince@Verizon a écrit :
> 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.


-- 
Jacques CHAILLET
1692, Route DN7
Quartier les fourques
83520 ROQUEBRUNE-SUR-ARGENS
+33 609 564 845


-- 
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