Thanks for the upcoming correction. I assume that the behavior for "Paste value and format" as well as the other paste icons has been verified/corrected as well ?
Cheers.
Search found 8 matches
- Sun Jul 26, 2026 5:11 pm
- Forum: BETA: PlanMaker NX and 2026 for Linux
- Topic: copying/pasting a formula
- Replies: 5
- Views: 1195
- Sat Jul 25, 2026 5:28 pm
- Forum: BETA: PlanMaker NX and 2026 for Linux
- Topic: copying/pasting a formula
- Replies: 5
- Views: 1195
Re: copying/pasting a formula
Indeed it does paste properly when the shortcut "Paste" icon is selected. However, if you select the "Paste formula" it does not work; it only copies the formula to A3 and not to the full range selected (say A3 to A7), at least in the french version running on my LinuxMint computer.
Thanks for your ...
Thanks for your ...
- Thu Jul 23, 2026 2:30 pm
- Forum: BETA: PlanMaker NX and 2026 for Linux
- Topic: copying/pasting a formula
- Replies: 5
- Views: 1195
copying/pasting a formula
Hello,
Just wondering how to get the following to work:
Say I input the number 1 in cell A1 and then in Cell B1 I insert the formula : A1+1
And then I wish to copy the formula contained in B1 to a range of cells to the right (say from C1 to F1). If I use the copy function on B1 and then paste ...
Just wondering how to get the following to work:
Say I input the number 1 in cell A1 and then in Cell B1 I insert the formula : A1+1
And then I wish to copy the formula contained in B1 to a range of cells to the right (say from C1 to F1). If I use the copy function on B1 and then paste ...
- Thu Apr 11, 2024 10:11 pm
- Forum: PlanMaker 2024 for Windows
- Topic: Convert numbers stored as text to numbers
- Replies: 2
- Views: 37807
Re: Convert numbers stored as text to numbers
I followed your procedure but with slight changes:
When loading the CSV file, in the left side of the dialog box I checked "decimal separator" and also "thousands separator". In the right side I used "Separator->Semicolon" and I also checked the "Extended number scanning" box as you recommended.
I ...
When loading the CSV file, in the left side of the dialog box I checked "decimal separator" and also "thousands separator". In the right side I used "Separator->Semicolon" and I also checked the "Extended number scanning" box as you recommended.
I ...
- Mon Apr 08, 2024 1:50 pm
- Forum: PlanMaker 2024 for Windows
- Topic: Convert numbers stored as text to numbers
- Replies: 2
- Views: 37807
Convert numbers stored as text to numbers
Hello,
I'm using data tables extracted from the Statistics Canada website. The download format is in CSV.
I can import the files in Planmaker. The data tables contained in the files appear as a normal spreadsheet data (one number in each cell). The columns of numbers displayed look OK but the ...
I'm using data tables extracted from the Statistics Canada website. The download format is in CSV.
I can import the files in Planmaker. The data tables contained in the files appear as a normal spreadsheet data (one number in each cell). The columns of numbers displayed look OK but the ...
- Fri Jan 05, 2024 6:03 pm
- Forum: PlanMaker 2021 for Mac
- Topic: Linking data from Spreadsheets
- Replies: 9
- Views: 324735
Re: Linking data from Spreadsheets
What I meant is that one cannot press = then use the mouse and point/clic directly to a cell in a sheet from another file (to link both cells in a formula) as can be done in Exel and LibreOffice for instance. I couldn't get it to work.
But as you indicate, PlanMaker does allow you to link in its ...
But as you indicate, PlanMaker does allow you to link in its ...
- Thu Jan 04, 2024 8:05 pm
- Forum: PlanMaker 2021 for Mac
- Topic: Linking data from Spreadsheets
- Replies: 9
- Views: 324735
Re: Linking data from Spreadsheets
Thank you for your answer and providing a solution.
Are there any intentions in enabling linking two cells from sheets in different files using the equal sign as can be done linking two cells from two sheets of a given file ?
-mg
Are there any intentions in enabling linking two cells from sheets in different files using the equal sign as can be done linking two cells from two sheets of a given file ?
-mg
- Thu Jan 04, 2024 3:40 pm
- Forum: PlanMaker 2021 for Mac
- Topic: Linking data from Spreadsheets
- Replies: 9
- Views: 324735
Re: Linking data from Spreadsheets
Hello, I have a similar issue trying to link two spreadsheets contained in two different files (tes1.xlsw and test2.xlsw), using Planmaker running in win11.
If the two sheets are within the same file I can link cells from one to the other (say in a formula). However, if the two sheets are in two ...
If the two sheets are within the same file I can link cells from one to the other (say in a formula). However, if the two sheets are in two ...