From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id f200A8P56l8nTgAA0tVLHw (envelope-from ) for ; Tue, 29 Dec 2020 09:41:23 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id iOxfOsL56l/IOAAAB5/wlQ (envelope-from ) for ; Tue, 29 Dec 2020 09:41:22 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 6C865940274 for ; Tue, 29 Dec 2020 09:41:22 +0000 (UTC) Received: from localhost ([::1]:34000 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kuBVJ-0003Oi-AO for larch@yhetil.org; Tue, 29 Dec 2020 04:41:21 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:52892) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kuBUf-0003MU-S8; Tue, 29 Dec 2020 04:40:43 -0500 Received: from stw1.rcdrun.com ([217.170.207.13]:40283) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kuBUZ-0006wN-9c; Tue, 29 Dec 2020 04:40:41 -0500 Received: from localhost ([::ffff:41.210.145.189]) (AUTH: PLAIN securesender, TLS: TLS1.2,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 000000000029535C.000000005FEAF98F.000005BD; Tue, 29 Dec 2020 02:40:31 -0700 Date: Tue, 29 Dec 2020 10:49:16 +0300 From: Jean Louis To: emacs-orgmode@gnu.org, help-gnu-emacs Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. Message-ID: Mail-Followup-To: emacs-orgmode@gnu.org, help-gnu-emacs References: <87v9clnttt.fsf@robertthorpeconsulting.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.0 (3d08634) (2020-11-07) Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -1.83 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: 6C865940274 X-Spam-Score: -1.83 X-Migadu-Scanner: scn0.migadu.com X-TUID: sYLRKK0t5T8+ * Hongyi Zhao [2020-12-29 07:55]: > From this point of view, if we want to have both full-features and > powerful capabilities in manipulating spreadsheet, it seems that only > the python based programmatic tools/packages, say, openpyxl > , can meet the requirements > currently. What are you requirements? - do you also use charts? - do you personally use spreadsheet or multiple people have to enter data? - how many rows do you enter over months, or years? - are there complex formulas to be followed? - if not secret, you can as well show the table of your data to see here Then people reading the mailing list may help you better with advise how to proceed. For some new data coming over and over again I will almost always use a database to track it. Example is weekly statistics, as that is something I may keep for years in a database and see slices in various periods of times. Another example of keeping it in the database are geological coordinates like latitude and longitude that may have plethora of various notations and geographic datums. Such coordinates can belong to a set of coordinates and set of coordinates could be something like a route or something like area. A route would be drawn differently and linearly and area would be drawn differently, by connecting the begin and end position. Similar things may be accomplished with spreadsheets as well where some columns can determine the type of the column with the drop down list. Example of a cell of a spreadsheet with type-like+ Column A Column B + +-------------------++-----------------+ | Mr. Joe Doe || From website | +-------------------+| From poster | | By partner | | By radio | +-----------------+ When you wish to determine a type for specific entry spreadsheet programs do offer that, I just find it so much harder then using the SQL database. Once you explain your data entry and your need I will see if I can help.