-
公开(公告)号:AT410740T
公开(公告)日:2008-10-15
申请号:AT00480056
申请日:2000-06-28
Applicant: IBM
Inventor: BAUCHOT FREDERIC , HARRARI ALBERT
Abstract: A named range defined by a cell address range in a spreadsheet comprises a plurality of cells identified in each dimension by an address, each dimension comprising two directions. An open named range is specifyed to the named range in at least one open direction. A hidden named range with the cell address range of the open named range is expanded by one address in every direction specified as open. In response to user action, at least one direction is selected, the cell address range of the hidden named range is increased by inserting between two consecutive cell addresses, a new address in selected directions, the open named range is updated with the cell address range of the hidden named range shortened by one address in every direction specified as open.
-
公开(公告)号:CA2357638C
公开(公告)日:2008-05-13
申请号:CA2357638
申请日:2001-09-24
Applicant: IBM
Inventor: BAUCHOT FREDERIC
Abstract: The present invention discloses a system and method for persistently copying and pasting a source range of cells onto one or multiple destination ranges of cells, in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address alo ng each dimension, a range of cells comprising one or a plurality of cells. The method comprises the steps of: .cndot. performing a persistent copy operation, said operation comprising th e steps of: .cndot. selecting a source range of cells; .cndot. copying the source reference range of cells onto a buffer; .cndot. performing a persistent paste operation, said operation comprising t he steps of: .cndot. selecting one or a plurality of cells a destination range of cells; for each selected destination range of cells: .cndot. copying the content of said buffer onto the selected destination ran ge of cells; .cndot. associating the source range of cells with the destination range of cells; .cndot. automatically performing a copy operation each time the source range of cells is updated, said operation comprising the steps of: .cndot. determining whether the source range of cells is associated with one or a plurality of destination range of cells; If the source range of cells is associated with one or a plurality of destination rangeof cells: .cndot. copying the source range of cells onto the one or plurality of associated destination range of cells.
-
53.
公开(公告)号:AU2006326213A1
公开(公告)日:2007-06-21
申请号:AU2006326213
申请日:2006-10-16
Applicant: IBM
Inventor: BAUCHOT FREDERIC , CLEMENT JEAN-YVES , SECONDO PIERRE , MARMIGERE GERARD
Abstract: A method and system for identifying an authentication status of a first item. An RFID reader transmits zero and a random number to a first RFID tag associated with the first item. The first RFID tag uses a hashing function to compute a hash (H1) of a concatenation of an identifier (Id1) of the first RFID tag, the random number, and a first secret key and sends the hash H1 to the RFID reader which then transmits the identifier Id1 and the random number to a second RFID tag. The second RFID tag uses the hashing function to compute a hash (H2) of a concatenation of the identifier Id1, the random number, and a second secret key and sends the hash H2 to the RFID reader. The authentication status of authentic or counterfeit is determined for the first item based on whether or not H1 is equal to H2.
-
公开(公告)号:CA2305968C
公开(公告)日:2007-05-08
申请号:CA2305968
申请日:2000-04-19
Applicant: IBM
Inventor: BAUCHOT FREDERIC , HARARI ALBERT
Abstract: The present invention discloses a system and method of processing a named range defined by a cell address range in a spreadsheet comprising a plurality of cells identified in each dimension by an address, each dimension comprising two directions. The method comprises the steps of defining an open named range by specifying to the named range at least one open directio n; defining a hidden named range with the cell address range of the open named range expanded by one address in every direction specified as open. In response to an user action, the method comprises the further steps of selecting at least one direction; increasing the cell address range of th e hidden named range by inserting between two consecutive cell addresses, a new address in selected directions; updating the open named range with the cell address range of the hidden named range shortened by one address in every direction specified as open.
-
公开(公告)号:DE602004003140D1
公开(公告)日:2006-12-21
申请号:DE602004003140
申请日:2004-02-27
Applicant: IBM
Inventor: AUREGLIA JEAN-JACQUES , BAUCHOT FREDERIC
IPC: G06F17/24
Abstract: A method and system for managing deletion operations in a recursive scalable template instance (RSTI) of an electronic data table having dimensions D1 and D2. The RSTI includes contiguous recursive element instances (REIs) ordered and aligned along D1. The REIs include scalable template instances (STIs). Contiguous elements are deleted, upon satisfying consistency condition(s), in a first STI. The RSTI is structured according to an associated recursive scalable template (RST) that includes a recursive element (RE) including at least one scalable template (ST). Each STI is structured according to an associated ST. The contiguous elements are structured according to a first ST associated with the first STI. A size of the first REI along dimension D1 is adjusted according to a size of a largest STI in the first REI. All REIs of the RSTI remain contiguous after the deleting and adjusting.
-
公开(公告)号:AT292302T
公开(公告)日:2005-04-15
申请号:AT02751061
申请日:2002-05-23
Applicant: IBM FRANCE
Inventor: BAUCHOT FREDERIC , ETORRE YVES-NICOLAS , HARARI ALBERT , SOLER CATHERINE
Abstract: System and program product are provided for facilitating on-line help information in an office application which includes one or more objects. The on-line help information is dependent on content of a selected object of the office application. A user of the office application is provided with help information setting forth an example directly derived from content of the currently selected object or cell. Content of a user entry field within the object is parsed to determine whether a predefined keyword is present, and if so, at least one parameter associated with the keyword and at least one format or rule related to the at least one parameter are identified. The at least one format and rule specified in the help information are employed in correcting content of the user entry field, for example, for display to the user.
-
公开(公告)号:FR2811788B1
公开(公告)日:2003-10-31
申请号:FR0105483
申请日:2001-04-24
Applicant: IBM CORP INTERNAT BUSINESS MAC
Inventor: BAUCHOT FREDERIC , MAUDUIT DANIEL , HARARI ALBERT
Abstract: The present invention relates to the field of information processing by digital computers, and more particularly to a method and system, in an electronic spreadsheet, of applying one or a plurality of user-defined options within one or a plurality of cells. The method comprises the steps of: defining for each option a boolean variable with a first value and a second value, preferably a "true" or "false" value; for each of said one or plurality of cells: referencing one or a plurality of boolean variables; associating a logical or mathematical operation with each boolean variable; for each of said one or plurality of referenced boolean variables in each of said one or plurality of cells: specifying a default value, said default value being defined as the value of the cell when the referenced boolean variable is set to the first value, preferably when the boolean variable is set to the "false" value; specifying a delta value by applying to the specified cell default value, the operation associated with the referenced boolean variable when the boolean variable is set to the second value, preferably when the boolean variable is set to the "true" value; setting each boolean variable to the first value or to the second value; for each of said one or plurality of cells: computing said one or plurality of delta values.
-
公开(公告)号:CA2357653A1
公开(公告)日:2002-04-24
申请号:CA2357653
申请日:2001-09-24
Applicant: IBM
Inventor: BAUCHOT FREDERIC
Abstract: The present invention relates to the field of information processing by digital computers, and more particularly to a method and system for persistently self replicating multiple ranges of cells through a copy-paste operation, in a multi dimensional spreadsheet comprisin g a plurality of cells identified by a cell address along each dimension, a range of cells comprising one or a plurality of cells The method comprises the steps of: ~ defining a set of ranges of cells, each range of cells having the same siz e; ~ each time the content of a range of cells belonging to this set is changed , automatically performing a self-replication operation, the self-replication operation comprising the steps of: ~ copying the changed range of cells onto a buffer; ~ determining the set of ranges of cells to which the changed range of cells belongs to; ~ identifying the ranges of cells belonging to the set; ~ pasting the content of the buffer in each of identified range of cells belonging to the set.
-
公开(公告)号:FR2811788A1
公开(公告)日:2002-01-18
申请号:FR0105483
申请日:2001-04-24
Applicant: IBM CORP INTERNAT BUSINESS MAC
Inventor: BAUCHOT FREDERIC , MAUDUIT DANIEL , HARARI ALBERT
Abstract: Definition of a true or false values to Boolean option variable in a computer spreadsheet, which are then used to control the contents of a range of cells within the spreadsheet. For each cell a one or more Boolean variables are assigned. Then for each cell the value of the Boolean variables within the cells are set according to the value of the Boolean option variable. If the value is false then the cell values take a default value, while if true then the variables take a delta value. Each Boolean variable in the cells is controlled by the first or second Boolean option value and for each cell in the considered range a delta value is calculated. Independent claims are included for (1) a system for assigning values in computer spreadsheets. (2) a computer program for assigning values in computer spreadsheets.
-
公开(公告)号:GB2522269A
公开(公告)日:2015-07-22
申请号:GB201400979
申请日:2014-01-21
Applicant: IBM
Inventor: BAUCHOT FREDERIC , CLEMENT JEAN-YVES , LEGRAND JEAN-MARC , ROUGEAUX FRANCOIS-RENE
IPC: H05K7/20
Abstract: The system includes a room or an enclosure in the form of parallel rows of rack servers separated by aisles to be cooled that is suitable for housing hardware components. The cooling system includes a first air input for controllably allowing input of outside air from outside the enclosure, a second air input for controllably allowing input of recycled air from the enclosure, a cooling mechanism, and an air output for allowing output of air into the enclosure. A control system includes a first temperature monitor for monitoring an outside air temperature, a second temperature monitor for monitoring a blowing air temperature of air at the air output, and a control mechanism for controlling an operation of the first air input, the second air input, the air cooling system in dependence on the monitored temperatures. Hygrometry control can be optimised and an override mechanism is provided in response to exceptional conditions outside of the enclosure. An elongate duct may be provided along and above the hardware racks (Figure 5b).
-
-
-
-
-
-
-
-
-