From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.orgmode,gmane.emacs.help Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. Date: Tue, 29 Dec 2020 10:49:16 +0300 Message-ID: References: <87v9clnttt.fsf@robertthorpeconsulting.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="40501"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.0 (3d08634) (2020-11-07) To: emacs-orgmode@gnu.org, help-gnu-emacs Original-X-From: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Tue Dec 29 10:41:14 2020 Return-path: Envelope-to: geo-emacs-orgmode@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kuBVC-000AQe-TD for geo-emacs-orgmode@m.gmane-mx.org; Tue, 29 Dec 2020 10:41:14 +0100 Original-Received: from localhost ([::1]:34000 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kuBVB-0003Oi-Ts for geo-emacs-orgmode@m.gmane-mx.org; Tue, 29 Dec 2020 04:41:13 -0500 Original-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 Original-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 Original-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 Mail-Followup-To: emacs-orgmode@gnu.org, help-gnu-emacs Content-Disposition: inline In-Reply-To: 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+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-orgmode" Xref: news.gmane.io gmane.emacs.orgmode:134243 gmane.emacs.help:126895 Archived-At: * 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.