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+unsubscr...@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