Thank you very much! The paste now works for me.
My software is offline, so if this issue was addressed earlier, my apologies.
I prefer to use Planmaker over others for its file compatibility, speed and ease of use.
Thanks again for your help!
Search found 20 matches
- Thu Apr 03, 2025 1:01 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Bug report - please fix - re: paste unformatted
- Replies: 5
- Views: 12513
- Wed Apr 02, 2025 5:27 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Bug report - please fix - re: paste unformatted
- Replies: 5
- Views: 12513
Bug report - please fix - re: paste unformatted
Hi, This problem was reported in a previous post re: copying and pasting as unformatted text into a new sheet, using the attached file. Please open the attached file and try these steps: 1 select all of the data 2 Edit>Copy 3 open a new sheet 4 Edit>Paste Special>Paste as: Unformatted text, uncheck ...
- Thu Mar 27, 2025 12:17 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Paste as text does not include all decimals
- Replies: 5
- Views: 22589
Re: Paste as text does not include all decimals
Hi, Thank you for this - I will make a note of it. Perhaps greying out the paste formatting check boxes, when paste as unformatted text is selected, would be less confusing for users like me. If the selection is not done correctly, the pasted results will be incorrect, and not necessarily noticed, w...
- Wed Mar 26, 2025 3:52 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: selecting data in sheet
- Replies: 5
- Views: 8566
Re: selecting data in sheet
Please see my previous post regarding pasting of decimals - I added some information on how to reproduce the problem.
Thanks
Thanks
- Wed Mar 26, 2025 3:49 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: selecting data in sheet
- Replies: 5
- Views: 8566
Re: selecting data in sheet
Hi, Unfortunately, I cannot remember the situation which caused my enquiry. Today, when I try the selection in Planmaker and in other spreadsheets, the behaviour seems to be the same in all of them. My apologies for not being more helpful - if I encounter the situation again I will add it to this th...
- Wed Mar 26, 2025 1:00 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Paste as text does not include all decimals
- Replies: 5
- Views: 22589
Re: Paste as text does not include all decimals
Hi, Please try these steps: 1 select all of the data 2 Edit>Copy 3 open a new sheet 4 Edit>Paste Special>Paste as: Unformatted text, uncheck All under Paste formatting 5 review numbers in column F, and note that cell F7 pasted as 32970 and not 329.70, cell F11 pasted as 17220 and not 172.20 etc. In ...
- Wed Mar 26, 2025 12:50 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: selecting data in sheet
- Replies: 5
- Views: 8566
Re: selecting data in sheet
Hi,
If you are at cell A1, the rectangle is to the left of the A in column A and above the 1 in row 1.
Thanks
If you are at cell A1, the rectangle is to the left of the A in column A and above the 1 in row 1.
Thanks
- Tue Mar 18, 2025 11:46 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Paste as text does not include all decimals
- Replies: 5
- Views: 22589
Re: Paste as text does not include all decimals
Pasting into other spreadsheets has mixed results - some include all decimals and others don't.
When looking at the clipboard data, all decimals are shown.
When looking at the clipboard data, all decimals are shown.
- Mon Mar 17, 2025 8:16 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Paste as text does not include all decimals
- Replies: 5
- Views: 22589
Paste as text does not include all decimals
Hi, In the attached file, I copied the cells, then opened another instance of Planmaker and pasted the clipboard data as Unformatted text with no formatting. In the pasted sheet, cells which had only one digit after the decimal place pasted as a number without the decimal place. This does not happen...
- Mon Mar 17, 2025 8:07 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: selecting data in sheet
- Replies: 5
- Views: 8566
selecting data in sheet
Hi, In another popular spreadsheet, you can easily select all cells containing data by clicking on the rectangle at the top left of the cells. That will select only cells which contain data. However, in Planmaker this will action select all cells in the sheet (over a million rows). Could it be chang...
- Thu Sep 19, 2024 5:08 pm
- Forum: BasicMaker NX and 2024 for Windows
- Topic: getting last row in spreadsheet
- Replies: 1
- Views: 6122
Re: getting last row in spreadsheet
OK - it looks like the EOF function will accomplish this.
Thanks
Thanks
- Mon Sep 16, 2024 9:11 pm
- Forum: BasicMaker NX and 2024 for Windows
- Topic: getting last row in spreadsheet
- Replies: 1
- Views: 6122
getting last row in spreadsheet
Hi,
It would be nice to get the last populated row as a Planmaker range property. It could then be used as the upper bound in loops.
Thanks
It would be nice to get the last populated row as a Planmaker range property. It could then be used as the upper bound in loops.
Thanks
- Mon Sep 16, 2024 3:59 pm
- Forum: BasicMaker 2021 for Windows
- Topic: Simple Question: How to locate the last populated cell in a column of a PlanMaker worksheet?
- Replies: 2
- Views: 31555
Re: Simple Question: How to locate the last populated cell in a column of a PlanMaker worksheet?
I second this request - it would make BasicMaker more useful for programming Planmaker.
- Tue Sep 10, 2024 8:43 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: no decimals in csv export
- Replies: 3
- Views: 9854
Re: no decimals in csv export
Thank you for your help. The problem must have been with the file that I was exporting to csv. When I create numbers manually and export as csv it works fine.
- Thu Sep 05, 2024 10:20 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: no decimals in csv export
- Replies: 3
- Views: 9854
Re: no decimals in csv export
The decimals are exported when exporting with the default additional options csv export, but not when just .csv export is chosen.